Rerun Performance Monitor with the same counters that Gail listed, plus these addiitonal:

Memory\Available MBytes

Memory\Page Faults/sec

Memory\Page Reads/sec

Memory\Page Writes/sec

The following should have "*all instances" set:

PhysicallDisk(*)\% Idle Time

PhysicallDisk(*)\Disk Reads/sec

PhysicallDisk(*)\Disk Writes/sec

PhysicallDisk(*)\Avg Disk Queue Length

Processor(*)\%...

Yeah, I researched it some time...

Tony, Jeff, why don't you just join the committee? I don't think that its as hard as all that.

jezemine: I did...

TheSQLGuru (6/20/2008)

---

rbarryyoung (6/20/2008)

---

Not necessary. As I...

JRJ (6/20/2008)

---

Thanks guys for your response, it's really useful. I am just wondering which one will be faster when I deel with some 50,000 records: the one with temp table...

Not necessary. As I demonstrated above,...

As promised here is the stored procedure that will list a procedure that you name, including the "DROP.. IF.." prefix:

ALTER Proc spScriptProc_DropIf( @proc as SYSNAME, @schemaName SYSNAME = N'dbo' )...

I think that we have the same thing, Gus.

Sherjon (6/20/2008)

---

We have not found an easy way to format a 2005 script that is compatible with it's 2000 counterpart. It's quite cumbersome to Create a DROP script, then...

Matt Miller (6/20/2008)

---

I wouldn't...

I just want to register my agreement with Jeff. If this is truly a one-time thing and really only 7 items, then sure, go with this. But if...

Jeff: Good point about the UoM. Here is a corrected/improved version:

SELECT Metal, UoM

, min(Result) as [Min]

, max(Result) as [Max]

, count(Result) as [Samples]

, avg(Result) as [Mean]

, stdev(Result) as [Std....

Good point Kevin.

I have attached two screen shots that show how to get the Save Options that the OP had in SQL2000.

This is how you select the Script to New...

OK, I think that I know what the problem is here: When you script the procedure, do NOT script it directly to a file. That option does not...