Question:
I write a stored procedure and it works fine. But when I do write a “select statement” as below:

"select * from sp_name"

I get an error message:

"Server: Msg 208, Level 16, State 3, Line 1Invalid object name 'sp_name'.

Why does this happen?

Answer:
I think the problem may be in the way the stored procedure is called. A SELECT statement can’t be issued against a stored procedure. The SELECT statement should be inside the procedure, and you can call it from Query Analyzer like this:

EXEC sp_name