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. Teddy On 10/5/06, [EMAIL PROTECTED] <[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. > > D > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
