Register   |   Login   |   February 07, 2012    |   Knowledge Base  >  Knowledge Base Systems  >  Servers  >  why does my sql query fail (in a cluster, sql2005, etc...)
search:     

Phone: 480-722-1227
Toll Free: 888-722-1227

why does my sql query fail (in a cluster, sql2005, etc...)
Last Post 31 Jan 2007 11:53 PM by Vigilant CIO. 0 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Vigilant CIOUser is Offline
Basic Member
Basic Member
Posts:360

--
31 Jan 2007 11:53 PM  

user gets this error;

Error from AD001\SQL001

Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.schJOB_RUN_LOG'.

No, the cluster environment does not require the database name in a query, it is more a function of what database is selected as the default database in the application you use to make the query, or what database is set as default for the user.

 

If the default database is set to master for the user, then the query will fail unless you include the  database name in the query

 

 

See screenshot;

 

sql_db_studio_login_mgmt.GIF

You are not authorized to post a reply.

Active Forums 4.2
Copyright 2006 - 2011 Vigilant Support   |  Privacy Statement  |  Terms Of Use