How to reset Pivotal License Info

By judam

You need to run this script to totally reset all the license information from your Pivotal BM or ED.

use <your_bm_or_ed>
go

update users set lkey = null

update rsys_system_flags
set rn_value = null
where rn_flag like 'plm%'

update rsys_system_flags
set rn_value = NEWID()
where rn_flag = 'MasterSourceDatabaseId'

update rsys_system_flags
set rn_value = NEWID()
where rn_flag = 'DatabaseId'

Leave a Reply