Activity overview
Latest activity by Philippe LEGRAND
--> Does this always happen to you ?
Yes, always.
--> Which version of Prompt are you using ?
SQL PRompt 6.4.0.659
--> Are you running this in SSMS or VS and which versions ?
Yes, I'm running SSMS, version 10.50.6000.34
--> Do you have any other addins installed ?
No
Remark :
I installed SQL 2014 these last days, the anomaly of the jump to end of line after suggestion inserted does not occur with SQL 2014, while it continues with SQL 2008R2. / comments
--> Does this always happen to you ?
Yes, always.
--> Which version of Prompt are you using ?
SQL PRompt 6.4.0.659
--> Are you running this in SSMS or VS and which versions ?
Yes, I'm running SSMS,...
jump to end of line when suggestion insertion
The cursor skips at the end of line after the insertion of a suggestion, instead of staying in the end of the insertion.
Is it a bad configuration of SQL Prompt from me ?
SQL Compare V11
The version SQL Compare V11 is nice, especially for the multi modules procedure.
It remain 13 days trial at september 16th
When do you release this version V11 ?
Regards
Of course :
Please, create 2 databases nammed DB_1 and DB_2
Create this store procédure on DB_1 and DB_2
GO
/****** Object: StoredProcedure [dbo].[Z_RG_CS_Test] Script Date: 10/14/2013 16:22:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[Z_RG_CS_Test] as
begin
print 'M1'
end
GO
/****** Object: NumberedStoredProcedure [dbo].[Z_RG_CS_Test];2 Script Date: 10/14/2013 16:22:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[Z_RG_CS_Test];2 as
begin
print 'M2'
end
GO
/****** Object: NumberedStoredProcedure [dbo].[Z_RG_CS_Test];3 Script Date: 10/14/2013 16:22:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[Z_RG_CS_Test];3 as
begin
print 'M3'
end
Then, compare structure on DB_1 and DB_2.
Refresh the comparaison more and more, without any change.
On my computer, after 4 or 5 refresh, a difference appear.
Regards, / comments
Of course :
Please, create 2 databases nammed DB_1 and DB_2
Create this store procédure on DB_1 and DB_2
GO
/****** Object: StoredProcedure [dbo].[Z_RG_CS_Test] Script Date: 10/14/2013 16:22:...
Compare 10.4.8.87 : bug store proc with multiple modules ?
This version 10.4.8.87 bug on store procedure with multiple modules.
Without any modification, each refresh show difference (module lacking) between the same procedure (exactly the same procedure i...