| Author |
debug tool in SQL2005
|
|
| -000MJ 2006-11-28, 12:12 am |
| How can I use debug tool for trigger development in SQL 2005?
| |
|
|
| -000MJ 2006-11-29, 12:12 am |
| 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@hotmai
l.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...
>
>
| |
| Tibor Karaszi 2006-11-29, 5:17 am |
| 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@hotmai
l.nomail.com> wrote in message
> news:uqXXUPsEHHA.2176@TK2MSFTNGP02.phx.gbl...
>
>
| |
| -000MJ 2006-11-30, 12:12 am |
| 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@hotmai
l.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...
>
>
| |
| Tibor Karaszi 2006-11-30, 5:18 am |
| 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@hotmai
l.nomail.com> wrote in
> message news:%23eMpLX5EHHA.2468@TK2MSFTNGP06.phx.gbl...
>
>
| |
| 00MichaelJordan 2006-12-04, 12:12 am |
| My version is 8.0.50727.42 . Does this tell Professional Edition or not?
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:%23buGjuFFHHA.3616@TK2MSFTNGP02.phx.gbl...[color=darkred]
> 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...
| |
| Tibor Karaszi 2006-12-04, 7:12 pm |
| 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@hotmai
l.nomail.com> wrote in message
> news:%23buGjuFFHHA.3616@TK2MSFTNGP02.phx.gbl...
>
| |
| 00MichaelJordan 2006-12-04, 7:12 pm |
| It is "Premier Partner Editon". Is it good enough? What I can now? Thanks.
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.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...
>
| |
| Tibor Karaszi 2006-12-05, 5:16 am |
| 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@hotmai
l.nomail.com> wrote in message
> news:OOLx2g8FHHA.536@TK2MSFTNGP02.phx.gbl...
>
>
| |
| 00MichaelJordan 2006-12-05, 7:12 pm |
| 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@hotmai
l.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...
>
>
| |
| Tibor Karaszi 2006-12-06, 5:16 am |
| > 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@hotmai
l.nomail.com> wrote in message
> news:%23KRa3DFGHHA.3616@TK2MSFTNGP06.phx.gbl...
>
>
|
|
|
|