How to get rid of dbo in field names?

Hello,
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.
Any suggestions?
Thanks in advance!!!!
--Jon
What are the login credentials of your application? Is it qualifying objects
with a different owner name? If so, s_changeobjectowner might help you.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"code" <code@.community.nospam> wrote in message
news:3BD82441-93C0-4CC9-A466-DD1E76291669@.microsoft.com...
> Hello,
> 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.
> Any suggestions?
> Thanks in advance!!!!
> --Jon

How to get hold of data from web provider using SQL Server?

I am new to SQL server so apologies if this is a stupid question.
I have a website built and hosted by another company, with SQL server back end data. They don't want to analyse the data but I do. I am familiar with SQL and have SQL server express running on my laptop.
So I was thinking I could get them to send me the data from the server (it will be less than 1GB I imagine), and I could analyse it myself.
So my questions are:
will this work?
and what do I ask them to send me? Is it just a couple of files they have to copy and send me? Or is it more complicated than that?
Many thanks for any advice you can offer.
James

Have them back up the database and send the backup file to you. Restore it on your system and you're ready to go. This will work as long as the version of SQL Server they have (200 or 2005) is equal to or less than the one you have.

Buck Woody

How to get hold of data from web provider using SQL Server?

I am new to SQL server so apologies if this is a stupid question.

I have a website built and hosted by another company, with SQL server

back end data. They don't want to analyse the data but I do. I am

familiar with SQL and have SQL server express running on my laptop.

So I was thinking I could get them to send me the data from the server

(it will be less than 1GB I imagine), and I could analyse it myself.

So my questions are:

will this work?

and what do I ask them to send me? Is it just a couple of files they

have to copy and send me? Or is it more complicated than that?

Many thanks for any advice you can offer.

James

Have them back up the database and send the backup file to you. Restore it on your system and you're ready to go. This will work as long as the version of SQL Server they have (200 or 2005) is equal to or less than the one you have.

Buck Woody