Even I have to work sometimes. Apparently more than Remi at the moment.

Btw, regarding the samples out there. SQL Server 2005 will ship...

No, it is NOT true!

The article I've mentioned and the link to Tara Duggan's blog mention NONUNIQUE CLUSTERED INDEXES. This is different from a UNIQUE CLUSTERED INDEX. Internally EVERY clustered...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Make sure you read closely through the http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx#EEAA chapter

Found it somewhere on the MS TechNet site

If you should experience any issues (which is very unlikely), you can always recreate PUBS from your ...MSSQL\INSTALL\instpubs.sql file.

Just out of curiosity: Are you going to dig out all the old threads where this what the topic?

Have you already looked at the script section?

Ed already mentioned some aspects to consider. other aspects might be the separate backup process and the separate security that needs to be maintained.

Are those BLOBs "only" stored and viewd sometimes....

See if this helps: http://www.aspfaq.com/show.asp?id=2120

CREATE TABLE Foobar

(position INTEGER NOT NULL PRIMARY KEY

   CHECK (position > 0),

 foo_value CHAR(10) NOT NULL);

GO

INSERT INTO Foobar VALUES (1, 'abc')

INSERT INTO Foobar VALUES (2, 'def')

INSERT INTO Foobar VALUES (4,...

Thnks, I'm gng to do tht. I had it in my mind but I didn't have proper privillages to change it

If you don't have this privileges, but there is...

Have a look at NOT EXISTS in BOL.

Search the site and/or google on Celko and hierachies

LIke Ian said, SQL Server only "stores" such data, but doesn't provide build-in functions to interpret them. That's the job of your client app. You might find some useful additional...

Yes, you're missing the fact that the original example will always fail. No matter if in a batch or a stored procedure. That's what I meant.

...Steve Jones in fine clothes...

Hm, will ping Steve for a prove here.