Activity overview
Latest activity by GurpreetGill
Azure Shadow DB not getting drop
Hi
I am using SQL Change Automation in
Visual Studio, Facing an issue, whenever i click on Refresh button ( for
refreshing list of database object changes pending import in SCA window ) a
sh...
sequence of script execution
Hi
I am using SQL Change Automation in
Visual Studio, Facing an issue with sequence of script execution.
Here is what i am doing
1) Add a Stored Procedure ( let’s
say addValue) in Source databas...
Ok Thanks Ivo / comments
Ok Thanks Ivo
Please help... / comments
Please help...
any help. / comments
any help.
Generate CREATE + ALTER Stored Procedure Script
HiBy default, SCA generated the Stored Procedure Script as DROP + CREATE IF OBJECT_ID('[dbo].[My_SP]') IS NOT NULLDROP PROCEDURE [dbo].[My_SP];GOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOCREATE...
Generate CREATE ALTER Procedure Script, not DROP CREATE
Hi,By default, when generating baseline script, all the Stored Procedures are scripted as DROP and CREATE<br><div>IF OBJECT_ID('[dbo].[My_SP]') IS NOT NULL</div><div> DROP PROCEDURE [dbo].[My_SP];<...
ok, Thanks wayOutwest. / comments
ok, Thanks wayOutwest.
Hi Any workaround to this problem. Thanks Gill / comments
Hi Any workaround to this problem.ThanksGill
Hi @Diogo Version "3.1.10.3430", worked. BUT, this is not good example, where you release latest version without proper simple testing. Hope for quick fix. Thanks Gill / comments
Hi @Diogo Version "3.1.10.3430", worked.BUT, this is not good example, where you release latest version without proper simple testing.Hope for quick fix.ThanksGill