SQL Server Enterprise Manager 2005 - stored procedures not showing up

Question

When using SQL Server Management Studio from SQL Server 2005, I can connect to an instance of SQL Server 2000... but none of the stored procedures show up. Is there some trick to allow SQL Server Enterprise Manager 2005 to properly talk to SQL Server 2000 databases?

Answer 1

I'm guessing that the account that you're logging in as does not have access to execute the stored procs. If it doesn't have access to use a stored proc, SQL Server Management Studio 2005 won't show it (regardless of it you're connecting to a SQL 2000 or 2005 server)