debug tool in SQL2005

How can I use debug tool for trigger development in SQL 2005?
Can you please give me some guideline? If I developed the trigger in SQL2000
prevously and now upgrade to SQL 2005, can I still use vs tools for this?
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uqXXUPsEHHA.2176@.TK2MSFTNGP02.phx.gbl...
> You need Visual Studio 2005, Professional or higher.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "-000MJ" <mj@.yahoo.com> wrote in message
> news:%23Ruw1UqEHHA.992@.TK2MSFTNGP03.phx.gbl...
>
|||I cannot find the Database Project in "Other Project Types". It only has
Blank Solution. Do I miss anything? Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23eMpLX5EHHA.2468@.TK2MSFTNGP06.phx.gbl...
> Create a stored procedure which will fire the trigger.
> In Visual Studio 2005, you create a project of type "Database Project"
> (which you find in "Other Project Types").
> Open the Server Explorer window. Right-click the database and select
> "Application Debugging".
> Right-click and open the trigger and set a breakpoint.
> Right-click the procedure that you created (in server explorer). Select
> "Step into..."
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "-000MJ" <mj@.yahoo.com> wrote in message
> news:eDYsvB3EHHA.4952@.TK2MSFTNGP06.phx.gbl...
>
|||My version is 8.0.50727.42 . Does this tell Professional Edition or not?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23buGjuFFHHA.3616@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Do you have Professional Edition of Visual Studio?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "-000MJ" <mj@.yahoo.com> wrote in message
> news:%23oHjD2BFHHA.924@.TK2MSFTNGP02.phx.gbl...
|||It is "Premier Partner Editon". Is it good enough? What I can now? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OOLx2g8FHHA.536@.TK2MSFTNGP02.phx.gbl...
> No. But of you do Help, "About Visual Studio 2005", you should see what
> edition you are using. At least I see, in the top section of that window
> mention "Professional Edition". Also, Control Panel, Add remove Program
> say Professional Edition on my machine.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00MichaelJordan" <MJ@.yahoo.com> wrote in message
> news:OOEKj$1FHHA.1248@.TK2MSFTNGP02.phx.gbl...
>
|||In fact, my visual studio is bundled with SQL 2005 server. On the other
hand, does it mean only Professional Edition can develop and maintain
trigger in the SQL 2005 server.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23KRa3DFGHHA.3616@.TK2MSFTNGP06.phx.gbl...
>I don't know. I suggest you ask this on a Visual Studio newsgroup, what
>edition this corresponds to. The edition you mention does not appear on the
>Visual Studio edition list at:
>http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00MichaelJordan" <MJ@.yahoo.com> wrote in message
> news:%23sSGEYAGHHA.1912@.TK2MSFTNGP03.phx.gbl...
>