Sql Server
保温杯有枸杞
这个作者很懒,什么都没留下…
展开
-
查看sqlserver被锁的表以及如何解锁
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableNamefrom sys.dm_tran_locks where resource_type='OBJECT'解锁:declare @spid intSet @spid = 66 --锁表进程declare @sql varchar(1000)set @sql='kill '+cast(@spid as varchar)exec(..原创 2020-11-13 10:01:48 · 242 阅读 · 0 评论 -
sqlserver sa 账户被锁定解决方法
alter login sa with password = 'kedauis@sy123'unlock, check_policy = off, check_expiration = off原创 2020-11-13 08:55:18 · 1640 阅读 · 0 评论 -
Sql Server索引介绍
Sql Server索引介绍转载 2020-03-06 20:56:24 · 113 阅读 · 0 评论 -
SqlServer发布与订阅
SqlServer发布与订阅说明:发布和订阅功能实现了两台局域网内的数据库服务器的数据自动同步。目录1. 准备工作......................................................................................................................................原创 2020-03-05 14:00:04 · 328 阅读 · 0 评论 -
SQL SERVER语句 增加字段,查主键,查看表空间大小,查有无主键
查主键create table #H(name varchar(50) not null,name_pk varchar(50) null,name_pk1 varchar(50) null )insert into #H exec sp_helpindex N'text1' insert into #H exec sp_he...原创 2019-12-24 11:24:24 · 335 阅读 · 0 评论 -
sql server重设配置分发
EXEC master.dbo.sp_serveroption @server=N'repl_distributor', @optname=N'dist', @optvalue=N'false'GOsp_droplinkedsrvlogin 'repl_distributor',nullgosp_dropserver 'repl_distributor'原创 2019-12-13 14:38:58 · 403 阅读 · 0 评论 -
sql server 开启cdc 、判断是否开启cdc,修改cdc时间
第一步:开启CDC服务EXECUTE sys.sp_cdc_enable_dbselect name,case when is_tracked_by_cdc='1' then '成功' else '失败' END AS is_tracked_by_cdc_NAME,is_tracked_by_cdc,*from sys.tables swhere name like '%BH...原创 2020-03-05 13:52:46 · 1493 阅读 · 0 评论