Debug sp from Business Intelligence Dev Studio?

Is there a way to debug SQL Server 2005 stored procedures from within BI
Studio? I don't see any way to do it, but may be missing something.
I can do it from a VS 2005, but some systems don't have that installed.
Thanks,
TomHi ,
I don't think you can debug .NET sp without VS 2005 Pro or Team suite. You
should be able to debug a TSQL sp without VS (but I haven't checked) as it
was there as a feature in SQL 2000
kind regards
Greg O
--
Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
AGS SQL 2005 Utilities, over 20+ functions
http://www.ag-software.com/?tabid=38
"TomT" <tomt@.newsgroup.nospam> wrote in message
news:B633E6CF-F829-4A63-A2AA-8C5C219E75A0@.microsoft.com...
> Is there a way to debug SQL Server 2005 stored procedures from within BI
> Studio? I don't see any way to do it, but may be missing something.
> I can do it from a VS 2005, but some systems don't have that installed.
> Thanks,
> Tom|||I don't think the T-SQL debugger is also there in SSMS.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"GregO" <grego@.community.nospam> wrote in message
news:ebLSm2y7FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I don't think you can debug .NET sp without VS 2005 Pro or Team suite.
> You should be able to debug a TSQL sp without VS (but I haven't checked)
> as it was there as a feature in SQL 2000
> kind regards
> Greg O
> --
> Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
> AGS SQL 2005 Utilities, over 20+ functions
> http://www.ag-software.com/?tabid=38
> "TomT" <tomt@.newsgroup.nospam> wrote in message
> news:B633E6CF-F829-4A63-A2AA-8C5C219E75A0@.microsoft.com...
>|||Hello,
I think you need to use Visual Studio 2005 to debug.
You may refer to the following information:
http://www.microsoft.com/technet/co...SQL_101204.mspx
*Q: What kind of debugging options do we have with managed code? Do we have
to attach a debugger to the SQL Server process?
A: Visual Studio 2005 would provide support for debugging Transact SQL and
CLR routines that are registered / running in SQL Server. The debugging in
SQL Server follows per connection model. You can either debug the objects
directly using Visual Studio Server Explorer or attach a client process and
see / debug activities on the connections that client process makes. The
debug engine inside sql server would provide an integrated t-sql / clr
debugging experience.*
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
Waht about TSQL debugging?
Greg
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:ywy6NV07FHA.832@.TK2MSFTNGXA02.phx.gbl...
> Hello,
> I think you need to use Visual Studio 2005 to debug.
> You may refer to the following information:
> http://www.microsoft.com/technet/co...SQL_101204.mspx
> *Q: What kind of debugging options do we have with managed code? Do we
> have
> to attach a debugger to the SQL Server process?
> A: Visual Studio 2005 would provide support for debugging Transact SQL and
> CLR routines that are registered / running in SQL Server. The debugging in
> SQL Server follows per connection model. You can either debug the objects
> directly using Visual Studio Server Explorer or attach a client process
> and
> see / debug activities on the connections that client process makes. The
> debug engine inside sql server would provide an integrated t-sql / clr
> debugging experience.*
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||That's what I was afraid of. It seems then that a customer buying SQL Server
2000 can debug sp's via Query Analyzer at no additional cost, but a customer
buying SQL 2005 will have to buy VS2005 to be able to do this.
Hopefully this functionality will be added back in to the product....
"Sophie Guo [MSFT]" wrote:

> Hello,
> I think you need to use Visual Studio 2005 to debug.
> You may refer to the following information:
> http://www.microsoft.com/technet/co...SQL_101204.mspx
> *Q: What kind of debugging options do we have with managed code? Do we hav
e
> to attach a debugger to the SQL Server process?
> A: Visual Studio 2005 would provide support for debugging Transact SQL and
> CLR routines that are registered / running in SQL Server. The debugging in
> SQL Server follows per connection model. You can either debug the objects
> directly using Visual Studio Server Explorer or attach a client process an
d
> see / debug activities on the connections that client process makes. The
> debug engine inside sql server would provide an integrated t-sql / clr
> debugging experience.*
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hello,
I understand your concerns. However, this is how SQL server 2005 is
designed. I suggest that you access the following web site which provide
good information about Debugging in SQL Server 2005:
Demystifying Debugging in SQL Server 2005
http://www.windowsitpro.com/SQLServ.../SQLServer_4775
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
Note: This response contains a reference to a third party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
Not labour a point but we are talking about TSQL debugging in this part. We
understand CLR debugging is a different matter.
What about TSQL debugging?
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:0P6LLOB8FHA.832@.TK2MSFTNGXA02.phx.gbl...
> Hello,
> I understand your concerns. However, this is how SQL server 2005 is
> designed. I suggest that you access the following web site which provide
> good information about Debugging in SQL Server 2005:
> Demystifying Debugging in SQL Server 2005
> http://www.windowsitpro.com/SQLServ...y/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
> Note: This response contains a reference to a third party World Wide Web
> site. Microsoft is providing this information as a convenience to you.
> Microsoft does not control these sites and has not tested any software or
> information found on these sites; therefore, Microsoft cannot make any
> representations regarding the quality, safety, or suitability of any
> software or information found there. There are inherent dangers in the use
> of any software found on the Internet, and Microsoft cautions you to make
> sure that you completely understand the risk before retrieving any
> software
> from the Internet.
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>|||Hello,
Based on my research, I didn't find the debug button in the Server
Management Studio. You can refer to the information on the following
article:
Demystifying Debugging in SQL Server 2005
http://www.windowsitpro.com/SQLServ.../SQLServer_4775
4.html
*To debug a T-SQL stored procedure in SQL Server 2000, you use the Query
Analyzer. You simply right-click the stored procedure and choose Debug. In
SQL Server 2005, SQL Server Management Studio replaces the Query Analyzer.
It's logical to assume that to debug a T-SQL stored procedure in SQL Server
2005, you simply right-click a stored procedure and select Management
Studio's debug feature. Unfortunately, it's not that straightforward. A
debug option is nowhere to be found.
To debug T-SQL stored procedures in SQL Server 2005, you use the Visual
Studio 2005 development environment.*
I suggest that you refer to the information I posted before.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||v-sguo@.online.microsoft.com (Sophie Guo [MSFT]) wrote in
news:eFNPe0B8FHA.832@.TK2MSFTNGXA02.phx.gbl:

> Hello,
> Based on my research, I didn't find the debug button in the Server
> Management Studio. You can refer to the information on the following
> article:
> Demystifying Debugging in SQL Server 2005
> http://www.windowsitpro.com/SQLServ.../47754/SQLServe
r
> _4775 4.html
> *To debug a T-SQL stored procedure in SQL Server 2000, you use the
> Query Analyzer. You simply right-click the stored procedure and choose
> Debug. In SQL Server 2005, SQL Server Management Studio replaces the
> Query Analyzer. It's logical to assume that to debug a T-SQL stored
> procedure in SQL Server 2005, you simply right-click a stored
> procedure and select Management Studio's debug feature. Unfortunately,
> it's not that straightforward. A debug option is nowhere to be found.
> To debug T-SQL stored procedures in SQL Server 2005, you use the
> Visual Studio 2005 development environment.*
>
Yup, regardless if you want to debug sp's based on CLR code or sp's
based on "pure" T-SQL you use Visual Studio 2005. Personally I think it
wasn't the best decision MS has done, but that's the way it is.
Oh BTW, there will be a follow-up article to the one mentioned above. In
this I'll discuss CLR debugging inside SQL Server.
Niels
****************************************
**********
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
****************************************
**********