Activity overview
Latest activity by gsemel
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...
Find Invalid objects - not finding triggers
Hello. I'm trying to find invalid objects after moving DatabaseB to a different instance, where DatabaseB has triggers that reference DatabaseA. When A and B were on the same instance, these trig...
Transfer (deactivate/activate) license key without the UI?
Is there a way to script (cmd, powershell, reg files, etc.) the deactivation and activation of a license key? I'd like to temporarily deactivate SQL Backup on a production server and activate on a...
What's Redgate's sales pitch on VDI tools vs VSS tools?
We have licenses of SQL Backup for a few of our SQL Servers. I love the product and what it does for us. We changed MSPs, and the new MSP uses StorageCraft (ShadowProtect) agents on all our serve...
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!
Find which server is activated by which license serial numbe
My SQL Servers have gotten out of control. Is there any way to reconcile which servers are activated by which licenses/serial numbers? I can right-click on each server in the SQL Backup UI and d...
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!