Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shrink logs
Message
 
 
To
10/07/2009 15:50:08
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01411487
Message ID:
01411504
Views:
30
This almost worked with some errors:
declare @Str varchar(800)

set @Str = 'ALTER DATABASE ? SET RECOVERY SIMPLE' + CHAR(13) + 'DBCC SHRINKFILE (N''?_log'',0,TRUNCATEONLY)'

execute sp_msForEachdb @Str
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform