What are the challenges you face when working across database platforms? Take the survey

Invalid Objects missing stored proc

danfountaindanfountain Posts: 12
edited November 13, 2012 5:17AM in SQL Prompt Previous Versions

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.



  • Options
    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()
  • Options
    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
  • Options

    I have sent in an email for this issue.

    Many thanks

Sign In or Register to comment.