Audit Logout is an event that you selected to pick up in your trace.  The duration for the Audit Logout event is how long that connection was connected to the SQL...

To answer your question, you can do this:

select IDENT_CURRENT('TABLE_NAME') + IDENT_INCR('TABLE_NAME')

IDENT_CURRENT() will return the last identity value generated for the table and the IDENT_INCR() will return the increment value for the...

I have had this problem before when dealing with a trigger and the virtual inserted/deleted tables.

What I had to do was change the if exists(select * ...) to

quote:

---

I've always found that with proper clustering, tuning of queries and giving the server enough RAM, locking has not been a problem...

If you right click on your SQL Server Logs and select "Configure", you can specify how many logs to keep. Then, just setup a job to run sp_cycle_errorlog every...

You could use the mail merge feature in MS Word. Just write your 'exec sp_addlogin' and 'exec sp_adduser' statements then merge it together with your formatted source file. ...

quote:

---

Trust me, jarretg, you should get rid of rowlock, bet your problems will go away.

---

I...

quote:

---

Disadv:

- when using "with (nolock)", you will not seen comitted transaction (changed one) at this moment ... but you can see...

quote:

---

Is there any particular reason you are using the ROWLOCK hint?

---

The reason I added the...

I don't think they are in any of the system tables, but I know they are in Books Online. Search for sp_trace_setevent, all of the event numbers are listed.

...

I just tried to use 'count(*) > 0' instead of 'exists()' and it ran much faster!!! I still have to check to see if the count implementation is going...

I would like to take out the columns from the update statement, but unfortunately, I can't. The users have to have the functionality to update these 'not so frequently...

Jonathan - Why is it that the insert of zero rows would take less time than the exists? SQL has to build the result set either way, right?

NPeeters -...

I'll turn off autogrow on all but data file #2 and let it catch up, then set it to "Off" for autogrow and just schedule expansions.

Mark - How do you...