Have not attempted to change the server name.

2nd link: does not appear to apply (can't even...

Here's my two cents ... Until you...

Grant, I'd really like to see what you end up with on this. For one, I don't understand how you're running this query in RS.

Well, I've got a little bit of followup on this. The instance still won't start.

In looking through the application Event Log, and in cluster.log, I see these messages:

Recovery is complete....

How about:

select * from sys.database_files

(Size = # of 8k pages, so multiply size*8*1024 to get # bytes of the file. Or (size*8)/1024 to get # MB)

YSLGuru (8/24/2010)

---

CirquedeSQLeil (8/24/2010)

---

You could look into Central Management Server. That is an option that is available with SQL 2008. You can execute a query against multiple servers at...

Sounds like a good use of the "For-Each container". This can be set for files in a folder (even with a mask), and sets a variable to the file name....

And to insert the existing values into the identity column, you will need to use SET IDENTITY_INSERT ON/OFF.

i.e. (using your test data):

if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test

CREATE TABLE...

If you can get your developer to put each summary_level as a child of the root, you can utilize this (ideally, the different summary levels would be just "SUMMARY_LEVEL", and...

Grant,

How does this do?

declare @test-2 xml = '

<ROOT>

<SUMMARY_LEVEL_1>

<DEPTID>42</DEPTID>

<LEVEL>1</LEVEL>

<DETAIL_LEVEL_1>

<EMPID>1</EMPID>

<NAME>Dude</NAME>

</DETAIL_LEVEL_1>

<DETAIL_LEVEL_1>

<EMPID>2</EMPID>

...

How about:

CREATE TABLE dbo.Book (

Book_ID int PRIMARY KEY CLUSTERED,

ISDN varchar(20?),

Title varchar(100),

etc.)

CREATE TABLE dbo.Author(

Author_ID int PRIMARY KEY CLUSTERED,

First_Name...

I would have to agree on both counts.

I think this book will be one to buy - we just don't have a lot of information on using the DMVs, and...

Well, I suggest that we take a step back, and start over.

You've already provided the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to...

Just run your SQL install program again. Note that you will need:

1. Separate disk drives from the first install for the shared disks between the nodes.

2. A separate virtual sql...

You might want to check out this excellent article[/url] for how to handle your running totals.