stored proc basic question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

stored proc basic question

Author

Topic

limericklad1974
Starting Member

39 Posts

Posted - 2009-01-07 : 16:51:16

Hi,
I have a database table called Database Settings. It has two columns (Name and Value)

Another programmer has written a stored proc which is called pr_dal_DatabaseSettings_SelectOne

It is written as follows:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[pr_dal_DatabaseSettings_SelectOne]
@Name varchar(50),
@ErrorCode int OUTPUT
AS
SET NOCOUNT ON
SELECT
[Name],
[Value]
FROM [dbo].[DatabaseSettings]
WHERE
[Name] = @Name
SELECT @ErrorCode=@@ERROR

We have started to get crashes on our application and I am wondering if this stored proc is causing the problem.

In the Database Settings table, there are entries which are 53 characters. The stored proc limits to 50, is this an issue???

Many thanks for any advice!

Damien

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-07 : 16:56:48

Cross post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117379

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources