Here's the DDL for the Linked Server:

USE master

go

EXEC sp_addlinkedserver @server='c12-esa-app01', @srvproduct='SQL Server'

go

EXEC sp_serveroption @server='c12-esa-app01', @optname='rpc', @optvalue='false'

go

EXEC sp_serveroption @server='c12-esa-app01', @optname='collation compatible', @optvalue='true'

go

EXEC sp_serveroption

Thanks for the reply. It looks like that the db is/was on FULL recovery mode. I do see that the 60 gig LDF was restored. The restore/recover...

Thanks for everyone's input. I believe utilizing NT Groups will address our needs including SOX related issues.

SteveV

From EM. We are trying to avoid from logging out of the domain to use another account. Thanks for the reply. I'll look into the Group suggestion....

Thanks guys for the reply.

Looking into Adam's suggestion.

Steve

Thanks Phil you saved me a lot of work =)

Thanks so much guys!

The restart definitely resolved the problem. A restart is usually not an option in my shop unless to resolve a problem even with...

Hi Curtis,

Thanks for the reply. I can't seem to find it in Microsoft's site. I'll keep searching. Would it be possible to point me to the right...

Hi Paul .. can you send me a sample of your written script to run as a SQL Job when the alert fires? THanks.

Hello everyone ... has anyone found a resolution to this problem?

I get notified with other alerts i setup but not the Deadlock 1205 alert. Please advise.