Hi Claudio,
In VS.NET, you can edit your SPs by using the Server Explorer. You just need to tree down and find your stored procedure to edit. Right-click on the SP and choose Edit Stored Procedure. You can also run SPs by right-clicking on the SP and choosing Run Stored Procedure. If there are any parameters, VS.NET will prompt for their values.
>Hi, all!
>
>In VS.NET, is it possible to open a .SQL file and run that with an F5, for example? Yes, make it behaves kinda like SQL's Query Analyzer.
>
>I know that I can run SPs from the Server Explorer, but it actually doesn't allow me to open the SP for editing and then run it from the editor.
>
>TIA
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi