最全SQL

@TruncLog = 'BACKUP LOG ' + db_name() + ' WITH TRUNCATE_ONLY'yMV拜客生活常识网

yMV拜客生活常识网

DBCC SHRINKFILE (@LogicalFileName, @NewSize)yMV拜客生活常识网

EXEC (@TruncLog)yMV拜客生活常识网

-- Wrap the log if necessary.yMV拜客生活常识网

WHILE @MaxMinutes > DATEDIFF (mi, @StartTime, GETDATE()) -- time has not expiredyMV拜客生活常识网

AND @OriginalSize = (SELECT size FROM sysfiles WHERE name = @LogicalFileName)yMV拜客生活常识网

AND (@OriginalSize * 8 /1024) > @NewSizeyMV拜客生活常识网

BEGIN -- Outer loop.yMV拜客生活常识网

SELECT @Counter = 0yMV拜客生活常识网

WHILE ((@Counter < @OriginalSize / 16) AND (@Counter < 50000))yMV拜客生活常识网

BEGIN -- updateyMV拜客生活常识网

INSERT DummyTrans VALUES ('Fill Log') DELETE DummyTransyMV拜客生活常识网

SELECT @Counter = @Counter + 1yMV拜客生活常识网

ENDyMV拜客生活常识网

EXEC (@TruncLog)yMV拜客生活常识网

ENDyMV拜客生活常识网

SELECT 'Final Size of ' + db_name() + ' LOG is ' +yMV拜客生活常识网

CONVERT(VARCHAR(30),size) + ' 8K pages or ' +yMV拜客生活常识网

CONVERT(VARCHAR(30),(size*8/1024)) + 'MB'yMV拜客生活常识网

FROM sysfilesyMV拜客生活常识网

WHERE name = @LogicalFileNameyMV拜客生活常识网

DROP TABLE DummyTransyMV拜客生活常识网

SET NOCOUNT OFFyMV拜客生活常识网

8、说明：更改某个表yMV拜客生活常识网

exec sp_changeobjectowner 'tablename','dbo'yMV拜客生活常识网

9、存储更改全部表yMV拜客生活常识网

CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatchyMV拜客生活常识网

@OldOwner as NVARCHAR(128),yMV拜客生活常识网

@NewOwner as NVARCHAR(128)yMV拜客生活常识网

ASyMV拜客生活常识网

yMV拜客生活常识网

DECLARE @Name as NVARCHAR(128)yMV拜客生活常识网

DECLARE @Owner as NVARCHAR(128)yMV拜客生活常识网

DECLARE @OwnerName as NVARCHAR(128)yMV拜客生活常识网

yMV拜客生活常识网

DECLARE curObject CURSOR FORyMV拜客生活常识网

select 'Name' = name,yMV拜客生活常识网

'Owner' = user_name(uid)yMV拜客生活常识网

from sysobjects

相关阅读: