just a quick question about data adapter wizard

[Guest]

hey all,

when you use the sql data adapter wizard and look at the code behind, the
sql statement looks like the following:
select * from dbo.products

why is the dbo. prefix added? is there a way to change that. It's not
causing any major problem, just wanted to know more about it.

thanks,
rodchar

 

[Bernie Yaeger]

Hi,

"The dbo is a user that has implied permissions to perform all activities in
the database", per sql server help. The idea is to ensure that you can
connect, regardless of the permissions of a given user. Enterprise Manager
in sql server itself does this all the time. FOr example, if you try to run
a query on a table, this is what appears:
SELECT *
FROM [dbo].[a_rbal_k]

I wouldn't wish to change it, and I don't think you can, except by going
into the code behind itself and removing it, but I don't see what value this
would serve.

Bernie Yaeger