Invalid object detection - multiple databases

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Invalid object detection - multiple databases

Postby bootieday » Tue Jun 10, 2014 9:15 pm

Is there any way possible to perform the "Find invalid objects" feature on multiple databases within a script?
bootieday
 
Posts: 11
Joined: Tue Aug 30, 2005 2:14 pm

Postby David Priddle » Wed Jun 11, 2014 10:50 am

Hi bootieday,

Unfortunately we don't have this functionality available in SQL Prompt at the moment.

In which situations would this be useful for you? It would be great if we could have a scenario to help understand your problem.

Best regards,

David
David Priddle
 
Posts: 36
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge

Postby bootieday » Fri Jun 13, 2014 7:53 pm

Our scenario is one in which we have hundreds of production databases of identical schema structure. It would be good to have a mechanism to collect this invalid object information periodically to help troubleshoot potential deployment issues in our environment.
bootieday
 
Posts: 11
Joined: Tue Aug 30, 2005 2:14 pm

Postby David Priddle » Tue Jun 17, 2014 11:57 am

Hi bootieday,

I've just noticed there is an existing feature request for SQL Prompt to have Find Invalid Objects work globally. Would this solve your problem?

Best regards,

David
David Priddle
 
Posts: 36
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest