Sql server stores failure time and request not time, why?

Question

I have a stored proc on sql 2008 server that excludes an int parameter. It calls other stored procs and has subqueries.

The problem I am facing is when I run the procedure from the SQL server management studio, which is not executing and not executing.

If I run the queries on the side of the saved process separately in another SQL server management studio, it just does all the fines.

I can not debug the problem. would appreciate any help / pointers to dig this depth.

(I use the same credentials when executing a proc or request)

Thanks in advance.

Answer 1

sniffing.

sproc sproc.

.

CREATE PROCEDURE [TestSproc]
    @Param1 INTEGER
AS
BEGIN
DECLARE @Param1_LOCAL INTEGER
SET @Param1_LOCAL = @Param1

SELECT Something
FROM Somewhere
WHERE SomeField = @Param1_LOCAL 
END