> Как деактивизировать все связи в базе?
вот такая сп :
1й параметр - имя таблицы.
2й - 1=включить, 0=выключить
все referential constraints для
данной таблицы.
3й - если 0=сообщать о проделанной работе


CREATE PROCEDURE sp_CheckAllFK(
@TableName sysname,
@Check bit = 1,
@NoMsgs bit = 1)
AS

set NOCOUNT on

declare @TABLE_OWNER sysname, @TABLE_NAME sysname, @COLUMN_NAME sysname,
@NAME sysname, @text varchar(2000)

create table #fkeys(
PKTABLE_QUALIFIER sysname,
PKTABLE_OWNER sysname,
PKTABLE_NAME sysname,
PKCOLUMN_NAME sysname,
FKTABLE_QUALIFIER sysname,
FKTABLE_OWNER sysname,
FKTABLE_NAME sysname,
FKCOLUMN_NAME sysname,
KEY_SEQ sysname,
UPDATE_RULE sysname,
DELETE_RULE sysname,
FK_NAME sysname,
PK_NAME sysname,
DEFERRABILITY sysname
)

INSERT #fkeys exec sp_fkeys @TableName

if (@@ROWCOUNT = 0) RETURN

DECLARE fks scroll cursor for select
FKTABLE_OWNER,
FKTABLE_NAME ,
FKCOLUMN_NAME,
FK_NAME
from #fkeys

OPEN fks
FETCH next from fks into @TABLE_OWNER , @TABLE_NAME , @COLUMN_NAME, @NAME
WHILE (@@FETCH_STATUS >=0)
BEGIN
if @Check = 1
set @text='ALTER TABLE [' + rtrim(@TABLE_OWNER) + '].[' + rtrim(@TABLE_NAME) +'] CHECK CONSTRAINT [' + rtrim(@NAME) +']'
else
set @text='ALTER TABLE [' + rtrim(@TABLE_OWNER) + '].[' + rtrim(@TABLE_NAME) +'] NOCHECK CONSTRAINT [' + rtrim(@NAME) +']'
exec (@text)
if @NoMsgs=0
print 'Constraint '+rtrim(@NAME)+' changed'
FETCH next from fks into @TABLE_OWNER , @TABLE_NAME , @COLUMN_NAME, @NAME
END

CLOSE fks

DEALLOCATE fks

drop table #fkeys

GO