Activity overview
Latest activity by opspark
Great script, thanks.
Re the hard-coded piece, this works:
DECLARE CFks CURSOR FOR
SELECT
[name] fk_name,
OBJECT_SCHEMA_NAME([parent_object_id]) + '.' + OBJECT_NAME([parent_object_id]) table_name
FROM
sys.foreign_keys fk
WHERE
is_not_trusted=1 / comments
Great script, thanks.
Re the hard-coded piece, this works:
DECLARE CFks CURSOR FOR
SELECT
[name] fk_name,
OBJECT_SCHEMA_NAME([parent_object_id]) + '.' + OBJECT_NAME([parent_object_id]) table_name
F...