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'?

How are you wanting to test failover? Is it just point your client applications at the server and see if it can connect and read data or will you...

You can restore the logs in a standby/readonly method when creating the logshipping plan, just ensure you enable the disconnect users option to kick anyone out when it tries to...

After you assign the mail profile to the alert system in the agent properties you need to restart the SQL Agent so that it picks up the updated config.