You could just write a script to update the msdb.dbo.sysjobs table (enabled column) and set it for each job you want disabled when this s.n.a.f.u occurs.

I wasn't aware that you were connecting as sysadmin.  sa has permissions already (obviously).  You may want to review the link in the previous post for further suggestions.

In the master db on the server.

Grant permissions to the sp_sdidebug stored procedure.

http://msdn.microsoft.com/library/?url=/library/en-us/trblsql/tr_servtools_5cfm.asp

What's the fragmentation of the indexes on these tables look like?  Run DBCC SHOWCONTIG if the scan density is < 80% I would either run DBCC DBREINDEX or DBCC INDEXDEFRAG...

How many rows does this query return?

Have you tried running a profiler trace to determine the batches / procedures that are utilizing the most CPU time?  This may give you a starting point of troubleshooting to...

Why not just change your statement

 SELECT * FROM [AnyTable] where IDC = 878

to

 SELECT column1, Column2 FROM [AnyTable] where IDC = 878

And, dude - don't used cursors they suck for performance.

That's pretty good.  Then give then eleven questions and tell them to rank themselve 1 - 100   Haha  ...

What a joke.  People who can't handle brutal honest feedback are generally suckers trying to hide their lack of intellgence.  Being (PC) Politically Correct is for the chumps.  I applaud...

A Man without a woman is just not being suckered into paying her bills, listening to her bull shit lies, and that man will be happier without her bitch-ass anyhow.

Don't you guys (and evil women) have jobs? 

SELECT @Output will return a recordset

You want to do everything that Remi said to do but instead:

Print @Output

You can only have a "trusted connection" by not using OPENROWSET - instead you'd have to create a linked server.

To check/edit the service account just go to properties in Enterprise...

You can only have a "trusted connection" by not using OPENROWSET - instead you'd have to create a linked server.

To check/edit the service account just go to properties in Enterprise...