excelent!, thanks Criag...

It works very well

Ok. Then, first back up the DB, next restoring on secondary server, and finally enable the log shipping??

Hello,

I have the same problem, I need to delete thousands and thousands of records, I dont want to truncate the table...

the problem is that the log reach the 100GB and...

Dont worry Man, I change the temp table to defined columns y with that fix my problem.

but if you like to see the code where I create the temp...

Well, I choose to fix the columns because the matter from the begin was the name headers of columns and the N number of columns has limit that are the...

Ok.

I have an App Report, this execute the store p1. here there is no problem.

Beside, i have an store p3, to send an email with those data. p3 define, subject,...

ok. thanks both for your answers. but at this moment I think the answer of Bob is more useful for me.

How can I do that?

well, actually the store two is...

Well, searching for a while I found this:

CREATE TABLE #tmp

(col1 INT,

col2 VARCHAR(50),

col3 VARCHAR(255))

INSERT #tmp

EXEC dbo.MyStore

but the problem is that...