Debugging in SQL2005

Hi,
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris WoodChris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood
>|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
>> Chris,
>> If you have installed only SQL Server 2005 you will find limited
>> information in BOL if you search on "debugging stored procedures".
>> If you have Visual Studio 2005 also installed on the machine the same
>> search in the document explorer which combines MSDN and BOL for search
>> will give you more information that is relevant.
>> Andrew Watt
>> MVP - InfoPath
>> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
>> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood