Don't create a trigger for that. Use an Identity column.

You can use this to create the trace:

declare @ID int, @FS bigint, @FilePath nvarchar(245), @1 bit

select @fs = 10,

@filepath = 'F:\DBA\Trace\TSQLTrace', -- The path where the trace file will...

RJ (2/19/2009)

---

it is web-based & each user doesn't have separate connections. they use a shared connection string but each user would be given a separate username (application specific & not...

How are users connected to the database? Is it something that can feed their username to the server?

I searched for "The alert for 'time behind' has been raised" in Live Search.

The second result was http://msdn.microsoft.com/en-us/library/aa337363(SQL.90).aspx.

That page has this to say about it:

Explanation

This database mirroring event...

A trigger will also only work if it can get the "updateby" data from somewhere. That's fine if you're using different SQL logins for each user, but not if...

If you drag the "Columns" folder from each onto the workspace, it will produce a list of the columns. Remove the ones you don't want, and you'll have what...

If you put the alert message into Google/Live/whatever, it comes up with a couple of articles on MSDN on what that means and what to do about it.

He's one of about three...

Is there a reason you can't just multiply the original amount by 100?

Hard to tell without having the data, etc., that goes with it. It looks like it calls a couple of other functions. Have you tested to find out...

Grant Fritchey (2/19/2009)

---

Good choice. All that high kicking junk is a waste of time, effort, motion and will surely get you into trouble. Stomp on their feet or kick their...

I think on the log file you could simplify that a lot by just issuing the right Alter Database commands. Of course you do a backup before issuing them,...

Since that's the actual update of the actual table, there really isn't a way to directly reduce the cost of it.

It wouldn't happen to be updating one or more of...

Roy, at least with me, you don't have to worry about being martial-arted, or outrun. I'm 40 pounds overweight, have a bum knee and arthritis in my hips. ...