Hi David,
Welcome to use MSDN Managed Newsgroup!
I have also noticed you post a duplicated post in
microsoft.public.sqlserver.programming. To keep the integrity of newsgroup,
I will reply here for your question and follow-up question.
Generally speaking, it would be painless when you are using SQL Server 2005
Express.
However, I would like to inform you the new security feature of SQL Server
2005 - User-Schema Separation. A schema is a collection of database
entities that form a single namespace in SQL Server 2005. A namespace is a
set in which every element has a unique name.
For example, to avoid name collisions, no two tables in the same schema can
have the same name. Two tables can have the same name only if they are in
separate schemas. For more information, check the topic below
User-Schema Separation
http://msdn2.microsoft.com/en-us/library/ms190387.aspx
For example, if you specifying the object accounting.ap.user.reconciliation
in the application, you may need to change it as
accounting.ap.schema.reconciliation accordingly.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.