Ok,thank you.I will try

Sorry,I cant post execution plan.is the problem related with plan cache?

No,I run the same parameters

Yes,the execution plans are the same all time..

but some of table statistics are not run..

Thank you very much.I will examine the links

Best Regards

If I try to execute following,when inner procedure transaction rollback ,is outer procedure transaction rollback?

Inner SP

CREATE PROCEDURE [dbo].ProcB

(@X INT)

AS

BEGIN

BEGIN TRY

BEGIN TRAN TR11

INSERT INTO TableC SELECT 1

INSERT INTO TableD SELECT 2

COMMIT...

I need when inner procedure transaction is rollback,outer procedure transaction must be rollback..

It is possible?

Yes that is true for nested transaction,but transaction is in nested procedure when rollback,outer procedure transaction does not rollback..

Yes I am,I think I could not tell my problem

for example

create procedure aaa

as

begin tran

.....

....

create procedure bbbb

as

begin tran

exec aaa

....

....

when aaa rollback I want to rollback bbbb

Yes I need last 4 months info.I saw some error logs in the default folder.

But they are not clear for me

Yes,I have only 1 week logs on sql server logs

I checked but I have only 1 week Sql Server Error Logs .

but I need 4 months logs:(