Please start any new threads on our new
site at http://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Our new SQL Server Forums are live!
Come on over! We've restricted the ability to create new threads on these forums.
Flowing Fount of Yak Knowledge
quote:Originally posted by sagarthanawalaHello,Iam on MS-Sqlserver 2005 and Iam trying to add a job thru Mgmt studio.The job steps are :-1] Step name :- Query DB Type :- Transact-SQL script (T-SQL) Database :- Master Command :- select count(*) from sys.databases.This job run every 2 mintues and Iam getting the following error whenever this job executes :-Name :- DB Heartbeatowner :- NA\sqlserver-svcCategory :- Database MaintenanceStep ID 1Server SQ05ADB\SQ05ADBJob Name DB HeartbeatStep Name Query DBDuration 00:00:00Sql Severity 16Sql Message ID 208Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: NA\sqlserver-svc. Invalid object name 'sys.databases'. [SQLSTATE 42S02] (Error 208). The step failed.Please let me know.
Very Important crosS Applying yaK Herder
quote:Originally posted by mahalirajeshHi i am try to execute the following query in MSsql2008 Query editorUSE masterGOSELECT name FROM sys.databasesGOselect count(*) from sys.databasesGOi am getting following errorMsg 208, Level 16, State 1, Line 1Invalid object name 'sys.databases'.