Ah, but you posted in a SQL2005 forum ... hence my reply.

for sql2000 I use this:

- sp_who2

- and the consumers :

if (object_id('tempdb..#tmpVerbruik') is null)

begin

-- tmptabelleke aanmaken

select min( @@Servername ) as...

This is one way you can do it...

http://www.sqlservercentral.com/scripts/Miscellaneous/31032/

Off course the free MS "performance dashboard" is a good way of showing it.

and this may also be a good starting point.....

-- lists the top 50 statements by input/output usage....

Mike Martin (6/5/2008)

---

We are still having an issue with this. The interesting thing is when we eliminate the date range in the criteria, the datetime formats are different. ...

No.

You can only do that by composing dynamic sql. :crazy:

Please have a look at: The curse and blessings of dynamic SQL

http://www.sommarskog.se/dynamic_sql.html

- Keep in mind the concept of a primary key ! There must have been a reason to use this column for it ( or as part of it)

- Check...

Christopher G.S. Johnson (6/2/2008)

---

So, I didn't read these type posts before deleting the Builtin\Admin group. Now our third-party backup process is crying for failure to login as "NT Authority\SYSTEM"....

- for sure an active backup to that file will lock it.

- most of us tend to (x)copy the file to a safe zone at the end of the backup...

did you enable it to use tcp/ip ?

Just to add to the previous post...

First of all it is a good thing you plan to migrate in stead of upgrade.

- whatever you do, start with SQLServer 2005 upgrade...

Here it comes again .... :hehe:

THIS SCRIPT IS NOT INTENDED FOR SCHEDULED USAGE !! READ BOL to find out how a db-log works !

With full recovery, you need to perform...

-Check out the upgrade logs !

You'll probably find them at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

After that, if I were in your shoes, I would rerun SP2.

The login mode...

Indeed using the cte for this is a great solution.

There is a little caveot concerning data usage.

You absolutely need to know where you're comming from to be able to link...

based on your query that's exactly what it should return.

SELECT FactID AS ID, EmplyID, PersonID, 'Factory' AS WorkPlace

FROM ...

:ermm:

Just a little reminder of a nice article...