I stand corrected.  Sysname is Nvarchar(128)... Just in case anyone reads this later on.

That will not work.  This returns only the first row of text in syscomments (2000).  No idea about 2005.

I'm sur eyou can find someone who can do that part for you .

It would really help if we saw the execution plan of th query.

You can add a calculated field in the view such as ExpireTime which would contain the number of minutes / seconds or whatever that the event will become invald.  Then...

Thanx for the good work.

IIRC, you were supposed to write an article about this.  How is that comming along?

Just teasing man .

Or without the loop at all :

--create a tally table... make it as big as you need

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType =...

Looks to me like he was the man for the job .

It doesn't seem to be a new feature of sql server 2000.  I'd assume it was available back in 7.0.  Most likely in 6.5 too but I'm just guessing here.

I never had to test that but I would assume it would work.  can you test and let us know how it goes?

In 2000 it was db_ddladmin.  I don't know if it has changed in 2005.

I'm sure we can figure something out.  What is it you need to do exactly?

Make a primary key with an autonumber column.

Then add a calculated field to show the formated invoice number :

Formula = RIGHT("000000" + CSTR(PK), 7)

This allows for 9 999 999...

Doesn't matter at all... even if he had 10 duplicates per key the update should still work :

DECLARE @A Table (PK INT NOT NULL, Col INT NOT NULL)

INSERT INTO...