Viewing 2 posts - 496 through 498 (of 498 total)
Greg, try using the following...
DECLARE @ObjectID int
-- Get the objectid's of the diagrams
select @ObjectID = isnull(objectid,0) from <put DBName Here>..dtproperties where property = 'DtgSchemaNAME'
-- Add them to the new table...
insert...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 12, 2002 at 5:59 pm
Like Greg I've been bitten by having my account set to a db other than master. I had a problem with a restore of my database and had the server...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 9, 2002 at 12:52 pm
Viewing 2 posts - 496 through 498 (of 498 total)