Re: CF sort of "fully qualified objects"

[EMAIL PROTECTED] wrote: > All, > > I'm using SQL Server and we login in under an account other than dbo > When I do my cfquery's, they won't work select * from tablename unless > I use select * from username.tablename. > > Why is this and do I want to use fully qualified objects? > > Thanks. >

Re: CF sort of "fully qualified objects"

In your SQL Enterprise Manager, open a new SQl Query Analyzer. Type: sp_changeobjectowner 'tablename','dbo' This eliminates the need to have to reference the object by the name of the table. When dbo is the owner, any user who has access to the database can see that table wihtout prefixing it.

Re: CF sort of "fully qualified objects"

Is username in this case the name of the username that you're logged in as, or dbo? In other words, are you having to do select * from dbo.tablename or select * from myuser.tablename If it's the second, then your tables are not being created as dbo-owned tables, and your create table statem

CF sort of "fully qualified objects"

All, I'm using SQL Server and we login in under an account other than dbo When I do my cfquery's, they won't work select * from tablename unless I use select * from username.tablename. Why is this and do I want to use fully qualified objects? Thanks. D ~