Add a step into the job which uses WAITFOR TIME command to delay the sending of the mail. Then execute a msdb.dbo.sp_send_dbmail command with the mail you want to...

There are CU's and hotfixes available after SP4 for 2005, its up to you if you want to install them or not

http://sqlserverbuilds.blogspot.co.uk/

MSDN Page on CDC

Also remember that sp_change_users_login is a depreciated command, it has been replaced by ALTER LOGIN and will be removed from a future release on SQL.

-m = single user mode

-f = single user mode with minimal configuration

You cant add a bit to a varchar or a varchar to a bit.

What are you trying to do, string concatenation?

Please provide details of your task at hand.

Jason-299789 (1/2/2013)

---

anthony.green (1/2/2013)

---

Jason-299789 (1/2/2013)

---

so is @p_error an integer?

In which case you will need to change the

IF @p_Error IS NOT NULL

SET @sql = @sql + 'AND RS.ERROR_CODE...

Dave Ballantyne (1/2/2013)

---

Hi ,

To my mind these are two fundementally different queries.

Just because you have a sequential transactionID which means you happen to get the same result, this is...

If no indexes with a - then do you have a database or a schema or an object which has - in its name?

Use the import export data wizard

On the server or on your local machine?

Does the file exist in that location on the server?

Check sys.indexes in every database where the name has -

IF @frag < 30.0

SET @command = N''ALTER INDEX ['' + @indexname + N''] ON ['' +@DBname+ N''].[''+ @schemaname + N''].[''...

Sounds all to familar, especially with people not locking their workstations. At a previous employer we had a security audit for anyone working on sensitive high level information and...

You have index(s) with a - in their name. If the script does not put the index name in [] brackets when rebuilding/reorganising, then the script will fail.

Either change...