Re: Dependencies are lost when alter an object
From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/24/04
- Next message: Tom Moreau: "Re: Slow performance after restarting"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: grant permission question"
- In reply to: Catalin: "Dependencies are lost when alter an object"
- Next in thread: Catalin: "Re: Dependencies are lost when alter an object"
- Reply: Catalin: "Re: Dependencies are lost when alter an object"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 16:52:24 -0500
DROP and CREATE, instead of ALTER?
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Catalin" <anonymous@discussions.microsoft.com> wrote in message news:2042C4B2-3C76-4A4A-B03D-DCE6FDE78CD6@microsoft.com... > Hello, > I have an old problem but now it became ugly... > I have an object (for example a function) that is used in some views. If I > am looking on dependencies, it shows me the 8 views whcih depends on it. > But if I edit the function in Query Analyser and run the script (no > modification on the script), it deletes all the dependencies for the 8 > views on it... The problem is worst because when I generate the initial > snapshot for a merge replication, it will affect the generation order of > the scripts and I get error when trying to create the views (on > subscriber), saying that the function doesn't exist in database... > Any ideea how can I preserve the dependencies? > Thanks in advance >
- Next message: Tom Moreau: "Re: Slow performance after restarting"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: grant permission question"
- In reply to: Catalin: "Dependencies are lost when alter an object"
- Next in thread: Catalin: "Re: Dependencies are lost when alter an object"
- Reply: Catalin: "Re: Dependencies are lost when alter an object"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
