A snapshot is a fairly low weight operation. It creates what is called a sparse file, which stores any original data which has been updated from the source DB.

These...

Create a snapshot of the database in question at 00:00

CREATE DATABASE dbnamesnapshot ON (......) AS SNAPSHOT OF dbname

http://msdn.microsoft.com/en-us/library/ms175876.aspx

That way the data is static and you can then query the tables...

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''].[''...