Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
USE [DB1] GO DBCC SHRINKFILE (N'DB1_log' , 0, TRUNCATEONLY) GO USE [DB2] GO DBCC SHRINKFILE (N'DB2_log' , 0, TRUNCATEONLY) GO USE [DB3] GO DBCC SHRINKFILE (N'DB3_Log' , 0, TRUNCATEONLY) GO
SELECT @i = MIN(database_id) FROM sys.databases WHERE database_id > @i AND (owner_sid <> 1 AND is_distributor<>1) <-- line 50 AND state_desc='ONLINE'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.