Which item did you try? Note that the procedure give is for SQL 2000, but there are...

Dimbulbz (8/2/2010)

---

... I don't know where you have taken your sample from, but that is scary and perhaps I need to do my own polling where I'm working now....

Depending on what you do, OPENQUERY can be easier to write. If you do a straight join, I believe that the entire table from a linked server comes across and...

Thanks for the update. If you get the DNS specifics, I'm sure this would be a good thread to update for others.

I thought this was interesting, and I've dealt with this in a few places. If you don't have to work with the financial system, you might not encounter this. It...

BTW, I bought a 2500sq ft house in Va (SE) for $140k in late 1997, sold for $150k in 1999. A little over a year later, bought essentially the same...

Spending $160k a year.

Make sure you have indexed the columns.

Is there a reason that you cannot check for an AND with both columns? As in Jeffrey's first example.

First google result for me: http://www.mssqltips.com/tip.asp?tip=1046

You enter the mirror server in the connection string.

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

Depending on how the CAST works on the data, you could end up with different values. What you need to do is cast specifically to a size and ensure that...

You can setup a linked server between them, or you can use the OPENQUERY command from one server to get data from the other.

Without more details it's hard to know, but typically a report that presents row data as a column is a crosstab report. You can search on that, or look up...

Are those flat files there for DR? Or were they loads of some sort?

You can't make them pay. Businesses don't do what's right, or what's most efficient. Often it's the most cost effective, and if that means less service or some loss of...