You might try the '-q' parameter so that quoted identifiers are used.

Data Volume can be different or indexes/statistics might be out of dated. can you...

What else you have in CATCH box ? means any error message or error code syntax?

Bcoz that will help you/us to get the...

EXEC sp_cpu_proc

IF (DATEPART(mi, GETDATE()) = '00')

EXEC sp_memory_proc

Add above code in job and schedule it for every 1 min.For CPU,it will work for every new hour( ex: 1 AM, 2 AM,...

You can refer this link

Sys.dm_exec_requests DMVs to find the currently active requests, their...

Thanks to all for your replies, i got the point.

Additionally Are you taking backup of MSDB ?

Did you have SP1 patch recently?

Whats values you are getting with it?

select value, value_in_use from sys.configurations where name = 'Agent XPs'

Why it is treating 0 and '' (Blank) same ? in select nullif( 0, '')

Hi Vyas, can you please explain it with my sql code.?

Uncle Moki (3/26/2010)

---

Thanks Bhuvnesh. But that's soft of like answering, "Yes" to a three part question. 😉 I'm trying to figure out HOW to control the security...

first of all this query never go for index seek as it doesnt contain any where clause

and second, if this table has only one...

I think you should have separate account to run jobs.

Your query is not showing any result as "TEST" login is not db_owner (as your query will only work for db_owner)

and you can use use youydb

go

SELECT P.name

FROM sys.database_principals AS...