I have created a table
testtable inside the database
testbase that have the following structure:
product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, null) expire_time (time(7), null)
which I used the Microsoft SQL Server 2008 Management Studio.
I created a stored procedure
testtable_pricesmaller as follows
use testbase go create procedure testtable_pricesmaller @pricelimit money as select * from testtable where price = @pricelimit; go
and are able to view the Stored Procedures on the
Object Explorer of the Microsoft SQL Server Management Studio. (It is listed in the following tree structure of the
Databases + testbase + Tables + dbo.testtable + Programmability + Stored Procedures + dbo.testtable_pricesmaller
I find it very strange when I receive the following error:
Could not find the stored procedure 'dbo.testtable_pricesmaller'.
when I execute the following SQL statement:
execute dbo.testtable_pricesmaller 50
What could it be missing?