yes, you will need to add in a map report object for it to display the Geo data, unsure if any other report object can display Geo data as its...

try this link,also look at transfer login task in SSIS, manually scripting from the master database wrapped in with the create login commands you need.

unsure if this works on SQLExpress but you could start SQL in single user mode and as long as your an administrator of the actual workstation you will get SA...

not that I can tell as there is a DDL trigger which fires for all ddl events using the root DDL_EVENTS but unsure if restore /attach/detach come under the DDL_SERVER_LEVEL_EVENTS...

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...