Steve, I think there should be 10.  There is the Cluster resource group that needs an IP address.  I'm not sure it there is a way to configure the cluster...

Never ask the networking group for help.  They are too busy playing Half Life.

(heh)

You could set up the first virtual server, then move all of its resources into the same...

None of this would have happened if everyone used case sensitive databases, because the damn thing would have returned an error in the first place.

Another case for case sensitivity.

Now you're trying to do my job....

JG

It returns an error.  My databases are all case sensitive.

Should be select * from INFORMATION_SCHEMA.ROUTINES

JG

OP wanted what the host name WAS before a problem happened.

If you want the hostname NOW, from T-SQL:

create table #foo (

id tinyint identity(1,1),

txt varchar(255))

Insert #foo (txt)

exec master.dbo.xp_cmdshell 'ping localhost...

You can also look in the Application Event Log for information about this.  There will at least be startup events for each instance, tagged with the physical server name.

JG

Try this in QA:

select 1 where 1 = 'A'

You get the same error message (minus the Crystal error number and description).  I would suggest that the problem is with the...

I remember something about attaching MSDE databases in SQL 2000.  If I remember correctly, they are set to AUTOCLOSE by default in MSDE.  You might want to check that option...

This is a set-based problem.  There are just a lot of possible sets.  So we have to find all of them and only return the 5 rows from the solution...

Actually, none of the answers are correct.  The correct answer is:

A recordset with a single, unnamed integer column containg a single row with the value 12 in the only column.

But we...

Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;174799  It gives the general procedure for service packs and/or hotfixes in a clustered environment.

JG

This must be the pedantic vent thread of the day, so onward we go....

No, you cannot use a mirror as a reporting server database.  No can do.  As stated earlier,...

Regarding "How to restore a database backup (Transact-SQL)", the BOL gives the example:

USE master

GO

RESTORE DATABASE MyNwind

   FROM TAPE = '\\.\Tape0'

GO

So I can see where, as a matter of habit, the...

Agreed.  I've had no problems with Outlook 2.003K for SQL mail.

JG