Some times the session times out and you lose the message.  If you had to hit post reply twice to get the post working then that is what happened.

--This would take about 2 hours to run on my pc.

SELECT  TOP 999999999

  IDENTITY(int, 1,1) AS Demo

INTO   #Test

FROM   master.dbo.SysColumns C1

  CROSS JOIN master.dbo.SysColumns C2

  CROSS JOIN master.dbo.SysColumns C3

SELECT COUNT(*) AS...

Yup check out identity in the books online.

Well that still works.. depending on what you want to do with it.  The child proc will be able to access the temp table as if it had created it.

Nothing to add here.  Profiler is the only real option.

You can add the code to all the sps, but that still leave a lot of holes in the code (direct...

That's why I love to see and use scripts .

Maybe this would have avoided the truncatation of the post :

declare @var varchar(max)

select

@var =...

There's a lot more to that to do performance testing.

Are you using a sql server on a local pc (network can't be an issue)?

Are you emptying the procedure and memory...

It's hard to answer that one without seeing the test script you used.  Can you provide it to us?

Yup, I had an emergency and I couldn't provide the full answer.  That's why we are called a community after all.  Thanx Anders.

Also have you run any dbcc command to check the integrity of the database?

Here's a full script that creates a new users, adds him to the sa role and grant him access to the database.  Then it show how the sp_rename works.

At this...

How come this ain't in the format :

SaleManID, SaleAmount??

Precisely.

You need a table that maps the salesmen to a team (actually 2 tables).

If you don't have that you can do a cased group by but I would strongly advise...