Thank you so much for all the...

I'm sure this isn't helping either

REPLACE(REPLACE(fm.DestTable, 'Holding_', ''), 'HoldingTable_', '')

and this

AND

(

LTRIM(RTRIM(ISNULL(CAST(im.NewValue AS VARCHAR(MAX)), ''))) <> ''

AND im.NewValue IS NOT NULL

)

Have you tried creating/populating temp tables and then running smaller...

• This reply was modified 4 years, 5 months ago by  Feivel.

Okay thanks I'll follow this guideline going forward. Could you...

You have an OUTER APPLY (aliased c2) in the query but in the WHERE clause of the main query you have

AND D.LiveTable = c2.TableName

So why is it an OUTER...

• This reply was modified 4 years, 5 months ago by  Feivel.
• This reply was modified 4 years, 5 months ago by  Feivel.
• This reply was modified 4 years, 5 months ago by  Feivel.

Awesome but is there a way to instead get the listener name rather than the IP address or maybe convert that to give me the name instead of the IP.

I was expecting that as an answer. Never mind, and thanks for taking the pains to even bother responding to the post. God bless you.

Hey Jeff,

I am only looking for a general pros/cons list that I can forward it to the developer.

Thanks! Sue but no problem with...

Okay, just FYI you may also run into some permissions issues if the service accounts for your dev environment (hopefully aren't) the same as the service accounts for your...

What I did in this situation is I created a powershell script to grab the latest backup from the prod share and copy it to the location and then...

Another question that comes to my mind is the table structure is as below. I am not sure why would it end up having negative values if the identity range...

No there's nothing inherently wrong with negative values in a primary key.

If you wanted to find any you could run a query that would give you a list of...

it may be possible to find it using sys.dm_db_stats_histogram:

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-stats-histogram-transact-sql?view=sql-server-2016

You could use a query such as:

SELECT OBJECT_SCHEMA_NAME(ss.object_id) AS schema_name, ao.name AS table_name, ac.name AS column_name,
 ...

My client has requested me to firstly let them know if a negative generated value in the primary...

You can try playing with something like the following to grab jobs that were successful and just look at the duration of the job (instead of each job step):