Editing Stored Procedures

Probably the wrong NG, but I can't find one for Visual Studio.
How are you supposed to edit SP's in VS 2003? I cannot find the option
anywhere. I can do it from Query Analyzer simply enough, but flipping back
and forth is a pain.Hi Rock,
In Visual Studio 2003, you can create and edit a stored procedure via the
following steps:
1. Click View menu and select "Server Explorer";
2. Right click "Data Connections", click "Add Connection...", in the "Data
Link Properties" window, input the server name and select the database;
3. Expand the database connection "<server name>.<database name>.dbo",
expand "Stored Procedures", double click the stored procedure for browsing
or editing. If you want to create a new stored procedure, just right click
"Stored Procedures" and click "New Stored Procedure".
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============