Linked Server and Constraints SQL 2005

Question

Does anyone know if you can drop a constraint on a table via a linked server in SQL 2005

score 1 · Answer 1 · edited May 23 '17 at 10:27

1

Can you have a Foreign Key onto a View of a Linked Server table in SQLServer 2k5?

I would say you can not.

edited May 23 '17 at 10:27

Community

1
1

answered Feb 02 '09 at 20:56

Glennular

17,827
9
58
77

score 1 · Answer 2 · answered Feb 04 '09 at 02:27

1

You can, but you have to use some dynamic SQL trickery to make it happen.

declare @cmd VARCHAR(4000)
SET @cmd = 'Use YourDatabase
ALTER TABLE YourTable
DROP CONSTRAINT YourConstraint'

exec YourServer.master.dbo.sp_executesql @SQL

answered Feb 04 '09 at 02:27

mrdenny

4,990
2
21
28

Very late but this is genious, Finally found what I needed – Jorge Guzman Jun 04 '12 at 19:20

Linked Server and Constraints SQL 2005

2 Answers2