For the test purpose you can set the T log size to a lesser size
and create some dummy transactions (insert / update / delete) until the
T log fills up.

For truncating you can look at Backup statement.

"Backup Log <dbname> with truncate_only"

John
www.ideo.com

-----Original Message-----
From: DBA DBA [mailto:[Email Address Removed] January 31, 2003 9:18 AM
To: LazyDBA.com Discussion
Subject: Filling up the transaction log for notification test


I am new to MS SQL Server. I need to write a stored procedure to fill the
transaction log and then another one to truncate it. Any thoughts?

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page