Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hadoft
Starting Member
20 Posts |
 Posted - 2003-10-27 : 02:55:42
|
| I had generated a script for my views through EMBut when I had executed this script in QA, multiple errors issued Then I found out that the order of the views in the script doesn’t conceder its dependencySo I had to reorder the views script to make it runWhy that happened?Is there any way to avoid it?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-27 : 07:54:46
|
| There is a checkbox in EM to "script dependent objects" which will put them in the proper order. |
 |
|
|
hadoft
Starting Member
20 Posts |
Posted - 2003-10-27 : 08:31:10
|
quote:
Originally posted by robvolk
There is a checkbox in EM to "script dependent objects" which will put them in the proper order.
thanks for the replayI had tried this option but it didn't solve the problemit seems like - but not very sure- that the last view I made a modification to it will be scripted at the endWithout considering any dependenciesThe problem is that all views are scripted but not in the right orderAny help please? |
|
|
|
hadoft
Starting Member
20 Posts |
Posted - 2003-10-27 : 09:38:48
|
| I had found a clueWhen I opened the dependencies node of the view in QA It doesn’t list all views that this view depends on itWhy may that happen? But when I make a dummy update to this odd view then it will list its parent views (dependencies) correctlyAny one can help?Because I have a lot of views and checking every one and making dummy update will take a long timeThe main question, why the view doesn’t see its dependencies correctly in the first place. |
|
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2003-10-27 : 09:41:04
|
| Oh, I thought dependant objects were created anyhow and a warning from sysdepends...Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
|
|
|
|
views scripting problem