Search Engine
Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
This search, performed through 582.69 KB (179 documents, 6974 words), completed in 0.0 seconds and yielded 2 results.
[...] log 디비명 With TRUNCATE_ONLY DB 정보보기 sp_helpdb 디비명 DBCC SHRINKFILE (test_log, 5)
예) backup log DBNAME With TRUNCATE_ONLY sp_helpdb DBNAME DBCC SHRINKFILE (DBNAME_Log [...]
[...] forget to change db name
use db, and in the middle there is line
IF @indid 255 DBCC INDEXDEFRAG ([DBNAME], @TableName, @indid) DECLARE @TableName sysname
DECLARE @indid int
DECLARE cur_tblfetch CURSOR FOR
SELECT table_name FROM information_schema.tables WHERE table_type = 'base table'
OPEN cur_tblfetch
FETCH NEXT FROM cur_tblfetch INTO @TableName
SET @TableName='[' + @TableName + ']'
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE cur_indfetch CURSOR FOR
SELECT indid FROM sysindexes WHERE id = OBJECT_ID (@TableName) and keycnt > 0
OPEN cur_indfetch
FETCH NEXT [...]