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...
> 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...
>> How can I use debug tool for trigger development in SQL 2005?
>|||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...
> 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...
>> How can I use debug tool for trigger development in SQL 2005?
>>
>|||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...
>> 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...
>> How can I use debug tool for trigger development in SQL 2005?
>>
>>
>|||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...
>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...
>> 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...
>> How can I use debug tool for trigger development in SQL 2005?
>>
>>
>>
>|||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...
> 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...
>>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...
>> 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...
>> How can I use debug tool for trigger development in SQL 2005?
>>
>>
>>
>>|||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...
> 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...
>> 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...
>>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...
>> 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...
>>> How can I use debug tool for trigger development in SQL 2005?
>>>
>>
>>
>>
>|||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...
>> 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...
>> 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...
>>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...
>> 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...
>>> How can I use debug tool for trigger development in SQL 2005?
>>>
>>>
>>>
>>
>>
>>
>|||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...
> 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...
>> 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...
>> 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...
>>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...
>>> 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...
>>> How can I use debug tool for trigger development in SQL 2005?
>>>
>>>
>>>
>>>
>>>
>>
>>
>|||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...
>> 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...
>> 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...
>> 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...
>>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...
>>> 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...
>>>> How can I use debug tool for trigger development in SQL 2005?
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>|||> In fact, my visual studio is bundled with SQL 2005 server.
You need to buy the Professional Edition or higher of VS to get the debug TSQL support (the Database
Project).
>On the other hand, does it mean only Professional Edition can develop and maintain trigger in the
>SQL 2005 server.
See my above comment. But note that SQL Server Management Studio has abilities to create and manage
triggers. But if you need specifically *debug* of TSQL code, you need VS Pro or higher.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00MichaelJordan" <MJ@.yahoo.com> wrote in message news:eztvT6MGHHA.1784@.TK2MSFTNGP06.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...
>> 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...
>> 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...
>> 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...
>>>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...
>>> 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...
>>>> How can I use debug tool for trigger development in SQL 2005?
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>