Red Gate forums :: View topic - Invalid Objects missing stored proc
Return to www.red-gate.com RSS Feed Available

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

Invalid Objects missing stored proc

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
danfountain



Joined: 25 Jun 2012
Posts: 7

PostPosted: Wed Oct 24, 2012 9:41 am    Post subject: Invalid Objects missing stored proc Reply with quote

Hi,

I am using invalid objects finder at the moment very heavily.

However there is a proc which will not execute however - its not appearing on the list.

It fails to execute due to invalid columns.

Any advice greatly recieved.

Dan
Back to top
View user's profile Send private message
danfountain



Joined: 25 Jun 2012
Posts: 7

PostPosted: Wed Oct 24, 2012 9:50 am    Post subject: Reply with quote

If it helps here are the only errors i am getting on SQLPrompt

24 Oct 2012 08:48:20,705 [1] WARN RedGate.SQLPrompt.CommonVS.ToolWindows - Could not set window state for tab SQL Prompt - Invalid Objects

System.ArgumentException: Value does not fall within the expected range.

at EnvDTE80.Window2.set_WindowState(vsWindowState plWindowState)

at RedGate.SQLPrompt.CommonVS.ToolWindows.ToolWindow`1.GetOrCreateWindow()
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Thu Oct 25, 2012 6:23 pm    Post subject: Reply with quote

Would it be possible for you to send us the create script for the object in question?

Please send it to support@red-gate.com and quote the support ticket number F0066076 in the subject line
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
danfountain



Joined: 25 Jun 2012
Posts: 7

PostPosted: Tue Nov 13, 2012 11:17 am    Post subject: Reply with quote

Hi,

I have sent in an email for this issue.

Many thanks

Dan
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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