job history is set to clear out when the history table becomes larger than 1000 rows by default, or if a job exceeds 100 rows.

this can be changed by setting...

compass

the problem with the int is that it expects whole numbers so you get rounding.

one way would be to do this but every value will then get .00 if its...

i would look at something like robocopy or xcopy running as batch file as a second step in the backup job which copies the files from server1 to server2

for the colouring you will want to put an expression on the fill property which uses with SWITCH of IIF passing in the field value and then saying if Delay...

also take a look at this link, just ensure you enable the alter tokens check box on the sql server agent alert system properties page

Plenty of good links on msdn from the following Google search

http://www.google.co.uk/search?q=ssrs+sub+repors&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a#hl=en&client=firefox-a&hs=X9c&rls=org.mozilla:en-GB:official&sa=X&ei=G3mFT7nhJIHA0QW_q8CrBw&ved=0CBwQvwUoAQ&q=ssrs+subreports&spell=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=277d1bcc24ee76c4&biw=1440&bih=809

yeah especially with the row version store, had issues with that in the past on a dynamics AX implimentation which as per best practise says to set the DB into...

Quest had a tool called change manager at one point, unsure if its still around or been replaced with something else.

other than that, you could create a custom bat file,...

Thanks Perry, I was thinking of isolation levels at the connection level not at the database level. Read committed snapshot seems like the one to go down, just the...

Hi Perry

The second script will fail as its referencing other tables which are not in the deadlock graph so I didnt include them, thanks for pointing that out, I will...

could you please follow the second link in my signature block on how to post code so that we can help you out.

if you can provide create table statements, refactor...

could always set the source DB to read_only instead of single_user then set it back to read_write once done

take it you mean this statement

the query is evalutated at run time...

BeautyOfFinishingAt16:00