Comments
Sort by recent activity
Detaching did let the tool find the views that still had broken references. [image] Triggers seem to always be excluded, though. / comments
Detaching did let the tool find the views that still had broken references. Triggers seem to always be excluded, though.
Hi Michael. Thanks for the reply. We're trying to take two databases that have both lived on the same server and instance, and move one database to a different server/instance (one will stay on-prem and the other is simulating an offsite server/instance). Both databases have objects from the other referenced in views, sprocs, functions and triggers. Find Invalid Objects has been pretty good at finding the broken references, but some objects with broken references (triggers, views) aren't showing up in the results.
The triggers (and other objects) are nothing special, and the move to linked servers and accessing objects across linked servers shouldn't really be a factor here. My goal is to use Find Invalid Objects to find all the places where I need to update the object reference to the four part fully qualified name. When DatabaseA.dbo.TriggerA references DatabaseB.dbo.TableB, and DatabaseB has moved to a different server/instance, TriggerA should be found by the invalid objects tool, because DatabaseB.dbo.TableB no longer exists without the fourth part of the fully qualified name (the server/instance), right?
A caveat...I left DatabaseB on the same server but took it offline in SSMS. Could that be why some object are not being shown as invalid, because the database exists in its original location, and offline isn't enough to let the tool "not find" the referenced objects? I can try detaching DatabaseB and give it a shot.
Thanks for your help. [image] / comments
Hi Michael. Thanks for the reply. We're trying to take two databases that have both lived on the same server and instance, and move one database to a different server/instance (one will stay on-p...
I went ahead and used the online "request more activations" tool, and it worked great...fast and easy. Thanks, Redgate! [image] / comments
I went ahead and used the online "request more activations" tool, and it worked great...fast and easy. Thanks, Redgate!
That was it...the built-in Intellisense...I disabled it. Thank you very much for your help. [image] / comments
That was it...the built-in Intellisense...I disabled it. Thank you very much for your help.
Yeah...we're having trouble receiving external emails. Thanks for replying. [image]
1. 6.5.0.330
2. SSMS 2008 (not R2)
3. I have the free version of dbForge SQL Complete installed, prior to SQL Prompt. I disabled SQL Complete in its Options when I started evaluating SQL Prompt, but it's still installed. I just installed CodePlex ExpressProfiler and Supratimas today.
Thanks! / comments
Yeah...we're having trouble receiving external emails. Thanks for replying.
1. 6.5.0.330
2. SSMS 2008 (not R2)
3. I have the free version of dbForge SQL Complete installed, prior to SQL Prompt. ...
Hi Aaron. Were you able to reproduce this issue? I emailed the screenshots last week.
Thanks! / comments
Hi Aaron. Were you able to reproduce this issue? I emailed the screenshots last week.
Thanks!