On 2/19/06, Paul Hastings <[EMAIL PROTECTED]> wrote: > if you can only access that table using a user name as a qualifier then > that user's not the DBO. can you query the unqualified table using query > analyzer using that user/password?
Through Query Analyzer using that user/pass, I cannot query the table unqualified. Yet Enterprise Manager->roles->dbo->properties tells me that user is in the dbo role. It makes no sense. > if you add the user/password to cfquery does it work? No. > dumb questions: any chance you're not looking at same db/server? what > driver? JDBC? Each server is only running the FarCry site, basically. There's only one database on each, essentially, so no chance at all (I wish that's what it was). It's JDBC... both SQL Servers are running the same MDAC, if that means anything. Is there a chance that something like this could happen if the database was had to be restored from a backup? The client didn't reply when I asked if anything had happened to the box. -- Kay Smoljak http://kay.zombiecoder.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232848 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
