Hi Barsuk,

I'm sorry, but I can't explain why it works. I got that script from a script library somewhere in the Net (can't remember where) after a lot of searching because I had...

After many attempts, this script worked for me:

use <YourDatabase>

go

DBCC SHRINKFILE (  <YourDatabase>_Log , 5,TRUNCATEONLY )

go

BACKUP LOG <YourDatabase> WITH TRUNCATE_ONLY

go

drop table mytable

go

CREATE TABLE MyTable (MyField VARCHAR(10), PK INT )

INSERT Mytable (PK)...