Tru
cLog‘BACKUPLOG‘db_
ame‘WITHTRUNCATE_ONLY‘DBCCSHRINKFILELogicalFileNameNewSizeEXECTru
cLogWrapthelogif
ecessaryWHILEMaxMi
utesDATEDIFFmiStartTimeGETDATEtimehas
otexpiredANDOrigi
alSizeSelectsizeFROMsysfilesWhere
ameLogicalFileNameANDOrigi
alSize81024NewSizeBEGINOuterloopSelectCou
ter0WHILECou
terOrigi
alSize16ANDCou
ter50000BEGINupdate
fI
sertDummyTra
sVALUES‘FillLog‘DeleteDummyTra
sSelectCou
terCou
ter1ENDEXECTru
cLogENDSelect‘Fi
alSizeof‘db_
ame‘LOGis‘CONVERTVARCHAR30size‘8Kpagesor‘CONVERTVARCHAR30size81024‘MB‘FROMsysfilesWhere
ameLogicalFileNameDropTABLEDummyTra
sSETNOCOUNTOFF8、说明：更改某个表execsp_cha
geobjectow
er‘table
ame‘‘dbo‘9、存储更改全部表CreatePROCEDUREdboUser_Cha
geObjectOw
erBatchOldOw
erasNVARCHAR128NewOw
erasNVARCHAR128ASDECLARENameasNVARCHAR128DECLAREOw
erasNVARCHAR128
fDECLAREOw
erNameasNVARCHAR128DECLAREcurObjectCURSORFORselect‘Name‘
ame‘Ow
er‘user_
ameuidfromsysobjectswhereuser_
ameuidOldOw
erorderby
ameOPENcurObjectFETCHNEXTFROMcurObjectINTONameOw
erWHILEFETCH_STATUS0BEGINifOw
erOldOw
erbegi
setOw
erNameOldOw
er‘‘rtrimNameexecsp_cha
geobjectow
erOw
erNameNewOw
ere
dselect
ameNewOw
erOldOw
erFETCHNEXTFROMcurObjectINTONameOw
erENDclosecurObjectdeallocatecurObjectGO
f10、SQLSERVER中直接循环写入数据declareii
tseti1whilei30begi
i
serti
totestuseridvaluesisetii1e
d
fr