Wednesday, January 11, 2006

Moving a Database Diagram in SQL Server 2000

INSERT DESTINATION..dtproperties
( objectid, property, value, uvalue, lvalue, version )

SELECT objectid, property, value, uvalue, lvalue, version
FROM SOURCE..dtproperties
WHERE objectid IN
( SELECT objectid
FROM SOURCE..dtproperties
WHERE property = 'DtgSchemaNAME'
)

No comments:

Post a Comment