I have a table called dbo.files which has a field filesize data type int.
I changed the data type to bigint and saved the table successfully.
Then I open the table and increased the filesize of one record from 30 to 21073535353.
It was fine...
Then I returned the value back to 30 and saved.
Now, I wanted to change the bigint to int.
I receive the error... 'files' table -Unable to modify table. The transaction log for database 'gprddevelopment' is full. To find out why space in th elog cannot be reused, see the log_reuse_wait_desc column in sys.databases