This is not the whole truth though. If the table and procedure have the same owner, then yes everyone can update the table by executing the procedure. This works because...

How about the pretty easy argument that SQL Server does not allow more than 256 filegroups per database? That should tell them.

If you just want to check for a single table then sp_helpindex is best. However, if you want a query to return this information for all tables at once, here...

To view the members of the database role db_backupoperator, which has the rights to do backups:

EXEC sp_helpuser 'db_backupoperator'

To check users who have been giving backup permissions explicitly:

EXEC sp_helprotect 'BACKUP DATABASE'

EXEC...

Like Remi says, you should really be storing the date as well. And both date and time should be stored in a single datetime column! (How are you storing time...

My answer was only meant as a small correction to the previous message. It is not meant as a recommendation as to how many concurrent users you can have in...

I have a checklist published here at SQLServerCentral.com which describes these steps, adapted from the Microsoft article linked above.

The result from the jury is in! In June CTP this works exactly as we would expect, which means the way it works in SQL Server 2000. The two queries...

I had not seen your post when I posted mine, opened the window and then got busy. I have never tried that, so maybe it is actually possible. Or maybe...

I just tried this in April CTP, and interestingly enough I get a third alternative result from what you have gotten above. I do not receive an empty resultset, however...

Hmm, actually I might have jumped the gun there. I could not wait until I got home, so I fired up Virtual PC on my laptop at work, where I...

Yes, it is actually. The catalog view sys.objects now has two columns, create_data and modify_date, which the columns in INFORMATION_SCHEMA.ROUTINES of course are based on.

Depending on what your property Users actually returns, you can do one of two things:

1) If it returns an array, as your code here seems to indicate, it will return...

>As a rule of thumb, each connection to SQL Server takes about 500k of RAM.

That is not quite true actually. Each connection to SQL Server takes 12 KB + (3...

No, unfortunately this is not stored in SQL Server. The LAST_ALTERED and CREATED columns in the view both show the column crdate in sysobjects, so that is why they are...