How to get rid of dbo in field names? - 09-01-2005 , 10:02 AM
I just converted a website database from MS Access to SQL 2000, and many of
the pages are not working because SQL now wants fields to be ref'd as
"dbo.<<fieldname>>"... I've fixed this before, but cannot remember how... If
I cannot fix it through the database / connection, I'll have hundreds of
lines of code to modify.
Thanks in advance!!!!
Re: How to get rid of dbo in field names? - 09-01-2005 , 11:46 AM
What are the login credentials of your application? Is it qualifying objects
with a different owner name? If so, s_changeobjectowner might help you.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"code" <code (AT) community (DOT) nospam> wrote