Disk IO at a guess- when run out of hours it isn't as constrained as when run during working hours and has to compete with other processes for IO and...

Right click on the package and select view code. Look under DTS:ConnectionManagers at the one that works and the one that doesn't and compare the differences.

Check out the link here - https://msdn.microsoft.com/en-ca/library/dd207003(v=sql.105).aspx

You need to run the setup command with an action of REBUILDDATABASE

Once complete I would stop the SQL service and start it in single...

Do you have recent valid backups of these databases?

Also as you are using 2012 you could use concat to generate the string. You wouldn't have to worry about checking for null values then.

DECLARE @FRGClaims TABLE (

...

That is the AD account for the server. I believe any Services running under the Network Service account will use this account.

I honestly have no idea. Where have you seen this term?

Check out the inscope function

Are you using SQL Server Reporting Services? Going by the NVL you are using oracle or informix or similar.

If the version number is 10.5 then it is going to be both less than 11 and greater than 10

Insert a new Row inside the group and move the fields to this row

The account that the sql service runs under needs full control to the location of the mdf / ldf files.

You can attach an MDF file without a log file - Click remove to remove the reference to the log file and SQL will create one for you.

You need to...

Press F4 to ensure the properties window is displayed. Highlight all the fields and then change the borders in the Properties Window - Border Color, Border Style, Border Width.

I believe you need to be a member of the sysadmin role in order to use debugging.