Finally i'm back after a month of crazyness due to my webhost not performing up to its promise of 99.9% uptime. Enough with the rant and on with the article, today i'm going to talk about how to list databases in a SQL Server by just using T-SQL and then showing you how to truncate the logs on...
Posted to
Keith Rull
by
keithrull
on 01-22-2008
Filed under: SQL, T-SQL, sp_MSforeachtable, Truncate Table, DBCC, sysdatabases, sys.sysdatabases, Truncate Database Logs, SHRINKDATABASE, sp_msForEachDB, sp_databaases, sp_helpdb