BTW - why are you even using telnet? I would not even enable telnet on any of my SQL Servers in the first place.

If your cluster is setup correctly, you should be able to RDP or Telnet to the VirtualIP address which will direct you to the node that is currently hosting that...

Nope - the linked server will only use the x64 ODBC drivers. What system are you trying to connect to?

You are welcome - and thanks for the feedback.

You are welcome - and thanks for the feedback. It is appreciated.

These types of issues are not for client systems accessing SQL Server. Your clients will use whichever ODBC client software they need to on their systems, either 32bit or...

Be aware that UNION also has to remove duplicates, which is going to take longer to process. If you can guarantee that each query is unique - you can...

Maxer (3/30/2009)

---

That is EXACTLY what I tried, but it failed.

HOWEVER, I was running it against an SQL Server 2000 data source.

That is VERY interesting to know, thank you for that!

I...

Thanks Flo - that's what I get for typing this...

Not quite true - you can connect to SQL...

There is no way to upgrade an existing instance to a clustered instance. You have to build the cluster and then install a new instance into the cluster.

The only...

BTW - when they say SQL Server can only use 4 CPU's - they are talking about slots. A single quad core processor is one CPU's as far as...

What you can do in SSRS is:

1) Create a parameter for your report - let's call it TopNum

2) In your Dataset, do the following:

DECLARE @Num int;

SET @Num = @TopNum;

SELECT TOP...

Grant Fritchey (3/30/2009)

---

Actually I would have expected that to be a problem in 2000 as well. All 2000 is doing is an implicit convert, that you should get in 2005...

MERGE was introduced in SQL Server 2008 - are you on that version?