Home
Blogs
Forums
Downloads
Site Search:
Sign in
|
Join
|
Help
This Blog
Home
Contact
Common Tasks
Syndication
RSS
Atom
Comments RSS
Receive Email Updates
Subscribe
Recent Posts
for XML PATH
Combined INSERT, UPDATE and SELECT statements
Create an update statement
Cursor Template
Grant permissions cursor
Tags
aggragate
comma
mail
Recovery Model
semicolon
sp_OACreate
sp_OAMethod
SQL 2000
SQL 2005
sql mail
sql server
sqlmag.com
streamwriter
syscolumns sysobjects
sysobjects
text file
truncate log
Archives
August 2008
(3)
July 2008
(1)
June 2008
(1)
May 2008
(2)
April 2008
(1)
January 2008
(3)
December 2007
(5)
November 2007
(3)
October 2007
(3)
August 2007
(7)
June 2007
(1)
May 2007
(1)
April 2007
(2)
March 2007
(5)
February 2007
(3)
January 2007
(9)
SQL Server (T-SQL)
Comments and notes on SQL Server 2000, 2005, and T-SQL
Browse by Tags
All Tags
»
SQL 2005
»
truncate log
(
RSS
)
SQL 2000
Truncate the Log Size of All Databases on a SQL Server
This is a combination of logic from 2 previous posts - this piece of code will truncate the log file size for all the databases in a SQL Server. It has been tested against SQL 2000 and 2005 --delcare variables declare @vchrTable varchar(200), @vchrMsg...
Posted
Mar 24 2007, 01:20 PM
by
Steve Gray
with | with
no comments
Select Tags...
Save
Cancel
Filed under:
SQL 2000
,
truncate log
,
SQL 2005
[Edit Tags]