put sp_addmessage into BOL, google etc which will give you the syntax

then create a message which has meaning to you

You can create a job via the central management server across all servers which are members of the CMS, but you need to do it in T-SQL, you cant use...

CREATE TRIGGER [DatabaseChangeTrigger] ON ALL SERVER

FOR DDL_EVENTS

AS

BEGIN

DECLARE @data XML;

DECLARE @schema SYSNAME;

DECLARE @object SYSNAME;

DECLARE @eventType SYSNAME;

DECLARE @user SYSNAME;

DECLARE @mess NVARCHAR(MAX);

DECLARE @dbname SYSNAME;

SET @user = SUSER_NAME()

SET @data = EVENTDATA();

SET @eventType =...

are all the health checks different for each server?

if they are then it would be a case of creating the individual jobs on each server

if not you could look at...

please post the DDL and sample data of the objects in the problem

have you prefixed the new db on to the query

oldmasterdb.sys.sql_logins

Dev (11/17/2011)

---

Agree for SQL Server Service Accounts. ...

Dev (11/17/2011)

---

bpportman 52825 (11/16/2011)

---

Thanks for you help all - the problem has been solved. This is the message I got from our network admin.

I was able to...

this is a good reason why service accounts should be used with none expiring passwords to run SQL server services

alternative

DECLARE @NUMBER INT

SELECT @NUMBER = COUNT(*) FROM ATable

SET @NUMBER = @NUMBER -5

SELECT * FROM ATable WHERE ID NOT IN (SELECT TOP (@NUMBER) ID FROM ATable)

The reason its a random order...

They can still create under DBO as you cannot specify a default schema for an AD group, so it will always default to DBO

One way to get around this is...

What happens should a user be part of the AD group and also part of...

this really isn't the site to be asking this as PCI DSS is very broad and not specific to SQL.

what tier and level are you aiming at as that depends...

you could also build an expression to dynamically generate the dates if you are clued up on the expression builders in SSRS

other wise like Ole says, build in a new...

Are you under any space constraints on the hard drive? If not then I wouldnt shrink the database.

Shrinking will cause fragmentation in the database, so you will have to...