"Adrian Parker" <apparker@nospam.nospam> wrote in message
news:upUEjidzGHA.4796@TK2MSFTNGP06.phx.gbl...
> Thanks Kevin,
>
> It needed Exec sp_sdidebug 'legacy_on'
>
> Is there any way of turning it on permanently on our dev machines ?
>
> Adrian
>
> "Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
> news:aX7XiJYzGHA.4464@TK2MSFTNGXA01.phx.gbl...
> | Hi Adrian,
> |
> | I think this might be an improper configuration on VS.NET. So here is a
> | document about how to setup SQL stored procedure debugging. Please try
> to
> | go through it and see if this can solve this problem.
> |
> | http://msdn2.microsoft.com/en-us/library/s4sszxst.aspx
> |
> | Kevin Yu
> | Microsoft Online Community Support
> |
> | ==================================================
> | Get notification to my posts through email? Please refer to
> |
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> | ications.
> | Note: The MSDN Managed Newsgroup support offering is for non-urgent
> issues
> | where an initial response from the community or a Microsoft Support
> | Engineer within 1 business day is acceptable. Please note that each
> follow
> | up response may take approximately 2 business days as the support
> | professional working with you may need further investigation to reach
> the
> | most efficient resolution. The offering is not appropriate for
> situations
> | that require urgent, real-time or phone-based interactions or complex
> | project analysis and dump analysis issues. Issues of this nature are
> best
> | handled working with a dedicated Microsoft Support Engineer by
> contacting
> | Microsoft Customer Support Services (CSS) at
> | http://msdn.microsoft.com/subscriptions/support/default.aspx.
> | ==================================================
> |
> | (This posting is provided "AS IS", with no warranties, and confers no
> | rights.)
> |
>
>

"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:aX7XiJYzGHA.4464@TK2MSFTNGXA01.phx.gbl...

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:e%23vvO8dzGHA.476@TK2MSFTNGP06.phx.gbl...

"Adrian Parker" <apparker@nospam.nospam> wrote in message
news:eK$zCsl0GHA.4908@TK2MSFTNGP02.phx.gbl...
> keping legacy on..
>
> add the following procedure to your master db..
>
> CREATE PROCEDURE usp_force_legacy
> AS
> BEGIN
> EXEC sp_sdidebug 'legacy_on'
> END
>
>
> then the following will tell sql server to run the procedure every time it
> starts
>
> EXEC sp_procoption 'usp_force_legacy', 'startup', 'true'
>
>
>
>