After copying data from prod to test, usually site name also need to be changed. Following is the script. DECLARE @Severity int, @POldSite [dbo].[SiteType], @PNewSite [dbo].[SiteType], @RegenerateRowPointers [dbo].[ListYesNoType], @Infobar [dbo].[InfobarType], @Site [dbo].[SiteType] — Change XYZ to the name of your current Site IdSET @Site = ‘SITE-P’ EXECUTE @Severity = [dbo].[SetSiteSp] […]
