Differences

This shows you the differences between two versions of the page.

--- internal.dbsql:customerdbsql:sp.spccpvalidate [2024/03/07 10:20]
Radu Butarascu created
+++ internal.dbsql:customerdbsql:sp.spccpvalidate [2024/06/12 12:07] (current)
Radu Butarascu
@@ Line 15: / Line 15: @@
 -- =============================================
 -- Author:	www.allshore.us, Radu B.
--- Update date: 6/19/2012
+-- Update date: 6/19/2012 - update also handles GROUP logins
+--              6/12/2024 - cahnged GroupMembers from VARCHAR(255) to VARCHAR(MAX)
 -- Description:	Validates the User for Customer Control Panel
---		Latest update also handles GROUP logins
 -- =============================================
-CREATE PROCEDURE [dbo].[spCCPValidate]
+ALTER PROCEDURE [dbo].[spCCPValidate]
 (
 	-- Add the parameters for the stored procedure here
@@ Line 34: / Line 34: @@
 		LoginName VARCHAR(50),
 		LoginPassword VARCHAR(50),
-		GroupMembers VARCHAR(255)
+		GroupMembers VARCHAR(MAX)
 	)
@@ Line 96: / Line 96: @@
 		END
 	END