debug tool in SQL2005

How can I use debug tool for trigger development in SQL 2005?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...[vbco
l=seagreen]
> How can I use debug tool for trigger development in SQL 2005?
>[/vbcol]|||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...
>|||Create a stored procedure which will fire the trigger.
In Visual Studio 2005, you create a project of type "Database Project" (whic
h you find in "Other
Project Types").
Open the Server Explorer window. Right-click the database and select "Applic
ation Debugging".
Right-click and open the trigger and set a breakpoint.
Right-click the procedure that you created (in server explorer). Select "Ste
p 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...[vbcol
=seagreen]
> Can you please give me some guideline? If I developed the trigger in SQL20
00 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 i
n message
> news:uqXXUPsEHHA.2176@.TK2MSFTNGP02.phx.gbl...
>[/vbcol]|||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...
>|||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...[vbco
l=seagreen]
>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 i
n
> message news:%23eMpLX5EHHA.2468@.TK2MSFTNGP06.phx.gbl...
>[/vbcol]|||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...|||No. But of you do Help, "About Visual Studio 2005", you should see what edit
ion 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
..
> 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 i
n message
> news:%23buGjuFFHHA.3616@.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...
>|||I don't know. I suggest you ask this on a Visual Studio newsgroup, what edit
ion 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.g
bl...
> 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 i
n message
> news:OOLx2g8FHHA.536@.TK2MSFTNGP02.phx.gbl...
>