Of late, we have been getting the following error every now and then. We are using MS SQL Server 2000 and it‘s JDBC drivers.

DATABASE ERROR CODE : 257
11:58:18 [ ] WARN WEB DATABASE ERROR CODE : 257
11:58:18 [ ] ERROR …

What happens when you try the following inside a SQL Server Strored Procedure?

EXEC (‘CREATE TABLE #TEMPTABLE‘+‘123‘+‘(firstColumn varchar(10), secondColumn varchar(20), thridColumn int)‘)
INSERT INTO …

What does the transaction log contain?
Transaction log contains log records which are necessary for recovering or restoring a database.

What happens if these log records were never deleted from the transaction log?
Every transaction log has a fixed size….