SQL Sentry will only "reveal" itself on SSMS when you have done a explain plan and have the window with it visible.

at that point right-click on it and  you have...

see this example - with it you should be able to set  your ssis to work with the rowversion value

/*
if object_id('test') is not null
drop table test
create table...

• This reply was modified 5 years ago by frederico_fonseca.

with the caveat that if using the latest version of SSMS you loose the Debug capability

you can use SQL Sentry (https://www.sentryone.com/plan-explorer to post a anonymized plan - that will keep your restrictions in place as all names / variable contents are replaced with identical names....

with newer technology it is possible on the SAN side - look for example at Dell XtremeIO - its snapshot technology means you can just click the button and you...

• This reply was modified 5 years ago by frederico_fonseca.

without having both procs there's nothing I can do - it may be a slight error on your SprocA that causes the table not to be populated

you need to install the EXACT SSDT version I mention above - download it and install onto a new VS 2017 instance - it will do a Shell install which...

depending on your VS version it may not show up at all - VS2019 for example will use a different driver (replacement from Microsoft of the Attunity one )

To use...

I would note that if the purpose of this query is just to output to a file for consumption by other system then using a different method would probably be...

you can create a unique filtered index on that column - it will prevent inserting more than 1 row with it set to true.

Thanks. Actually I have a JSON querying which is taking longer time for half million rows take approx. 15 mins to finish. However using query hints it runs faster....

Frederico .... maybe you're onto something.

Your query has multiple references to ftbid01 which obviously should be to 01, 02, 03, ...

The outer apply could be a cross apply, or...

if I got it correctly the dynamic requirement is that its not the content of the field that is being updated but rather that the field it is being used...

• This reply was modified 5 years ago by frederico_fonseca.

Okay, I felt this would be more efficient  and extensible ti done in SQL server, and I guess I thought it would be easier, but thanks I will do...

• This reply was modified 5 years ago by frederico_fonseca.

in SSMS you need to use xp_cmdshell.

but on your original post you stated that this is to be executed from a vb.net program - that being the case the correct...