Red Gate forums :: View topic - Issues with "Find invalid objects"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5 EAP
SQL Prompt 5 EAP forum

Issues with "Find invalid objects"

Search in SQL Prompt 5 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Tue Nov 16, 2010 11:48 am    Post subject: Issues with "Find invalid objects" Reply with quote

Hi,

though this feature is very useful - in fact, I am wondering why it is not generically implemented in SSMS - I found two issues:

* Temporary tables referenced e.g. in procedures are shown as a reference to an invalid object. Since it will be created at run time during procedure execution this information is trivial in general and considered to be a false positive.

* "Sometimes" a refresh or even closing search window and re-searching for invalid objects within the same database seems to stall and invalid objects are not shown. After minutes of searching, I canceled it, but it did not recover on subsequent runs. Restarting SSMS always helps (I m using SSMS 2008 R2 10.50.1746.0).
Unforunately, I am not able to reproduce this issue every time. Sometimes it is working as expected...
_________________
Regards, Klaus
Back to top
View user's profile Send private message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Tue Nov 16, 2010 11:52 am    Post subject: Reply with quote

Btw, I am using SQL Prompt EAR 5.0.0.591.
_________________
Regards, Klaus
Back to top
View user's profile Send private message
Luke Jefferson



Joined: 17 Sep 2010
Posts: 33

PostPosted: Tue Nov 16, 2010 3:19 pm    Post subject: Reply with quote

Hi Kondrich,

I'm glad you are finding the Find Invalid Objects feature useful. Unfortunately we were unable to get support for temporary tables in this release but we will look at including it in the future.

Quick question regarding your hanging SSMS: how large is the database that was presenting problems?

Thanks for your comments and feel free to email me directly with any further feedback, suggestions or ideas.

All the best,

Luke Jefferson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Tue Nov 16, 2010 3:35 pm    Post subject: Reply with quote

Hi Luke,

what size measure do you need? Data files size in GB, count of objects in the database?
I just run various tests on smaller databases and bigger ones (considering database size in GB and objects count), but I do not have a clear sight what the problem might by. I guess it's not the size in GB but the object count. Perhaps it depends on how many procedures, functions, views (= objects with a source code) exist within the database.

Please let me know if there is any measure that I may count and report (e.g. from sys.objects).
_________________
Regards, Klaus
Back to top
View user's profile Send private message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Thu Nov 25, 2010 5:30 pm    Post subject: Reply with quote

Finding invalid objects is working much better in 5.0.638 RC1. However, I get timeouts on certain databases (I think they occur on databases that contain much (stored procedure, function,...) code.
_________________
Regards, Klaus
Back to top
View user's profile Send private message
Luke Jefferson



Joined: 17 Sep 2010
Posts: 33

PostPosted: Thu Nov 25, 2010 6:06 pm    Post subject: Reply with quote

Hi Kondrich,

Thanks for downloading and trying the SQL Prompt 5 RC.

Could you please confirm what sort of connection you have between SSMS and your database--is internet or VPN involved?

Luke
Back to top
View user's profile Send private message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Fri Nov 26, 2010 7:50 am    Post subject: Reply with quote

Hi Luke,

the connection to all monitored servers is within our LAN, no internet, no VPN.
_________________
Regards, Klaus
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group