March 14, 2007 at 7:26 am
One of my database is a web site application and migrated from 2000 to 2005. I noticed that the table names are now prefixed by "DBO." which I think is causing the website application not to function. It worked fine in 2000.
I don't know how to remove this prefix purely to eliminate this issue. Is there anything else I could do to test. Thanks in advance. Ram
March 14, 2007 at 7:35 am
Hello Ramesh,
By default, in SQL Server 2005, a table is defaulted to the "dbo" schema. You can select the results without the "dbo" prefix from the queries as usual.
By the way, what sort of error message you are getting?
If you can give more details, then somebody can help you.
Thanks
Lucky
March 14, 2007 at 9:49 am
The user your application uses may not have rights to the new schema. Might check the security. Trace some executions and see if it's the problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply