Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Tempdb log full

    I think I may have solved it, time will tell.  I took the SPID that had all the locks, went to SQL Profiler and found the NTUserName that was causing...

  • RE: Tempdb log full

    I was just doing some reading and saw that it was a bad idea to have table level locks, two of those 600 items mentioned in my previous post are...

  • RE: Tempdb log full

    I changed the default size of tempDB log file from 1Mb to 20Mb this morning.  I set the AutoGrow to grow by 200Mb.  I am looking at the Locks/Object table...

Viewing 3 posts - 1 through 3 (of 3 total)