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)

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.

Steve Jones - Editor (8/23/2010)

We need to get Paul out here in the US for some...

chinn (8/23/2010)

SELECT name from master..sysdatabases where name not in('Tempdb')

order by name

Open complex_cursor;

FETCH next from complex_cursor into @dbname

WHILE @@fetch_status = 0

BEGIN

set @dbname = upper(@dbname)

set @backupname =...