Thank for every one i get the concept after reading the article....

No Dear iam not anger but table('sys.trigger') you specified is not exists

on any databases so how i can get the infornation when the table you specified in the code is...

thanks for your response....

but I know how to set trigger order i want information about the object who contain the order of execution of trigger on a table ..

dear Ausstin,

tail log back up is option to solve your problem...

take the tail Log Back up using the syantax

use master

go

sp_adddumpdevice 'disk',' '

backup log

to

with norecovery

this statement...

dear Ausstin,

tail log back up is option to solve your problem...

take the tail Log Back up using the syantax

use master

go

sp_adddumpdevice 'disk',' '

backup log

to

with norecovery

this statement...

thanks for reply andras..

it will clear my concepts

thanks.

I JUST COMPLETE THE PROC GIVE BY RAMESH

CREATE PROC PRCSYSOBLECT @sOUTputType VARCHAR(1)

AS BEGIN

IF ( (@sOutputType = 'U') OR (@sOutputType = 'u'))

BEGIN

SELECT * FROM sys.databases WHERE database_id>6

END

ELSE if(...

Dear whats you are doing you are inserting null values from table b to tableA col1 which is not allow you to insert null values if you want to insert...