i was thinking more along the lines of timed denial in an ACL.

for example, we have 24 x 7 access to server X, but a vendor only has access from...

is the linked Oracle server local or remote?

maybe some network rules are getting in the way.

does the job owner have the correct perms to run?

I am refering to the Owner: of the actual SQL Server Agent Job. Under general settings.

DBA_Oshvegas (1/26/2011)

---

I am confused about the part "SQLCMD that uses the raiserror command to send messages to the Windows Event Application Log". Is this a job step executed as...

is there a work around in SQL 2005, 2008, 2008 R2 that allows for ;

alter login [DomainGroupName] DISABLE;

thanks

if by reg you mean Registery

Exec xp_regenumvalues N'HKEY_LOCAL_MACHINE',

...

i would recommend that you use a 2 part maintenance plan.

step 1 takes your full backups to a designated place. (Back Up Database Task)

step 2 looks at that same location...

was a restart or did you just place the database in single user mode.

just placing the databse in single user mode does not restart the service thus restarting tempdb....

you would...

if you have the budget for the Quest tool, you should be shopping for either Ideras Diagnostic Manager or Ignite for SQL Server by Confio.....

The red gate tool is great...

im curious how its logging those login attempts if the engine is not running?

if it is running when you get those logins, open a profile trace, and capture "Failed Login...

this will work for you;

CREATE TRIGGER newDatabaseTrig

ON ALL SERVER

FOR CREATE_DATABASE

AS

DECLARE @database sysname

SET @database = (SELECT TOP 1 name FROM sys.databases where name != 'tempdb' ORDER BY create_date...

Great.

Now let's hope you never actually get the email. 🙂

Maybe you can try to;

Grant execute on sp_send_dbmail to <user>

based on that other thread, and all the info that is there, can you try this;

DECLARE @sqlquery nvarchar(250)

SET @sqlquery = 'select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog...

sure, but blocking will need to be a timed query Ie, via SQl Server Agent....

but you could run a script like in the attachment every so often and send the...