You can post your response here but feel free to drop me a direct reply at my website (which should hopefully be included in this message).For anyone that's interested, it appears that DBO may actually stand for Database Owner, not Database Object as I had previously speculated. Not sure how that helps resolve my issue per se, but there you have it. If anyone can offer a pointer on the original post it would be great, thanks!
Dave|||Hi,
dbo does stand for database owner. To help you determine what is going on with your application use SQL Server Profiler to trace the the queries that your application is issuing against the server. You can then copy the queries from Profiler to Management Studio and then run them manual to determine exactly why the query is failing.
Keep in mind for the owner of the object, if the owner of the object is not specified in the query, SQL server will search for dbo first.
If you have specific questions, please let us know.
Peter
No comments:
Post a Comment