Here is my stored procedure:

CREATE PROCEDURE dbo.GET_USER_DETAIL (@lan_id varchar)

AS

SELECT * FROM APP_USER WHERE [LAN_ID]=@lan_id

GO

When I exec the stored proc, nothing gets returned, but when I run the select statement on...

I already have SQL Server 2000 installed, and this is what I am limited to.  I just need to know how to create the local db and users, assign permissions...