It is regarding this issuse: https://www.sqlservercentral.com/forums/topic/sys-object that i would like to drop Production and restore QA in it's place.

The DB schemas are the same. Production just stopped updating...

Here is the complete code from Mysql that i am trying to convert/change to TSQL:

App Filter Categories
select a.label as ‘App Category’
, b.label as ‘Menu’
, c.product_uid as ‘Product...

Please check my  Logic?

Please check my logig and advise?

I copied the view, using Import/Export Wizard.

As you can see a view is copied, but it is created as a Table. I dleted this...

• This reply was modified 2 years, 4 months ago by  yrstruly.

When i copied the View from QA. i placed it as n Table in Production. I tried to create the view with the DDL from QA, but it resorts to...

• This reply was modified 2 years, 4 months ago by  yrstruly.

Thank you. The culprit is "vw_UsageReportCached" or so it seems. I deleted vw_UsageReportCached from Production and imported the same view into Production from QA and it worked.

Im curious, since the...

This is the change i found in two tables. I changed it to QA and still no data:

QA

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[auditLevyBreakdown] (
[Id]...

• This reply was modified 2 years, 4 months ago by  yrstruly.
• This reply was modified 2 years, 4 months ago by  yrstruly.
• This reply was modified 2 years, 4 months ago by  yrstruly.

I am using the following code to view if data is showing:

Its from the QA and Production db's. I checked to what function/procedure is linked to the...

• This reply was modified 2 years, 4 months ago by  yrstruly.

Do i need to chech any other functions than Table Value and Scalar value functions?

Do i need check System Stored procedures too?

An update ran and it is giving output now that were previously blank, accept for Value. Any idea's?

I copied the table and it still does not give me any data back using

SELECT * FROM [dbo].[fn_GetSummaryReport] (

'2022-06-28','2022-07-28')

In Production.

Or just copy auditLevyBreakdown from QA to Production, like you said?

I dont see any procedure in QA that does this "INSERT INTO dbo.auditLevyBreakdown VALUES

(row one data),

(row two data)"