USE tempdb
GO
CREATE SCHEMA Test
GO
CREATE TABLE [Test].[User] (
	[UserID]	Int			CONSTRAINT [PK_User] PRIMARY KEY
,	[FirstName]	NVarChar(256)	NOT NULL
,	[LastName]	NVarChar(256)	NOT NULL
,	[EyeСolor]	NVarChar(32)	NOT NULL
)
GO
CREATE PROCEDURE [Test].[spUserCreate]
	@UserID		Int	= NULL OUT
,	@FirstName	NVarChar(256)
,	@LastName	NVarChar(256)
,	@EyeColor	NVarChar(32)
AS BEGIN
	INSERT	Test.[User]	( FirstName, LastName, EyeСolor)
	VALUES			(@FirstName,@LastName,@EyeColor)
	SET @UserID = Scope_Identity()
END
GO
CREATE PROCEDURE [Test].[spUserModify]
	@UserID		Int
,	@FirstName	NVarChar(256)
,	@LastName	NVarChar(256)
,	@EyeColor	NVarChar(32)
AS BEGIN
	UPDATE	T
	SET	FirstName 	= @FirstName
	,	LastName 	= @LastName
	,	EyeСolor 	= @EyeColor
	FROM	Test.[User]	T
	WHERE	T.UserID = @UserID
	IF (@@RowCount != 1) RAISERROR(23100,16,2);
END
GO
/*
DROP PROC Test.spUserModify,Test.spUserCreate;
DROP TABLE Test.[User];
DROP SCHEMA Test;
*/

8:25:14 AM: Creating log...
8:25:14 AM: Init 1
8:25:14 AM: Init 2
8:25:14 AM: Init 3
8:25:14 AM: Init 4
8:25:14 AM: Init 5
8:25:15 AM: Init 6
8:25:15 AM: Init method out...
8:25:15 AM: Start loggin in SSMS2012...
8:25:37 AM: OnConnection 2
8:25:37 AM: 2012 SetObjectExplorerEventProvider 1==============
8:25:37 AM: Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService
8:25:37 AM: Provider_SelectionChanged
8:25:37 AM: 2012 SetObjectExplorerEventProvider 2==============
8:25:37 AM: 2012 SetObjectExplorerEventProvider (Before use OE)
8:25:37 AM: 2012 SetObjectExplorerEventProvider 3
8:25:37 AM: 2012 SetObjectExplorerEventProvider 4
8:25:37 AM: 2012 SetObjectExplorerEventProvider 5
8:25:37 AM: 2012 SetObjectExplorerEventProvider 6
8:25:37 AM: 2012 SetObjectExplorerEventProvider 7
8:25:37 AM: OnConnection 3
8:25:37 AM: Start creating menu
8:25:37 AM: Error on try set ShortCut on command SQLRefactorStudio.Connect.Rename: System.ArgumentException: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
   at EnvDTE.Command.set_Bindings(Object pVar)
   at SQLRefactorStudio.Classes.BaseConnect.CreateCommand(CommandBarPopup toolsPopup, CommandInfo info, Boolean beginGroup, Boolean visible)
8:25:37 AM: End creating menu