Stored procedures do not appear in the list. I am using SQL Server Management Studio Express pointing to a SQL 2000 database. What do I need to do to get them to appear?
UPDATE: It seems to work until there is a begin statement. After that, it does not (and since we start all of our stored procedures with a begin statement (ex: CREATE PROC xyz AS BEGIN <SP TEXT> END), it doesn't work at all for us).
UPDATE: It seems to work until there is a begin statement. After that, it does not (and since we start all of our stored procedures with a begin statement (ex: CREATE PROC xyz AS BEGIN <SP TEXT> END), it doesn't work at all for us).