Another issue noted. Even though I increased the size of the log, when a user tries to log in to the system through an app that is connected to the...

BTW Gail, I did what you suggested. And still ShrinkFile not working....Before running the transactions and after running the transactions its same

CurrentSizeMinimumSizeUsedPagesEstimatedPages

256496080 ...

One issue...The initial log size was set to 1...Could this be issue? I increased this to 25% of the database size and ran SQLPerfLogs and now it is showing space...

Dan, tried that. But that didn't help. The screen closes in fraction of second as if nothing happened.

reason says NOTHING.

Currently allocated space: 20038.75 MB

Available free space 101.13 MB (0%)

No error on checkpoint and no active open transactions and no blocking.

No blocking. Enterprise Edition.

Yes. And sanpshot isolaiton level on, auto update statiscits on as well...not sure if that contributes to fill the transaction log.

Autogrow. I had created a DMP to update statistics and rebuild index. Thats when db grew.

Every 15 minus...And diff backup every 1 hour

FULL. Yes nightly backup (every 24 hours)

Yep. I had 'take tail log backup' option checked. Thanks.

Got it. Once I got the error message, I copied sqlserver.exe and sqlos.dll from other server and repalced that in the local BINN directory and that worked. Although, I am...

Yes it rolled back. NO Sql server services.

Error log shows : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to:...

PATINDEX is not going to work. And temp table solution is also not going to work. Since, those values are (list of strings) are in table and can contain any...