I had some issues with my stage environment cloud today.. i want to restore UAT(DEVELOPER) database from SANDBOX, i got some error below
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
*** Error importing database:Could not import package.
Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure AXPerf_UpdateStats, Line 1 Invalid column name 'has_persisted_sample'.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE AXPerf_UpdateStats
@ExecuteStats BIT=1
AS
BEGIN
DECLARE @spVersion AS NVARCHAR (30) = 'AXPerf_UpdateStats v2';
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#stats_needs_update') IS NOT NULL
DROP TABLE #stats_needs_update;
IF OBJECT_ID(N'tempdb..#StatsData') IS NOT NULL
DROP TABLE #StatsData;
IF OBJECT_ID(N'tempdb..#DisabledStats') IS NOT NULL
DROP TABLE #DisabledStats;
DECLARE @running_count AS BIGINT, @running_count_total AS BIGINT;
SET @running_count = 0;
SET @running_count_total = 200000000;
SELECT s.Name AS StatOrIndexName,
s.stats_id,
s.auto_created,
s.is_temporary,
o.object_id,
o.schema_id,
o.name AS TableName,
o.type,
sp.rows AS RowCnt,
sp.rows_sampled,
sp.modification_counter AS ModCtr,
s.has_persisted_sample,
isnull(sp.persisted_sample_percent, 0) AS persisted_sample_percent
Does anyone know this one?
