Activity overview
Latest activity by BlueSkyDev
Hi Eddie,
Thanks for your response. Unfortunately I don't understand it!
If I select menu option (in SSMS 2014) "Script stored procedure as"/"CREATE TO"/"New Query Editor Window" from an s-p that I know is part of a group-named s-p I get the new window populated with the code for ALL the group-named s-p's in this group and going through that window I can show you each Create statement which I've copied here:
CREATE PROCEDURE [dbo].[stArrearsDeductions]
...s-p code...
CREATE PROCEDURE [dbo].[stArrearsDeductions];2
...s-p code...
CREATE PROCEDURE [dbo].[stArrearsDeductions];3
...s-p code...
CREATE PROCEDURE [dbo].[stArrearsDeductions];4
...s-p code...
This implies that SQL Server knows about this grouping and the association between the first and subsequent numbered s-p's.
However, the SSMS Modify option in 2014 doesn't return all these group-named s-p's and I only see the first (not-numbered) one. (Note that SSMS 2008 Modify option does return all the s-p's in the numbered group.)
So, the CREATE statement is in SQL Server with the semicolon - so if your search routine looks at that, I'd have thought it should be able to find the group-numbered s-p's? / comments
Hi Eddie,
Thanks for your response. Unfortunately I don't understand it!
If I select menu option (in SSMS 2014) "Script stored procedure as"/"CREATE TO"/"New Query Editor Window" from an s-p that I...
Searching for stored procedure groups
Hope someone can help.
I've come across a database that uses stored procedure groups (e.g. p_StoredProcName;2) that simulate .Net override functions. So there are n versions of the same s-p name ea...