Actually, I have a Windows 7 laptop running Excel 2003 as well. I'd really prefer to get that running, but I need to make either of these work.

In the...

Hmm even throwing a try/catch around the INSERT (in place of the IF) has the same issue. The query falls over when it can't find the Excel sheet.

Any more...

Brilliant, thanks Gints! That's exactly what I'm after!

Sam

Hi Steve,

Had a chat with the BA and turns out we don't need this info anymore anyway! W00t!

Would still be interested to see how it's done if you're interested...

Thanks for all the help people, keep it coming!

🙂

OK, I'll try and boil the question down...

"How can I restore a database to a different server using a login which doesn't exist in the original database; AND add the...

All,

Given the problem is a bit sporadic, and I don't have easy access to testing the problem, I'm going to go with the "(NOLOCK)" solution for now. Thanks for...

Hi All,

Daryl: I've tried removing the WHERE clause information and realised that it now seems to miss the point of the WHERE clause - that is; I'm not getting a...

Hi Mike,

I haven't used EXCEPT before but after looking it up it seems to do what you want by showing those rows from server A which are different to those...

Hi Mike,

Basically the comparison you've suggested is saying "if any of the fields in Server A are different from any of the fields on Server B, then update the whole...

Thanks Gail. Not sure exactly which resources it's deadlocking on but have a hunch it's something to do with the subselect. Will try refining the query and try...

Thanks very much Daryl 🙂

You can also use the CHECKSUM function to determine if fields have changed. That is, you can compare CHECKSUM(serverA.col1, serverA.col2, serverA.col3) to CHECKSUM(serverB.col1, serverB.col2, serverB.col3) to determine if a...

Hi Mike,

You could use a linked server to connect server B and server A. You can then query a table on server B using the following notation: serverB.databaseName.dbSchema.tableName (provided...

Hi all,

I seem to have been able to overcome this using SQL Server aliases (see here: http://msdn.microsoft.com/en-us/library/ms190445.aspx). Will reply here if I get stuck again.