No worries, glad it sorted the issue for you.

Unsure why your having trouble with the command text

CREATE TRIGGER ddl_trig_CreateLogin

ON ALL SERVER

FOR CREATE_LOGIN

AS

-- Declare variables

DECLARE @mailSubject Nvarchar(100);

DECLARE @mailBody Nvarchar(MAX);

DECLARE @data XML;

DECLARE @text Nvarchar(max);

DECLARE @user Nvarchar(max);

DECLARE @newuser NVARCHAR(MAX);

SET @data =...

Yep sorry, you need to do all your xml shredding outside of your email block

-- Script to add trigger to alert (via email) when a new login is created on...

can you copy out all of the output window and paste it in a txt file and attach it, the screen shot strips out the important bits at the end...

What is your full SQLCMD call?

If your using windows authentication then you replace the -U and -P switches for the -E switch, also remember that the switches are case sensitive.

You should be able to knock one up quick using msdb.dbo.syspolicy_################ tables

It looks like your not setting @data = EVENTDATA() unless I am being blind and cant see it in the code.

Also if your shredding the TSQLCommand node you need to...

What is the total amount of RAM in the server?

As Gail has already said a number of times, high memory usage on a SQL server is a VERY GOOD THING[/u].

Go and get a copy of the Accidental DBA guide...

Look at creating a DDL trigger for the CREATE LOGIN facet which sends an email via sp_send_dbmail.

Something like the following

CREATE TRIGGER LoginCreateTrigger ON ALL SERVER

FOR CREATE_LOGIN

AS

BEGIN

DECLARE @data XML;

SET @data =...

It specifies who you want the owner of the schema to be.

So it says that the schema is owned by the dbo login.

You can grant authoirzation to any valid login...

Yes that is the way that subscriptions work but as your using Enterprise edition you only need to have 1 subscription as you can use Data Driven subscriptions to do...

Doh, yeah I was getting confused with the hidden properties as I knew it had one but forgot it doesnt have a true properties section, I tried to hack the...

whats the output of RESTORE HEADERONLY 'backup path.bak'?