Stored Procedure updates only for 9.0.0.0 and 9.0.0.2

Does anyone have the stored procedure script for the 9.0.0.0 and 9.0.0.2 updates?  I don't want the other parts, just the stored procedures.

Just a little background:  When I applied the updates my database was in SQL 2000 compatibility mode.  Some of the stored procedures did not update.  I have found one of them, and updated it after fixing the compatibility mode issue.

Due to some strange behavior I'm seeing with the web api, I think one (or more) didn't get updated.  (Updating profile leads to the address being marked as invalid).

I know I can't run the whole update script again without issue, so I just need the procedures.  Any help would be appreciated.

 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Bob,

Thanks for the reply.  The database update scripts update much more than the stored procedures.  I'm hoping for a script to update just the stored procedures.  I can (and probably will) wade through thousands of lines of SQL to find the correct updates, but I was hoping that the Network would already have such a thing.

 

Bob,

Thanks for the reply.  The database update scripts update much more than the stored procedures.  I'm hoping for a script to update just the stored procedures.  I can (and probably will) wade through thousands of lines of SQL to find the correct updates, but I was hoping that the Network would already have such a thing.