Thanks.

However, unless I am missing something, this doesn't do away with the need to have an existing table with at least n rows in it, and that's the...

I installed SP4 on a test machine with SQL 2000 Enterprise. Seemed ok, so after a couple of days I put it on a production machine -- no problems...

Maybe you should congratulate the guy on his thorough approach to security. Just draw up an agreement that whenever you do need admin access to do your job, this...

Well, if you don't need it you can remove xp_cmdshell. That still leaves plenty of other holes though ... you'll find plenty of good material on this site that...

I speculate that in 'normal' usage conditions on a 32bit chip you'ld see an all round performance deterioration if you needed more than 4,294,967,296 (*) indexed records in a table...

quote:

---

Well, that's what the admin told me.

---

Ask this admin if you can get copies...

It looks like the code in that link could definitely be modified to do what you want.

However, working with Win APIs from a stored procedure might not be...

http://www.iisfaq.com/default.aspx?View=A486&P=141

Crispin, that's very naughty

Oh, and I think you just need to log the time as the last command of every ASP page. (trapping between the first...

You may be able to do this direct from SQL Server (I don't know how but I don't know much).

If I was doing this, I would write a service application...

quote:

---

I'm not admin of the webserver and can not get hands on [the logfile] . so I have to do this...

Have you considered working this out from your webserver logs? If your webserver is IIS, I seem to remember its just a few clicks to import your webserver logs...

quote:

---

That means if you have SQL Server running under the context of localsystem or as a user account that has administrative rights...

quote:

---

in

reality when the code runs error free and is it production, and you should document it somehow, you're confronted with the...

quote:

---

I'm at the stage of the project now where I need to start documentation.

---