ITPub博客

USE [master] GO /****** Object:  StoredProcedure [dbo].[sp_hexadecimal]    Script Date: 2018/8/9 10:48:17 ******/ SET ANSI_NU

本文所涉及的内容（Contents）背景（Contexts）基础知识（Rudimentary Knowledge）查看默认跟踪信息（Default Trace）补充说明（Addon）参考文献（References）　　思考这样的场景：数据库的表、存储过程经常别修改，当这些修改造成BUG的时候，很多开发都不承认是他们干的，...

1.查询某个表被哪些存储过程（以下简称 SP）使用到 : select distinct object_name(id) from syscomments where id in (select object_id from sys.objects where type ='P') and text like'%TableName%' 2.查找那些过程对该表做了更新操作： select distinct object_name(id) from sys...

点击(此处)折叠或打开select 'ALTER INDEX ['+ind.name+'] ON [dbo].['+OBJECT_NAME(ind.OBJECT_ID)+'] REBUILD', OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS...

公司需要导入数据到MSSQLSERVER，但是对方给出的奇葩cvs文件是这样的:aa,bb,cc,dd,ee1,"this is a",1,"this is a",12,"this is" a",2,"this is a",2普通的bcp处理会有悲催的错位，而且mssql个坑货也不能像mysql自动区分文本限定符的"研究了一下，用这个方式处理：1. 在DB里建立对应的表点击(此处...

点击(此处)折叠或打开select a.name as 表名,max(b.rows) as 记录条数 from sysobjects a ,sysindexes b   where a.id=b.id and a.xtype='u' group by a.name order by max(b.rows) desc...

select  a.name as tabname       ,h.name as idname    ,rr.row_num as rownumfrom  sys.objects    as  a right join sys.indexes  as h         on  a.object_id=h.object_idjoin ( select   a.n...

保存数据的表create table dc_DiskDetaill ( Drive varchar(10), Size  varchar(50), FreeSize varchar(50), GetTime  datetime default(getdate()))  采集的存储过程SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===========================...

如何更改SQL SERVER 2000的排序规则Alter datebase Alter datebase 数据库 Chinese_PRC_BIN   ALTER TABLE tb  ALTER COLUMN colname nvarchar(100) COLLATE Chinese_PRC_CI_AS  --不区分大小写 &n...

ALTER AVAILABILITY GROUP shdmag05modify replica on 'SH-DM-DB05'with( ENDPOINT_URL ='TCP://192.168.100.91:5022' )

SET NOCOUNT ONEXEC msdb.sys.sp_dbmmonitorupdate DECLARE @Cursor_MirroredDatabases CURSORDECLARE @command CHAR(256)DECLARE @MirroredDatabaseName NVARCHAR(128)DECLARE @MirrorStats TABLE(database_name SYSNAME , -- Name of databaserole TINYINT , -- 1 = Principal, 2 = Mirrormirroring_state TINYI...

SELECT  top 10    QS.creation_time '编译计划的时间'      , QS.last_execution_time '上次执行计划的时间'      , QS.execution_count '执行的次数'   &nb...

USE [master]GOCREATE LOGIN <user name> WITH PASSWORD=,DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON USE [master]GO--查询视图grant view server state to <user name>GO USE [datayesdb]GOCREATE USER <user name> FOR LOGIN <user name> WITH DEFAULT_SCHEMA=[dbo]G...

 with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2008/sqlaudit_data') SELECT top 5 CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset, event_time),DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS '触发审核的日期和时间' ,--b.connect_time,        s...

点击(此处)折叠或打开SELECT 主键列ID=b.rkey     ,主键表名称=object_name(b.rkeyid)     ,主键列名=(SELECT name FROM syscolumns WHERE colid=b.rkey AND id=b.rkeyid)     ,外键表...

点击(此处)折叠或打开grant create table to jirasysgrant execute on schema::dbo to jirasysuse [datayesdb]GO--GRANT INSERT ON SCHEMA::[dbo] TO [jirasys]--GOuse [datayesdb]...

Now, it will not be possible to logon to the database using SQL Server Management Studio. The only way to fix this problem is using DAC. Read more details about DAC  Using a Dedicated Administrator Connection to Kill Currently Running Query. Now let us take a look at the example in our ...

http://whoisactive.com/docs/01_background/

在stg尝试重现案例 修改datayesdb的CDC的配置值use dyedbgo EXEC sys.sp_cdc_stop_job @job_type = 'capture'EXEC sp_cdc_change_job @job_type='capture', @maxtrans = 50, @maxscans = 1, @continuous = 1, @pollinginterval = 5EXEC sys.sp_cdc_start_job @job_type = 'cap...