Thanks Anthony,

I will check out at Measure Up

Hi

Thanks for the reply

I managed to get into the Log file and found the following information

SQLAGENT 11c0-11e4ENTER SQLAllocHandle

SQLSMALLINT ...

Hi

I finally got there at the end, it was something in the WMI connection manager

thanks again 🙂

Hi

Thanks for the quick response.

The source table [server_query_list] has the server name without a forward slash e.g. [Servertest]. The ServerConnString is set to 0.

thanks

Hi

I have followed this article step by step and get the following error.

Error at DiskUsage: The connection "ServerName=\\;Namespace=\root\cimv2;UseNtAuth=True;UserName=;" is not found. This error is thrown by Connections collection...

Hi Guys

So Far,

- I have given devtest permissions to INSERT into the dba_ddl_events table

- For the DDLTrigger, I have added Execute AS to 'devtest'

- Added View Server...

I will give it a try thankyou both for your help

🙂

Can i just clarify, the trigger was only created to track when ever a database was created or dropped. See below

CREATE TRIGGER [Audit_Server]

ON ALL SERVER

FOR CREATE_DATABASE , DROP_DATABASE

AS...

Hi

Yes i did, I have disabled it and it works now. I cannot believe it was a simple thing as that.

Yes I have got a DDL trigger, I have disabled it and it works now. Thankyou for your help 🙂

The reason i put the triggers was to monitor when a...

Yes I did, not sure what to do

Hi

Thanks for the reply

Normal user 'dev' has got dbcreator rights to perform the appropriate actions. See below;

CREATE LOGIN [dev] WITH PASSWORD=N'1', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

EXEC sys.sp_addsrvrolemember @loginame = N'dev',...

Hi

Thanks for the quick reply. As a test i executed the whole script on my local instance. But got a the following message "Msg 297, Level 16, State 1,...

Hello again

When I try to enable the New Trigger policy I get the following error

'Evaluation Mode 'On demand' deos not support Enabled = 'True'

The setup is as follows they...

Thanks for that, it worked perfectly

🙂