run a dbcc opentran() command against your source database - this might point you in the right direction

if you have one uncommitted transaction in that database then anything that uses...

I think you misunderstood me

if you go...

Not on my server

never has on any server i've ever had

not used that one before.. Does it include the instance name?... That's the kicker.

@@servername is normally the way to go, but it depends on how you refresh your environment

I worked with a company who cloned all of their EPOS systems in 400 stores,...

damnit... I use these almost every day and I still got it wrong (I don't cheat and run the code)

we use persisted computed columns in so many areas - one...

It's 4 part naming - i'll give openquery a go - I've been playing with all sorts of techniques, but I've found that even if I Kill the spid half...

in each database you can set the parameterisation options (right click on the database, go to properties and go to options)

obviously stored procs with nice parameters would be the ideal...

have you run a sql profiler trace to see what the  client app is  trying to do - sounds like the UI is doing the rounding for you

The plan splits for each block of code - the bottom 2 sections are function calls within your proc - i'm afraid you can't keep them as 1 plan (that...

checksum has bitten me so many times (it was there when I started), binary checksum is a bit better, hashbytes is even better - but as phil says "hashing algorithms...

a great start - I use rownumber over (partition by order by) a lot

one of the more overlooked windowing fuctions though is NTILE - especially when you are dealing with...

then it's clear that the 2 steps in the job are operating under different security contexts.

try this - is your sql agent service running as a domain account ? (if...

Back in 2005 I started a new job with a large UK based gambling company.

I think it might have been my 2nd week with the company and I got pulled...

Good point, if I: is a mapped drive of a network share, the mapping may not exist for the user the backup job is running as.  UNC path name...