MS SQL Server Tools - Replacement for SQL Query Analyser

Author

Replacement for SQL Query Analyser

Chubbly Geezer

2005-11-23, 7:24 am

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

Ole Kristian Bangås

2005-11-23, 7:24 am

"Chubbly Geezer" < chubbly_geezer@newsg
roup.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

Chubbly Geezer

2005-11-23, 7:24 am

But you cannot debug ..?

"Ole Kristian Bangås" <olekristian.bangas@masterminds.no> wrote in message
news:Xns971772D96ED4
8olekristianbangaas@
207.46.248.16...
> "Chubbly Geezer" < chubbly_geezer@newsg
roup.nospam> wrote in
> news:OdAWjDB8FHA.2576@TK2MSFTNGP12.phx.gbl:
>
>
> SQL Server Management Studio (SSMS) is the replacement.
>
> --
> Ole Kristian Bangås
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

Jens

2005-11-23, 7:24 am

>From another thread answered few time ago:

Demystifying Debugging in SQL Server 2005
http://www.windowsitpro.com/SQLServ...7754/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/ni...08/04/3758.aspx

HTH, Jens Suessmeyer.

Dandy Weyn [Dandyman]

2005-11-23, 8:24 pm

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

--
Dandy 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@newsg
roup.nospam> wrote in message
news:%230OTxiB8FHA.1416@TK2MSFTNGP09.phx.gbl...
> But you cannot debug ..?
>
>
> "Ole Kristian Bangås" <olekristian.bangas@masterminds.no> wrote in message
> news:Xns971772D96ED4
8olekristianbangaas@
207.46.248.16...
>
>

William Stacey [MVP]

2005-11-24, 1:23 pm

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.

--
William Stacey [MVP]

"Chubbly Geezer" < chubbly_geezer@newsg
roup.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
>

Sponsored Links