I dont think there are any triggers setup on this database or tables. Should we truncate the log file and create another one?

I dont have test environment. But I created a duplicate to this database on the same server & this problem is not there on that new db. I'm not getting...

My database files was setup as autogrow & log file as max limit to 100MB. Where it has occupied just 7MB now.

Hi Ray,

Nope, I'm not getting any error message on server console. But its all of sudden stop doing insert & updates into few of my tables. I appreciate you help.

Regards

Hi John,

Yes, my DB set to auto grow. And yes, I can update / insert into some tables but not others.

I remember i had created another logfile along with the...

Hi Bill,

Its not authenticating through domain controller. I have setup IUSER_<machine name> windows user setting under security -> logins option via enterprise manager. I have also verified that the db transaction log has...

Hi Rao,

Thanks for your quick reply. The current transaction log size seems just 6 MB where I have given restrict file size limit as 100 MB. Is there anything more we should...