-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: LovedJohnySmith
Message 2 in Discussion
New Message on MumbaiUserGroup
Article: How to debug stored procedure like
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
johnsonsmithy2k2
Not
only does Visual Studio .NET make attaching to processes much easier, one
option you have when attaching to those processes is debugging SQL Server
stored procedures. To enable this feature, you'll need to make sure that
the SQL Server debugging components have been installed on your machine
and that you have the appropriate permissions to debug stored procedures.
Once that's been taken care of, you can use the Server Explorer to select
any SQL Server database on your network, bring up your stored procedure,
set a breakpoint, and then execute the code that calls that stored procedure.
Once your SQL breakpoint is hit, you've got single-stepping, stepping in,
data tips, and the rest of the Visual Studio .NET debugging tricks that
you've grown to know and love.
Hw we can achivethis?
using sqldbreg.exe, we can achive this.
Regards,
smith
DISCLAIMER: The information contained in this message is intended only and
solely for the addressed individual or entity indicated in this message and for
the exclusive use of the said addressed individual or entity indicated in this
message (or responsible for delivery of the message to such person) and may
contain legally privileged and confidential information belonging to Tata
Consultancy Services Limited. It must not be printed, read, copied, disclosed,
forwarded, distributed or used (in whatsoever manner) by any person other than
the addressee. Unauthorized use, disclosure or copying is strictly prohibited
and may constitute unlawful act and can possibly attract legal action, civil
and/or criminal. The contents of this message need not necessarily reflect or
endorse the views of Tata Consultancy Services limited on any subject matter.
Any action taken or omitted to be taken based on this message is entirely at
your risk and neither the originator of this message nor Tata Consultancy
Services Limited takes any responsibility or liability towards the same.
Opinions, conclusions and any other information contained in this message that
do not relate to the official business of Tata Consultancy Services limited
shall be understood as neither given nor endorsed by Tata Consultancy Services
Limited or any affiliate of Tata Consultancy Services Limited. If you have
received this message in error, you should destroy this message and may please
notify the sender by e-mail.
Thank you.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
