Are table variables stored in tempdb, because we are trying to insert huge amount of data into table variable using sql syntax:-
ID = 0 OR ID = 1
We are getting the error message as :-
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Any work around, please help me out.
View Complete Post