Thanks Yelena,

Incidentally am I correct in my assumption about the order with which the db's should be restored (going the restore route)

Master,

User Db's

and then Msdb

Or should user db's...

Mmmm, interesting Idea Yelena, I hadn't thought about that

I think that is a very good and underestimated point sara. 

Personally I veer heavily towards the subquery route.  My general rule of thumb, unless encountering severe performance issues is...

Thanks guys,  I actually noticed this article on SSC that is pretty much in line with your suggestions

http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

"Sorry asleep at the wheel this morning change the statement to"

Oh God me too, Sound of hand slapping forehead. 

I was originally using normal tables and then switched to temp tables ...and...

Hi Michael,

I've tried IF Object_Id('#guk_temp_current_appointment_card_roles') >0

unfortunately this also gives the same error

I've even tried hedging my bets with

IF coalesce(Object_Id('#guk_temp_current_appointment_card_roles'),0) >0

I neglected to say that I am running this logged on as sa, and have also tried the code without the go batch seperators to no avail.

Does anybody know what kind of transaction performance overhead there is with indexed views.  I assume that each time changes are made to any base tables in a view then...

Ahh, well done Scott, just what the doctor ordered.  I'd not come across the execute shell task before

You'll wish you hadn't asked 😉

I'm creating a DTS job that will extract some data to a CSV file, Zip the file up to a WinRAR file (or should that...

Thanks Guys, some useful info there

Thanks AJ and Gram,  I was trying to be a bit adventurous achieving it in the one trigger wasn't I .  I think I'll...

Cheers David, in which case I can just join inserted into my update tableb to match it

Hi mmatseke

Is the SQL Server service that you are running your SQL statement from running under a Domain account with rights to the \\Server1\Development\ZA\ directory on server 1 rather than...

You're right Vidas thanks, I found it under the winnt\system32 directory.  The service was previously pointing to an old empty MSSQL\BINN directory for some reason which led me down the path of...