Which session is chosen as the deadlock victim depends on each session's deadlock priority:

If both sessions have the same deadlock priority, the instance of SQL Server...

it is possible, but would involve a lot of reconfiguring I would think unless you design your template to have multiple vmdk's as standard and when its deployed all the...

only way would be to restore the databases from 3 days ago unless you have some custom monitoring solution or script the database schema every day

CMDExec step NET USE Z: \\UNCPath\d$ /user:domain\user password

T-SQL step BACKUP DATABASE TO DISK = 'Z:\database.bak'

CMDExec step NET USE Z: /DELETE

it is,

you will have to map the network share as a local drive using command prompt and net use with a user and password which has access then you can...

can you post the definition of the stored proc, the definitions of the tables and indexes used by the proc so that people can take a look at it and...

the variable lasts for the scope of the batch, so as this is one batch the variable is never reset, you would have to drop out of the loop and...

i've moved into a new role around 6 weeks ago now which is in the education sector too providing educational resources to schools for use on our companies whiteboards, as...

if you provide what you have so far then we will tell you where you are going wrong

hackneyed

someone must have SA rights to the server who can see the error logs?

why not use SSIS which is a part of SQL for your ETL

you will want to take a look at the keywords, try, catch, xact_state, error_number, error_message and transaction which can be found in BOL and Google.

do the insert inside the try...

can you view the sql error log as error 18456 has a number of states which determine that the actual cause is. SSMS will only usually show state 1...

stop what job? we haven't created any jobs?

if you follow the steps

create the tables in connection 1

begin tran in connection 1

update table1 in connection 1 --this one will complete

begin...