I am using SQL Server 2005 and I having problems with stored procedures.
Whenever I create an SP and save it, it saves it here "My Documents" --> "SQL Server Management Studio" --> "Projects".
The problem: It does not appear in Microsoft SQL Server Management Studio in this folder "Programmability" --> "Stored Procedures" for the database that I'm working with. I always have to connect to the server remotely to create my SPs. Only then does it appear in the "Stored Procedures" folder.
What am I doing wrong??