try this

declare

@account varchar(50)

exec xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\Services\SQLServerAgent', 'Objectname', @account output

print @account

I am remote from the servers so I am never physically logged onto the server, its always RDP. So I have always got other ways to access BOL or...

I don't install BOL on production servers. People should not be using production server resources to lookup help.

not much you can do post the event. set up some monitoring for the next run. Any new batch jobs been introduced that run at the same time?

thanks for posting resolution. I forgot the helpdesk fix of 'turn it off and on again' 🙂

see if you can start sql in minimal configuration mode, fix the setting . then stop sql and restart normally

http://msdn.microsoft.com/en-us/library/ms186400(SQL.90).aspx

If all your tables had a date column for when they were updated you could compare that date to max(backup_finish_date) in msdb..backupset

online or offline rebuild.? A sudden long run time is often due to the process being blocked out by another process.

this is in the 2005 forum so presuming you are on 2005.

the quick way to do it is via SSMS, that drops the login and associated users for you. However...

Steve Jones - Editor (9/3/2009)

---

Unix has viruses, you don't hear about them as often. The problem is viruses is not a Microsoft issue, it's an OS issue.

R2 keeps things moving...

Interesting, going back a few years but if I remember rightly the :! (or something similar) allowed you to break out of isql in sybase and run Unix commands.

plus ca...

Awe come on!

In the last couple of months I have come to the decision to move our SQL 2000 instances direct to SQL 2008 SP1 missing out 2005, and leave...

please expand on what you mean by an LTO backup. I have not heard the term before. Is it 3rd party software?

this talk of upgrading eval. edition to other editions seems to tie in to a recent editorial and the ensuing discussion:

http://www.sqlservercentral.com/Forums/Topic780419-263-3.aspx#bm780884

so people seem to have varying experiences and luck with...

xnleiden (9/2/2009)

---

I just had a look at...