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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2006-09-20 : 13:44:10
|
| My boss is offsite, he called and said he's creating a view that uses linked servers, and Query Analyzer is saying the view is created successfully, but then it disappears. He can't use it, and he can't find it in sysobjects. He's double-checked and he's running the CREATE statement in the correct db. Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 13:47:07
|
| Your boss is definitely doing something wrong. Please post his code.Tara Kizer |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2006-09-20 : 13:51:53
|
| I will if and when I can, he's in a meeting all day. Could it be a permissions thing that isn't returning an error like it should? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 13:55:16
|
| It would return an error if the view could not be created, regardless of the cause.Tara Kizer |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2006-09-20 : 14:42:40
|
| Some stupid service was killing the view. Thanks anyway Tara. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 14:47:18
|
| That doesn't sound right, but glad you worked it out.Tara Kizer |
|
|
|
|
|
|
linked server view disappears