Hi
_I use sql server 2005 and I want to execute mu store procedure like exec <procedure_Name> ' ',' ',' '
so for this I need query analyzer window but I can not find please help me
_also is there any check syntax box in sql server 2005? thanks
views:
18answers:
3
A:
In SQL Server 2005, Query Analyzer has been replaced with SQL Server Management Studio. There is a toolbar button for syntax checking.
Alek Davis
2010-07-08 06:43:35
SQl Server management Studio is an option?
2010-07-08 06:47:51
I'm not sure what you're asking.
Alek Davis
2010-07-08 16:56:53
+1
A:
AFAIK, in SQL Server 2005, the whole of Query Analyzer was rolled into Sql Server Management Studio (you can get the Express version for free, if you don't have a full license). Also, you can perform syntax checking simply by turning off execution in your T-SQL batch.
Marc Bollinger
2010-07-08 06:45:12
A:
In SQL Management Studio click New Query at the top left, or right-click your stored procedure and go Script Stored Procedure As -> EXECUTE To -> New Query Editor Window.
You can check the syntax of a query (somewhat) by clicking the "Tick" on the toolbar (it is the Parse button). However, it is not completely accurate.
Graphain
2010-07-08 06:46:10
aha I have saved my stored procedure but there is not in the stored procedure option,why?
2010-07-08 06:54:11
You can't see the procedure under DB -> Programmability -> Stored Procedures or you can't see "Script as" when you right-click your Stored Procedure?
Graphain
2010-07-08 06:58:26