If the account is on the same machine, yes.

If it's local system of a remote...

Looks like (bad) parameter sniffing in action.

Grant Fritchey wrote an excellent chapter of SQL Server MVP Deep Dives Vol. 2[/url] all about parameter sniffing and I strongly suggest buying this...

I see no attachment. Am I missing something?

In SQL 2000 you could use sysprocesses, which returns almost the same information.

Lynn Pettis (8/7/2012)

---

Gianluca Sartori (8/7/2012)

---

A sliding window partitioning strategy could help here.

Dan Guzman has a couple of nice posts on the subject:

http://weblogs.sqlteam.com/DANG/archive/2008/08/30/Sliding-Window-Table-Partitioning.aspx

http://weblogs.sqlteam.com/dang/archive/2008/09.aspx

Setting up the partition scheme and rebuilding your indexes...

In SQL2008 you probably want to use sys.dm_exec_sessions and identify sessions that have been idle for the last 30 minutes:

DECLARE @idle_timeout int = 30; -- minutes

SELECT session_id

,status

,login_time

,host_name

,program_name

,host_process_id

,original_login_name

FROM sys.dm_exec_sessions

WHERE status...

You can order by the datetime column, even if you don't include it in the select list.

Not very different in SQL 2008.

Is there any chance to let the application do that?

Not sure what you mean.

The logon trigger is executed as part of the log on process. The session is established before the trigger runs, but the session is not available...

That's how I would do it.

Even if SQL Server 2000 had logon triggers, it would not help, as you would have to check for existing sessions, not for new ones.

If you just want to track database size, schedule a job to capture the information and store it into a table:

CREATE TABLE SizeHistory (

CaptureDate datetime,

...

Not easy to do in SQL 2000.

However, let me ask, why would you ever want to do this?

A sliding window partitioning strategy could help here.

Dan Guzman has a couple of nice posts on the subject:

http://weblogs.sqlteam.com/DANG/archive/2008/08/30/Sliding-Window-Table-Partitioning.aspx

http://weblogs.sqlteam.com/dang/archive/2008/09.aspx

Setting up the partition scheme and rebuilding your indexes on the partition scheme...

Very interesting Dwain!

A very nice read.

Thanks for sharing.

jcrawf02 (7/27/2012)

---

Gianluca Sartori (7/27/2012)

---

Jeff Moden (7/27/2012)

---

...

Man! ...