ms sql 2005, conversion failed for uniqueidentifier
i have the same trouble. 

Strored procedure is:

    USE [mytestdb]
    GO

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    ALTER PROCEDURE [dbo].[test_storedprocedure]
    	-- Add the parameters for the stored procedure here
    @MerchantID uniqueidentifier, 
    @CountMonth int out 
    
    AS
    BEGIN
And I call this procedure as

    USE [mytestdb]
    GO
    
    DECLARE	@return_value int,
    		@CountMonth int
    
    SELECT	@CountMonth = 0
    
    EXEC	@return_value = [dbo].[test_storedprocedure]
    		@MerchantID = '2C083422-A788-4343-A777-ACD406188F7D',
    		@CountMonth = @CountMonth OUTPUT
    
    SELECT	@CountMonth as N'@CountMonth'
    
    SELECT	'Return Value' = @return_value
    
    GO

and i have got the following error


> Msg 8169, Level 16, State 2, Procedure
> dlpws_StatByMerchant, Line 14
> Conversion failed when converting from
> a character string to
> uniqueidentifier.

can anybody help me with this?

PS: MS SQL 2005
ms sql 2005, conversion failed for uniqueidentifier
===

i have the same trouble. 

Strored procedure is:

    USE [mytestdb]
    GO

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    ALTER PROCEDURE [dbo].[test_storedprocedure]
    	-- Add the parameters for the stored procedure here
    @MerchantID uniqueidentifier, 
    @CountMonth int out 
    
    AS
    BEGIN
And I call this procedure as

    USE [mytestdb]
    GO
    
    DECLARE	@return_value int,
    		@CountMonth int
    
    SELECT	@CountMonth = 0
    
    EXEC	@return_value = [dbo].[test_storedprocedure]
    		@MerchantID = '2C083422-A788-4343-A777-ACD406188F7D',
    		@CountMonth = @CountMonth OUTPUT
    
    SELECT	@CountMonth as N'@CountMonth'
    
    SELECT	'Return Value' = @return_value
    
    GO

and i have got the following error


> Msg 8169, Level 16, State 2, Procedure
> dlpws_StatByMerchant, Line 14
> Conversion failed when converting from
> a character string to
> uniqueidentifier.

can anybody help me with this?

PS: MS SQL 2005