• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 12 views
  • Users 0 members are here
Related

Stored Procedure updates only for 9.0.0.0 and 9.0.0.2

David Crowell
$organization

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.

 

  • Former Member
    Former Member $organization
    David, you can download the database update scripts for the v9.0.0.0 General Release and the v9.0.0.2 patch from TASK using your personalized helpdesk login.  These are both in the Version Upgrades and Patches project - the General Release is Solution #21 and the v9.0.0.2 post release patch is Solution #25.  If you have any questions please feel free to contact me directly at bbell@tessituranetwork.com.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Crowell
    Sent: Wednesday, October 21, 2009 5:17 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] 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!
  • $organization in reply to Former Member

    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.