Invalid Objects missing stored proc

danfountaindanfountain Posts: 12
edited November 13, 2012 5:17AM in SQL Prompt Previous Versions
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
· Share on Twitter

Comments

  • danfountaindanfountain Posts: 12
    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()
    · Share on Twitter
  • chriskellychriskelly Posts: 378
    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
    · Share on Twitter
  • danfountaindanfountain Posts: 12
    Hi,

    I have sent in an email for this issue.

    Many thanks

    Dan
    · Share on Twitter
Sign In or Register to comment.