can u pls tell me how can i check this ...

hi ...pls check my topic " trigger issue" in administering forum.....

if you can help than i will be very thankful to you

sory i should use word inactive instead of uncommited...but if you are telling that it's not see whatever in log file then how can it see that this is inactive...

whatever i know is that when you shrink log file it will remove all uncommited transaction from transactional log file ....

so whenever you want to shrink log file first keep...

i m not seeing that inserted data i know that i can see through directly this is for just example...what i m doing is from from inserted data i m...

is there any one who has idea related to this

set min and max memory to your preferebale choice like 500 mb or whatever you like ...

set min and max memory to one fixed value...like if you set 500 mb...

is that sql server only used by you or may be multiple user use that...or any application....you have to check first those things ...

hi if you can give more description abt what's your update statement ....

and what you have written in trigger

and r u using row that are updated in procedure... give...

instead of on update use after update

ALTER TRIGGER [dbo].[tr_insert]

ON [dbo].[table1]

AFTER INSERT

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET...

hi but i m not importing data through bulk insert actually ... i m doing that through import and export wizard .....

so can u pls help out me for...

Hi by mistake i have do two post so i m going to unsubscribe from one ....

hi,

do one thing... goto services... in run type services and then in services ...

sql server agent(mssqlserver) try to restart or start from here.... is there any positive result if no...

can u pls tell that all those data comes in which file means in txt or in excel....