Thank you for your explanation. That was a misunderstanding about the global tables theory. Usually I used them into sql_execution or EXEC sentences which creates another session. I never use...

I'm also not totally agree with you.

When the instance restarts : true : all connections are closed, and the tempdb is recreated from 0 when the instance starts.

When the session...

All the queries should return NULL.

Also I tested and the result it's the same.

I am completely agree with you. The members of the local Administrators can be modify to exclude the local Windows Administrators group. This is a security good practice.

The problem is that yu are instructing to SQL to Apply Style to one DateTime DataType.

The Styles only apply for Varchar(n) DataType see the Help.

Becasue I need to use the where is diferent but always I need to get the sama records.

Also I need Update teh cursor base on the cursor.

Really the solution Identity does not work because the example not is really equal to the Sentence SQL that I need. Really not is only add 1 to the previous...

Thank you friends select top 100 PERCENT is the best correct solution, to my problem thaks for all.

Yes you are rigth.

But if I need that this error message conformed pass from one internal store procedure to other and finally from this, the error could be sent to...

As you say there is not an easy way to do that I gonna read.

But tanks for your help

> I want stored procedure A to call stored procedure B, which returns a set of

> records from a table. Then, I want stored procedure A to perform work on

>...

I am trying to obtain and use data into a Store Procedure that other Store PRocedure Produces before.

Thank you.

Yes the Temproally table are one option, but there not is other easy and less expensive tecnically talking.

Your answers 

2. SQL Server Version = 2000.85.1117.00

3. ODBC Driver Manager Version = 2.81.1117.0

Thanks...

Your answers 

2. SQL Server Version = 2000.85.1117.00

3. ODBC Driver Manager Version = 2.81.1117.0