Anyone else noticed this? The top ten posters account for a whopping 11.8 % of the 337 000 lifetime posts.  Their combined posts count is close to 40 000, consider...

Congrats guy.  I wish you the half million before Decembre 2007...

And thanx again for the great prizes .

Totally agree.  That section is for users who need help.  The same users who build this site, and for whom this site was built for.  I don't see why some...

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.