August 22, 2001 at 1:55 am
Hi all
Just come accross a curlly one today on our DEV server. Basically had a analyst using the database digrammer (no changes made as yet, just viewing)... whilst he was looking around I added him to a role to ensure that he couldnt create/delete etc tables from the database and diagram. He then went ahead and altered a table and attempted to save. At this point it told him that he couldnt and of course complained bitterly .. anyhow, then i noticed that the FK's for the table had all disappeared!? (ie. dropped). Ive repeated a couple of times now. Anyone come accross the same problem (rare as it probably is) ?
Cheers
Chris
P.S Im not a jerk dba btw i forgot to apply the role whilst I ran some schema comparison checks and needed a solid base line to run against.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 22, 2001 at 4:53 pm
I have not seen this. But I dont use the feature that often, usually just when I need printed copy of the schema for a few tables to reference while Im working on something else. Have you looked through MSDN to see if any posted issues?
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy