You'll need to use some type of third party tool, a trigger, or a separate insert if you control access to tables with procs.

Those are the three options. I'd like...

Can you explain what you mean by user difference? Or what you're looking for?

Wow great comments, and a few emails as well.

Thanks for the notes and I'm very, very proud that we have been able to help so many of you. And for...

I think that's a pretty good solution and it was about what I'd suggest. Use a unique number of reach one, and include the datetime.

We used to do something similar,...

You want to alter the column to allow nulls, not a default of null. Run these one at a time. The first insert of null should error out.

create table MyTest

(...

So which fields or rows do you want to differnce of time between?

Are you looking for the difference between two columns or the difference between every row? Every pair of...

Not sure. Are you sure it should be displayed? There could be system processes or SQL logins.

You cannot have a database name for a variable as you've asked without dynamic sql.

In SQL Server 2005, use sys.databases, not dbo.sysdatabases.

This almost sounds like homework. Can you post what you've tried?

It could be exploited to send mails anywhere, which would be coming from your server/company. However it really depends on you properly checking which mails are going out. Set up...

Not sure what's wrong here? Where are things crashing?

It might be the rebuild. That usually requires 1.5 times disk space in the data file and records a lot of log changes. Can you snapshot the log file size...

That's got to be something (or something missing) in the forum code. I'll take a look.

The code link is fixed. Apologies for that.

First, congratulations.

Second, be sure you have backups running and practice a few restores.

After that, you might want to get a book on SQL Server, read it, and then ask questions...