Debugging CLR Objects

Hi,
I was able to use SQL Server Project template in VS to debug my CLR-SPs. But
I'd like to know if it is possible to debug those CLR-Objects while
executing from SSMS.
Any help would be greatly appreciated.
LeilaHi
No, CLR objects must be debugged from within Visual Studio 2005.
From SQL Server 2005 BOL
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/1332035c-d6ed-424d-8234-4
6ad21168319.htm):
"SQL Server 2005 does not ship with a debugger. Microsoft Visual Studio 2005
supports debugging connections to SQL Server. For more information about how
to debug SQL Server 2005 CLR stored procedures, functions, triggers, user
defined types, and aggregates from Visual Studio, see the Visual Studio 2005
documentation."
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Leila" <Leilas@.hotpop.com> wrote in message
news:eibf7eb%23FHA.600@.tk2msftngp13.phx.gbl...
> Hi,
> I was able to use SQL Server Project template in VS to debug my CLR-SPs.
> But
> I'd like to know if it is possible to debug those CLR-Objects while
> executing from SSMS.
> Any help would be greatly appreciated.
> Leila
>|||Thanks,
But what about attaching processes from VS IDE? It seems there are some
facilities for Analysis Services.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ecWBBrb#FHA.1332@.tk2msftngp13.phx.gbl...
> Hi
> No, CLR objects must be debugged from within Visual Studio 2005.
> From SQL Server 2005 BOL
>
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/1332035c-d6ed-424d-8234-4
6ad21168319.htm):
> "SQL Server 2005 does not ship with a debugger. Microsoft Visual Studio
2005
> supports debugging connections to SQL Server. For more information about
how
> to debug SQL Server 2005 CLR stored procedures, functions, triggers, user
> defined types, and aggregates from Visual Studio, see the Visual Studio
2005
> documentation."
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:eibf7eb%23FHA.600@.tk2msftngp13.phx.gbl...
>