Mike, I appreciate your response. I had already experimented with table ownership, with no luck.
The error seems to be pretty clear - one would think it is surely related to table name or access permissions - but I can run the query successfully from a separate CF page and not from within the CFC. In that regard it seems like the problem may be the data involved, not permissions, since permissions/table name would be globally rejected... Anyway I'm chasing my tail. I think I may have to deconstruct my CFC and find a new way to accomplish the same end. Maybe in the process I'll find the bullet I'm overlooking... Thanks again for your input, Mike & Isaac. -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 12:30 PM To: CF-Talk Subject: Re: Invalid object name What if the problem isnt the table name but the owner name? I've had similar issues, and replaced SELECT * from dbo.tecSOLine with SELECT * from tecSOLine IF that works where the other doesnt, then you probably need to either change your query code, or change the object owner. Look in Books Online for how to do it for your database, but in SQLServer2000 there's a SP you use as follows: exec sp_changeobjectowner 'dbo.secSQLine', 'otherlogin' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
