Really, just a recompile?? Even after a server reboot?  What service pack level are you running?

Yes that will work, but it will perform like a dog once you get a lot of data as SQL has to do a lot of data conversions just to...

How did you "trace" the transaction?  Using SQL Profiler?  You may well see what looks like the same code executing twice, but the first time is probably a preparation.  You...

and be sure that after your select statement you set rowcount back to 0 - the ROWCOUNT setting affects inserts, updates and deletes, not just select!

So if you did

set ROWCOUNT...

No probs CD

How did the other suggestions impact on your query execution speed?  If they didn't help, I'll see if I can think...

I have had a bit of experience with CC databases in the past (although the company it was with was quite dodgy to its customers - am glad I left...

Can you run Query Analyser on server A to connect to B?  Does it work?

If you can't run QA, try, on server A, using xp_cmdshell to run the OSQL utility...

Put them into a table and then use DTS to export to XLS.  About 3 other questions have been asked tonight in the forums on exporting to XLS or CSV...

Use

SET QUOTED_IDENTIFIER OFF

to allow using double quotes and single quotes for string delineation in SQL Server.  THis can be set at a DB level I think.

As in, create an identity column, or a GUID column, and make it your PK.  Then you can have an encrypted SSN stored in exactly one place.  When you need...

There's nothing really wrong with storing them in SQL Server - sometimes it can make things much easier as all of your data is in one place for backups and...

But as Remi said, you might as well make your 5th cost a computed column.  This saves you from updating it all the time - it will always be up...

Make sure that the login you are using to connect to SQL has appropriate permissions in both databases.  What you are doing should certainly work.  The error message will certainly...

What Yuri said is the best approach.

But, could you please post the query and what you are trying to accomplish - perhaps we can find a better way of you...

Bizarre!  You get warnings when debugging SQL Server running under localSystem account - could this be one of the possible side effects?  Try changing MSSQLSERVER service to run under a...