Hello, I have a problem when running a report in Crystal Reports 10 with an OLE DB connection to SQL Server 2000. The report executes a SQL stored procedure creating a large temporary table (30,000 rows), aggregates are then calculated from this large table and collected in a smaller summary temporary table using INSERT INTO.
The report crashes in Crystal 10 with the error message : 'The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.'. I used BACKUP LOG WITH TRUNCATE_ONLY to shrink the log file but the error still occurs.
The stored procedure can be executed within SQL Query Analyzer with no error messages, which is curious as Crystal cannot execute the procedure without log file problems occuring.
Can anyone offer a suggestion or view on this problem ? Thanks
The report crashes in Crystal 10 with the error message : 'The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.'. I used BACKUP LOG WITH TRUNCATE_ONLY to shrink the log file but the error still occurs.
The stored procedure can be executed within SQL Query Analyzer with no error messages, which is curious as Crystal cannot execute the procedure without log file problems occuring.
Can anyone offer a suggestion or view on this problem ? Thanks