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?
SQL Server Enterprise Manager 2005 – stored procedures not showing up
sql serversql-server-2005
Related Topic
- Sql-server – Check if table exists in SQL Server
- Sql – Parameterize an SQL IN clause
- Sql – Simulating group_concat MySQL function in Microsoft SQL Server 2005
- Sql – Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
- Javascript – How to connect to SQL Server database from JavaScript in the browser
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
Best Answer
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)