MSSQL Stored procedure failing

[r0ck1t]

Hi,
I have this stored procedure:

CREATE PROCEDURE [dbo].[spUserCreds](@strUserCode VarChar(50)) AS
SELECT tblMembers.member_id, tblMembers.member_banned, tblMembers.member_groupid
FROM tblMembers
WHERE tblMembers.member_usercode = @strUserCode;
GO


And when I execute it it has this error:

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'tblMembers'.

/test.asp, line 5

Anyone know what could be wrong? The table does exist and there are values in it. Any help would be great!!!

-r0ck1t-

 

[StPatrick]

Not sure if this is the problem, but try removing the "dbo." from the stored procedure definition. Probably the table is created with another user, not dbo. Though SP should find it anyway, but ekhmm.. try it