Just of of curiosity, can you give me some links?

Any idea on average passing rate?

Do I really write this ?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Btw, these M$ certification are they an all or nothing approach?

I mean, when you fail, are you allowed to take it again or is that case closed?

And what do they...

DBCC CHECKIDENT (RobTable) gives you the expected results.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Curious what will happen, when the long time promised further standings are released

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, without sample data it's difficult.

I have done something similar in a small app outside SQL Server

Basically you need to search for the @ sign, then take all characters to...

*grin*

If I were you, I wouldn't bet on myself.

Hope you won't get frustrated and stop posting.

I really learn a lot from...

This 'professional atmosphere' is something I consider a MUST. I don't see any reason why it should be different.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

This might be interesting

http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Well, I guess you know what Microsoft says about direct statements against system tables.

To make really sure you can also use

INDEXPROPERTY (...,'IsStatistics')

INDEXPROPERTY (...,'IsAutoStatistics')

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Just wanted to add that there is an OBJECTPROPERTY 'TableHasClustIndex'.

Might be worth a try.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Run cliconfg.exe from Start | Run. Create an alias to the server. Register the Alias in EM with the second set of...

The book also contains a CD with the content in HTML Help format.

I guess most information you won't find somewhere else on the net. And if you ask you will...

would an

ORDER BY RecNum

help?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Actually mistyped it

This is from Inside SQL Server

USE PUBS

GO

DBCC TRACEON(3604)

GO

DBCC PAGE(5,1,88,1)

GO



PAGE: (1:88)

------------



BUFFER:

-------



BUF @0x00E15F00

---------------

bpage = 0x19DB8000        bhash = 0x00000000 ...

That's right, when there is a clustered index on that table.

You can examine each data page by running something like

USE PUBS

GO

DBCC TRACEON(3604)

GO

DBCC PAGE(5,1,1,1)

GO

your results shoudl look...