the last three jobs have been a combination of time back or overtime. time back is good as you can stack up large amounts of time which give you...

open up the jobs, look where the packages are stored (msdb or filesystem) then use SSMS connected to the SSIS server where they are stored to download the packages

Ah thanks for that, makes me feel better knowning its just a localised issue.

its going to have to be a manual process of altering the trigger or try and write some dynamic SQL which loads the trigger deffinition from the system tables and...

Is it me or is Google not working again today?

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