To answer my own question, I found the database was not attached to SQL Server Management Studio. I attached the database.mdf file from the APP_DATA directory, was able to find the appropriate stored procedure, modify it in the modify pane and save it as a .sql file.

Next question is how do I either modify in place and resave or import the saved .sql file back.

Regards,

Gary

I am just now seeing this post. You seemed to have your own turn around time of 3 hours ;)

 

---

Chris Paterra

Get direct answers to your questions in the Community Exchange.

i looked at it once again and the problem is bigger than it seems (and I'm sorry about previous post) .... I omited that it is beeing grouped also by creation date, which of course changes situation a lot ...  havent got time and will to think over the solution ...
I wanna just notice then ordering it by threadid isn't also solution to the problem, becouse it next section of that stored procedure, where are selected items for one page, ordering among posts is done according to CreatedDate .. and so it leads to situation, where in first step are threads assigned on which page they will be shown according to threadID and then on specific page are ordered according to date of last post.