The delete must have been waiting for the bulk insert to release a lock on some resource it had held open.

If you have historic reporting, try looking at what locks...

Happy to help

The question and topic title say they are converting...

Convert to VARCHAR then convert to datetime.

CONVERT(DATETIME,CONVERT(VARCHAR,vchValue))

The following link details what can and cannot be converted

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

A key column is the column(s) that the index is created on, the non-key column are included columns

CREATE NONCLUSTERED INDEX idx1 ON Table1 (Col1, Col2) INCLUDE (Col3, Col4)

In the above...

Read chapter 3 of the accidental DBA guide, link in my signature below to the download.

use the Get-Service cmdlet, for the service in question, then google for a smtp powershell function and build it up that way,

if you get stuck come back with your...

Could also write something in powershell as well to check the process state and send an email should it change from started to stopped

Or just query the sys.sql_modules table

select

o.name,

sm.definition

from

sys.objects o

inner join

sys.sql_modules sm

on

o.object_id = sm.object_id

where

o.type = 'p'

Disable mass-mail worms in ePO for your server.

Also ensure that you have the ability to connect to the SMTP server for connecting and relaying is using MS Exchange as the...

Google sp_help_revlogin, it will genereate the create script with the particular SID, then you just need to run it on your secondary server.

A FULL backup will reset the differential base LSN, so any DIFF's which dont follow on from the FULL's LSN will not be able to be applied.

Check msdb.dbo.backupset for the...

The trigger will fire at the transaction scope and the scope of the transaction is to insert two records which will not meet the criteria of the trigger and not...

wrap in a cte then just select the one column

INSERTED / DELETED are persisted tables based on the definition of the table you have defined the trigger on, so it will mimic the recipes table.

Personally I would have put...