*we are self-hosted*
Is there a query I can run in SSMS to find the version we are on? I feel like I am aware that something like that exist - I just can't remember the details. FYI I am aware that I can got to the help menu in the client but right now the (Sandbox) client is crashing on me before I can event get that far. I want to query the database to see what version we have that client on.
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Hi Ashley!
You can query the [T_UPGRADE_SCRIPT_LOG] System Table. You can also find [T_UPGRADE_SCRIPT_LOG] in GoTo > System Tables within the client. The easiest way, by far, though is -- if you have the client handy -- head over to the Help menu > About Tessitura.
Good luck!
DGomez
Thanks! Before I saw your reply I found this:
select dbo.FS_CURRENT_VERSION().
^^ it works too!
Thanks again!
Ashley