-
编辑 删除
resolve webdb sync issue
How to resolve the WebDB synchronization IssuesSometimes,the WebDB can’t be synchronized with the Primary database,and we should handle it according to the reason why the synchronization fails.It ...
-
编辑 删除
job alert sp
/*****************************************************************************Created On 11/09/2006 To Update DB's JobInfo to PerfAnaly..db_jobstatus and Send Alert Mails When The JobStatus Is Changed...
-
编辑 删除
send mail SP
CREATE PROCEDURE [dbo].[SendMail_cdo_sp] @From varchar(100) , @To varchar(8000) , @Cc varchar(8000) = '', @Bcc varchar(8000) = '...
-
编辑 删除
trace configuration
LRQ_B2BWebDB.ini ：@tracefile = D:\DBTRACES\LRQ_B2BWebDB@maxfilesize = 50@stoptime = 2999-12-31 12:00:00.000@options = 2@e...
-
编辑 删除
trace build
CREATE proc trace_build @traceini nvarchar (245) = N'C:\ActivityTrace.ini' as declare @traceid int, @options int, @tracefile nvarchar (245), @maxfilesize bigint &nbs...
-
编辑 删除
Trace sp
CREATE proc trace @traceid int = 0, @setstatus int = -1 as declare @events table (eventid int, [event] varchar(31))declare @colu...
-
编辑 删除
getwebdbname
CREATE function fn_GetWebDBName (@GroupName varchar(50))returns varchar(50)as/* Created by Darrell 03/09/2009 */BEGIN DECLARE @dbname varchar(50) set @dbname=''  ...
-
编辑 删除
mssql getfilesize
Create function fn_GetFileSizeBytes (@filename varchar(1000))returns bigintasBEGIN DECLARE @objFSys int DECLARE @Result int DECLARE @objFile int DECLARE @Size bigint set @Si...
-
编辑 删除
你要的
USE [OTS]GO/****** Object: StoredProcedure [dbo].[OTS_RebuildIndex] Script. Date: 05/10/2011 19:00:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo]...
