|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Replacement for SQL Query AnalyserDoes anybody know if there is one in 2005.
Sure I can run the sp's but can't see how I can step through them. Thanks "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in SQL Server Management Studio (SSMS) is the replacement.news:OdAWjDB8FHA.2576@TK2MSFTNGP12.phx.gbl: > Does anybody know if there is one in 2005. -- Ole Kristian Bangås MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging But you cannot debug ..?
Show quote "Ole Kristian Bangås" <olekristian.ban***@masterminds.no> wrote in message news:Xns971772D96ED48olekristianbangaas@207.46.248.16... > "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in > news:OdAWjDB8FHA.2576@TK2MSFTNGP12.phx.gbl: > >> Does anybody know if there is one in 2005. > > SQL Server Management Studio (SSMS) is the replacement. > > -- > Ole Kristian Bangås > MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging >From another thread answered few time ago: Demystifying Debugging in SQL Server 2005http://www.windowsitpro.com/SQLServer/Article/ArticleID/47754/SQLServ... 4.html How to: Debug a SQL CLR Stored Procedure http://msdn2.microsoft.com/en-us/library/ms165051.aspx How to: Enable SQL Server 2005 Debugging http://msdn2.microsoft.com/en-us/library/s0fk6z6e.aspx Creating SQL Server 2005 Objects in Managed Code http://msdn2.microsoft.com/en-us/library/6s0s2at1.aspx SQL Server 2005 Debugging http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx HTH, Jens Suessmeyer. Good point,
To debug in SQL 2005 you need Visual Studio. I have a link on my website that points to the related MSDN article http://www.dandyman.net/sql/articles.aspx -- Show quoteDandy Weyn [MCSE-MCSA-MCDBA-MCDST-MCT] http://www.dandyman.net Check my SQL Server Resource Pages at http://www.dandyman.net/sql "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in message news:%230OTxiB8FHA.1416@TK2MSFTNGP09.phx.gbl... > But you cannot debug ..? > > > "Ole Kristian Bangås" <olekristian.ban***@masterminds.no> wrote in message > news:Xns971772D96ED48olekristianbangaas@207.46.248.16... >> "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in >> news:OdAWjDB8FHA.2576@TK2MSFTNGP12.phx.gbl: >> >>> Does anybody know if there is one in 2005. >> >> SQL Server Management Studio (SSMS) is the replacement. >> >> -- >> Ole Kristian Bangås >> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging > > In VS 2005. New Query from the Server Explorer or within a DB project.
SSMS has the same 4 pane deal, but it works different. It requires, IIRC, that you design the query and then paste that into a .sql tab/file and run it. -- Show quoteWilliam Stacey [MVP] "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in message news:OdAWjDB8FHA.2576@TK2MSFTNGP12.phx.gbl... > Does anybody know if there is one in 2005. > > Sure I can run the sp's but can't see how I can step through them. > > Thanks >  |
|||||||||||||||||||||||
Other interesting topics