See, if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Steve,

I will bloody it.

That's a good attitude, I think. I'm very combative myself when I know I'm right and when I think it yields some good results. However, if...

A little bit vague this question, methinks.

You might want to read to read both topics in BOL and come back more concrete questions.

Aargh, I should get used to scan my own link library more often. Here are some other.

http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/

http://www.databaseanswers.org/data_models/index.htm

FWIW

USE Pubs

GO

DECLARE @stmt nvarchar(4000)

DECLARE @rowcount int

DECLARE @table nvarchar(255)

SET @table = 'authors'

SELECT @stmt = 'SELECT @count = COUNT(*) FROM ' + @table

EXEC sp_executesql @stmt, N' @count bigint output', @rowcount OUTPUT

IF @rowcount...

While the EXEC statement can't return a value, sp_ExecuteSQL surely can.

Well, let's say EM handles several things different than common sense would think. That's the way it is and it's by design 

See, if this helps:

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

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

Hey, my post doesn't even come close in length to the ones from you I remember.

Apart from this, couldn't have said it better 

To add to Antares, here's an example what can happen, when you choose to workaround this GETDATE() - UDF issue with a view, which is sometimes suggested.

http://www.insidesql.de/content/view/100/

It's in...

Steve,

if you ask a question here in the fora, you mostly likely receive quick and probably good advise from people who already have been there where you want to go....

If you are subscribed to SQL Server Mag you should have access to this interesting article by Itzik Ben-Gan:

http://www.winnetmag.com/Article/ArticleID/40621/40621.html

See if this Topic in BOL helps: "Transact-SQL Debugger window"

To answer your first question (This is taken from the only book worth reading by MS Press "Inside SQL Server 2000"):

If your clustered index was not created with the UNIQUE...