Thanks - thas exactly what I was after.

Is there any benefit in changing the database ownership to SA over and above say the SQL Server service account (e.g. "YourDomain/SQL Server Service...

Im interested in the reasons why one might change database

ownership to SA for each non system database (e.g. away from local administration account or other domain...

FYI, I had the same problem too  - the dbowner was NULL causing the following statement ;

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53

Cannot insert the value...

Are the servers dedicated MsSQL boxes ?

Not sure what hot-add memory is and how this affects things, but I dont understand why don't your need /PAE switch?

MSDN explains:

"Physical Address Extension

The...

David,

Couple of questions for you;

"So if you have multiple processors and only one file then only one of them will be able to write data to disk. To see...

Check out this very useful procedure by Erland Sommarskog, it should tell you what you want to know.

http://www.sommarskog.se/sqlutil/aba_lockinfo.html

Dan,

"a database file per disk in your array "

I assume you inferring having the same number of files as disks within your array, rather than a file on each disk...

Thanks guys, both very useful posts. Im running with Craig's link right now.

For those who are also reading this thread, here are some useful descriptions of the standard Profiler templates.

FYI, I'v patched MSSQL to 3a and this code is still not working beyond the getoffset call.

FYI, Im running Microsoft Excel 2000 v9.0.6926 SP-3. ...

Im trying to use this code as well, and I am running into a problem where the code errors when issueing he offset command. (Ive added error display code below).

EXEC...