naradae

select [App ID], Name, Publisher
from [NAV App Installed App]

naradae

/*
Instructions:
- Replace CRONUSLIVE with your database name
- Replace 202112031200 with a current timestamp
- Replace the database file names and paths with the names from your database. Use SELECT * FROM sys.database_files to assist with this
- The snapshot must latest be deleted (with DROP DATABASE CRONUSLIVE_snapshot_202112031200), as it continues to be a drain on all transactions in the source database
*/

CREATE DATABASE CRONUSLIVE_snapshot_202112031200 ON (
	NAME = [CRONUSLIVE_Data]