Post reply

Error Running The Ultimate Connection Summarizer and Trouble Finder

  • September 22, 2008 at 9:07 am

    #212914

    I wanted to install the http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/[/url] as it looks like the type of script that will help me a lot. But it fails during the creation of the procedure with the following

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 60

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 61

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 116

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 117

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 179

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure Util_ConnectionSummary, Line 180

    Invalid column name 'writes'.

    I've navigated to the view it is looking for and can see the column it is complaining about.

    I'm using SQL 2005 sp2 (9.00.3068.00) Developer edition

    I know I could have posted in the thread for that script, but as nobody else has yet posted I didn't want to make the first post a dumb noob mistake which this is bound to be.

    Bryan

  • September 26, 2008 at 7:37 am

    #877683

    It was case sensitivity issue, changing the script to Reads and Writes instead of reads and writes where it was complaining about the view names allowed me to run it sucessfully.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply