I always loose the plot when all of them talk in Yodi language or these tongues...:-)

I have never seen these errors before. But it is talking about the Cacheplan which is usually in the memory.

Pagefile you can see it on the server itself. That is set up by the people who install the OS.

I have a feeling that your option are very limited.

1. Restart...

Do you know how much RAM you have on the server, What is the Pagefile Size?

Also are there SPs that are running quite often with SET NOCOUNT ON option...

It wont be that much of a load on the subscriber. Hopefully your subscriber is a pretty good server. 🙂

We should let Lynn Answer that .. 🙂

We will see the battle between the Jedi Master and the Jedi Wanna be... 🙂

Perrys option is far better than mine.... Use his please and discard mine..:D

You can monitor the table on the profiler. You can use the Table name as Text with Wild card. Or if it is SP, you can use the name of...

Nope... Identity wont work unless your table already has it. My guess is that you will have to live with what you have.

Maybe giving the table structures and some...

If you have identity column in your table, then you can use the function to return the ID of the row that was inserted. You can get details regarding it...

He seems to be getting the hang of it.. I guess he just have to get adjusted to SQL.

Here is someone who is almost ready to drive people nuts...

You can use IF EXISTS clause to find if a record exist in Header table. If it exists, then insert into Edit table. If it does not exist, you can...

I think you should have posted in SQL 2000 Forum and not sql 2005. When you post in SQL 2005 forum, the answers you get will be based on the...

You can call SPs within an SP but maybe you can analyze your requirements more and see if you can do everything in one stored Proc with SET Based Operations....