Invalid Objects missing stored proc

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Invalid Objects missing stored proc

Postby danfountain » Wed Oct 24, 2012 9:41 am

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
danfountain
 
Posts: 8
Joined: Mon Jun 25, 2012 9:43 am

Postby danfountain » Wed Oct 24, 2012 9:50 am

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()
danfountain
 
Posts: 8
Joined: Mon Jun 25, 2012 9:43 am

Postby chriskelly » Thu Oct 25, 2012 6:23 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby danfountain » Tue Nov 13, 2012 11:17 am

Hi,

I have sent in an email for this issue.

Many thanks

Dan
danfountain
 
Posts: 8
Joined: Mon Jun 25, 2012 9:43 am


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests