I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Server
2005. I setup a stored procedure to insert to the view, then (in Visual
Studio) put a stop in the stored procedure. This works fine, until I try to
step into the trigger. Then it tells me that no code is available.
If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won't
allow me, saying "A breakpoint could not be inserted at this location".
This only happens for any trigger on the view. If I try to set a breakpoint
on a trigger on a table, it works fine.
Does anyone know a way around this? I really would like to step though the
trigger on the view.Is anyone going to respond to this? I thought these news groups were managed
and a response could be expected in 48 hours.
"BrianInHouston" wrote:
> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Server
> 2005. I setup a stored procedure to insert to the view, then (in Visual
> Studio) put a stop in the stored procedure. This works fine, until I try to
> step into the trigger. Then it tells me that no code is available.
> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won't
> allow me, saying "A breakpoint could not be inserted at this location".
> This only happens for any trigger on the view. If I try to set a breakpoint
> on a trigger on a table, it works fine.
> Does anyone know a way around this? I really would like to step though the
> trigger on the view.|||I don't know the answer to the debugging question, but yes, if you're an
MSDN subscriber and posted this using the account you registered when you
signed up for managed newsgroups, you should get a response within 2
business days. If you don't, the FAQ page points you at
https://support.microsoft.com/common/survey.aspx?scid=sw;en;1296&showpage=1&ws=msdn&sd=msdn&pa=msdnw
to contact the folks at MSDN about it.
The first thing to do, however, is to ensure that the alias that you're
posting with is registered properly. To do that, go to
http://msdn.microsoft.com/subscriptions/, sign in, and click the Managed
Newsgroups link.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"BrianInHouston" <BrianInHouston@.discussions.microsoft.com> wrote in message
news:66D6AC1C-BB18-4FC4-B30C-F94D33A441E2@.microsoft.com...
> Is anyone going to respond to this? I thought these news groups were
> managed
> and a response could be expected in 48 hours.
> "BrianInHouston" wrote:
>> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL
>> Server
>> 2005. I setup a stored procedure to insert to the view, then (in Visual
>> Studio) put a stop in the stored procedure. This works fine, until I try
>> to
>> step into the trigger. Then it tells me that no code is available.
>> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it
>> won't
>> allow me, saying "A breakpoint could not be inserted at this location".
>> This only happens for any trigger on the view. If I try to set a
>> breakpoint
>> on a trigger on a table, it works fine.
>> Does anyone know a way around this? I really would like to step though
>> the
>> trigger on the view.
Showing posts with label trigger. Show all posts
Showing posts with label trigger. Show all posts
Saturday, February 25, 2012
Debugging triggers on views in SQL Server 2005?
I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Server
2005. I setup a stored procedure to insert to the view, then (in Visual
Studio) put a stop in the stored procedure. This works fine, until I try to
step into the trigger. Then it tells me that no code is available.
If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won't
allow me, saying "A breakpoint could not be inserted at this location".
This only happens for any trigger on the view. If I try to set a breakpoint
on a trigger on a table, it works fine.
Does anyone know a way around this? I really would like to step though the
trigger on the view.Is anyone going to respond to this? I thought these news groups were manage
d
and a response could be expected in 48 hours.
"BrianInHouston" wrote:
> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Serve
r
> 2005. I setup a stored procedure to insert to the view, then (in Visual
> Studio) put a stop in the stored procedure. This works fine, until I try
to
> step into the trigger. Then it tells me that no code is available.
> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won
't
> allow me, saying "A breakpoint could not be inserted at this location".
> This only happens for any trigger on the view. If I try to set a breakpoi
nt
> on a trigger on a table, it works fine.
> Does anyone know a way around this? I really would like to step though th
e
> trigger on the view.|||I don't know the answer to the debugging question, but yes, if you're an
MSDN subscriber and posted this using the account you registered when you
signed up for managed newsgroups, you should get a response within 2
business days. If you don't, the FAQ page points you at
https://support.microsoft.com/commo...d=msdn&pa=msdnw
to contact the folks at MSDN about it.
The first thing to do, however, is to ensure that the alias that you're
posting with is registered properly. To do that, go to
http://msdn.microsoft.com/subscriptions/, sign in, and click the Managed
Newsgroups link.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"BrianInHouston" <BrianInHouston@.discussions.microsoft.com> wrote in message
news:66D6AC1C-BB18-4FC4-B30C-F94D33A441E2@.microsoft.com...[vbcol=seagreen]
> Is anyone going to respond to this? I thought these news groups were
> managed
> and a response could be expected in 48 hours.
> "BrianInHouston" wrote:
>|||Is anyone going to respond to this? I thought these news groups were manage
d
and a response could be expected in 48 hours.
"BrianInHouston" wrote:
> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Serve
r
> 2005. I setup a stored procedure to insert to the view, then (in Visual
> Studio) put a stop in the stored procedure. This works fine, until I try
to
> step into the trigger. Then it tells me that no code is available.
> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won
't
> allow me, saying "A breakpoint could not be inserted at this location".
> This only happens for any trigger on the view. If I try to set a breakpoi
nt
> on a trigger on a table, it works fine.
> Does anyone know a way around this? I really would like to step though th
e
> trigger on the view.|||I don't know the answer to the debugging question, but yes, if you're an
MSDN subscriber and posted this using the account you registered when you
signed up for managed newsgroups, you should get a response within 2
business days. If you don't, the FAQ page points you at
https://support.microsoft.com/commo...d=msdn&pa=msdnw
to contact the folks at MSDN about it.
The first thing to do, however, is to ensure that the alias that you're
posting with is registered properly. To do that, go to
http://msdn.microsoft.com/subscriptions/, sign in, and click the Managed
Newsgroups link.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"BrianInHouston" <BrianInHouston@.discussions.microsoft.com> wrote in message
news:66D6AC1C-BB18-4FC4-B30C-F94D33A441E2@.microsoft.com...[vbcol=seagreen]
> Is anyone going to respond to this? I thought these news groups were
> managed
> and a response could be expected in 48 hours.
> "BrianInHouston" wrote:
>
2005. I setup a stored procedure to insert to the view, then (in Visual
Studio) put a stop in the stored procedure. This works fine, until I try to
step into the trigger. Then it tells me that no code is available.
If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won't
allow me, saying "A breakpoint could not be inserted at this location".
This only happens for any trigger on the view. If I try to set a breakpoint
on a trigger on a table, it works fine.
Does anyone know a way around this? I really would like to step though the
trigger on the view.Is anyone going to respond to this? I thought these news groups were manage
d
and a response could be expected in 48 hours.
"BrianInHouston" wrote:
> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Serve
r
> 2005. I setup a stored procedure to insert to the view, then (in Visual
> Studio) put a stop in the stored procedure. This works fine, until I try
to
> step into the trigger. Then it tells me that no code is available.
> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won
't
> allow me, saying "A breakpoint could not be inserted at this location".
> This only happens for any trigger on the view. If I try to set a breakpoi
nt
> on a trigger on a table, it works fine.
> Does anyone know a way around this? I really would like to step though th
e
> trigger on the view.|||I don't know the answer to the debugging question, but yes, if you're an
MSDN subscriber and posted this using the account you registered when you
signed up for managed newsgroups, you should get a response within 2
business days. If you don't, the FAQ page points you at
https://support.microsoft.com/commo...d=msdn&pa=msdnw
to contact the folks at MSDN about it.
The first thing to do, however, is to ensure that the alias that you're
posting with is registered properly. To do that, go to
http://msdn.microsoft.com/subscriptions/, sign in, and click the Managed
Newsgroups link.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"BrianInHouston" <BrianInHouston@.discussions.microsoft.com> wrote in message
news:66D6AC1C-BB18-4FC4-B30C-F94D33A441E2@.microsoft.com...[vbcol=seagreen]
> Is anyone going to respond to this? I thought these news groups were
> managed
> and a response could be expected in 48 hours.
> "BrianInHouston" wrote:
>|||Is anyone going to respond to this? I thought these news groups were manage
d
and a response could be expected in 48 hours.
"BrianInHouston" wrote:
> I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Serve
r
> 2005. I setup a stored procedure to insert to the view, then (in Visual
> Studio) put a stop in the stored procedure. This works fine, until I try
to
> step into the trigger. Then it tells me that no code is available.
> If I try in Visual Studio 2005 to set a breakpoint on this trigger, it won
't
> allow me, saying "A breakpoint could not be inserted at this location".
> This only happens for any trigger on the view. If I try to set a breakpoi
nt
> on a trigger on a table, it works fine.
> Does anyone know a way around this? I really would like to step though th
e
> trigger on the view.|||I don't know the answer to the debugging question, but yes, if you're an
MSDN subscriber and posted this using the account you registered when you
signed up for managed newsgroups, you should get a response within 2
business days. If you don't, the FAQ page points you at
https://support.microsoft.com/commo...d=msdn&pa=msdnw
to contact the folks at MSDN about it.
The first thing to do, however, is to ensure that the alias that you're
posting with is registered properly. To do that, go to
http://msdn.microsoft.com/subscriptions/, sign in, and click the Managed
Newsgroups link.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"BrianInHouston" <BrianInHouston@.discussions.microsoft.com> wrote in message
news:66D6AC1C-BB18-4FC4-B30C-F94D33A441E2@.microsoft.com...[vbcol=seagreen]
> Is anyone going to respond to this? I thought these news groups were
> managed
> and a response could be expected in 48 hours.
> "BrianInHouston" wrote:
>
Debugging Triggers
I was wondering if it is possible to pop up a dialog box from a SQL trigger.
This would be a great way to debug triggers as you could report variable values in the dialog box.
If not, does anybody have any suggestions as to the best way of reporting out variable values whilst a trigger is running?Sometimes I will feed values and sql strings into a table, sometimes I will use profiler with all of the XXXcompleted events turned on for th Transact-SQL and stored prpcedures classes.|||Install the stored procedure debugging package from the MS-SQL CD? I haven't used it in a while, but it lets you set breakpoints, watches, etc. very much like Visual Studio.
-PatP
This would be a great way to debug triggers as you could report variable values in the dialog box.
If not, does anybody have any suggestions as to the best way of reporting out variable values whilst a trigger is running?Sometimes I will feed values and sql strings into a table, sometimes I will use profiler with all of the XXXcompleted events turned on for th Transact-SQL and stored prpcedures classes.|||Install the stored procedure debugging package from the MS-SQL CD? I haven't used it in a while, but it lets you set breakpoints, watches, etc. very much like Visual Studio.
-PatP
Friday, February 24, 2012
Debugging SPs and triggers in VS2005
I have an AFTER INSERT trigger on table A than calls a stored procedure
which performs a DISABLE TRIGGER ALL on table A, does some actions then
finally does an ENABLE TRIGGER ALL.
This works fine normally except, when I'm stepping through the SP code, the
entire IDE hangs when executing the DISABLE TRIGGER. Presumably this is
because the debugging process is preventing the trigger from disabling
because it is still technically executing. I guess that is understandable!
Is this expected behaviour? Likely to ever change?
Thanks in advance.
regards,
Paul Ritchie.
New Zealand.Why would you need to disable a trigger during its execution? Do you also pu
t
the database in single-user mode at the same time?
ML|||So I can insert another record in the same table.
Thanks for the sarcasm - much appreciated. If you don't know the answer
then why bother?
Paul.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:FD1BB005-A3DD-42F7-A42D-9435424D9DE3@.microsoft.com...
> Why would you need to disable a trigger during its execution? Do you also
> put
> the database in single-user mode at the same time?
>
> ML|||If recursion is the problem turn that off. I'm not being sarcastic. A
disabled trigger will allow other users to insert data into the table while
by-passing your procedure.
ML
which performs a DISABLE TRIGGER ALL on table A, does some actions then
finally does an ENABLE TRIGGER ALL.
This works fine normally except, when I'm stepping through the SP code, the
entire IDE hangs when executing the DISABLE TRIGGER. Presumably this is
because the debugging process is preventing the trigger from disabling
because it is still technically executing. I guess that is understandable!
Is this expected behaviour? Likely to ever change?
Thanks in advance.
regards,
Paul Ritchie.
New Zealand.Why would you need to disable a trigger during its execution? Do you also pu
t
the database in single-user mode at the same time?
ML|||So I can insert another record in the same table.
Thanks for the sarcasm - much appreciated. If you don't know the answer
then why bother?
Paul.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:FD1BB005-A3DD-42F7-A42D-9435424D9DE3@.microsoft.com...
> Why would you need to disable a trigger during its execution? Do you also
> put
> the database in single-user mode at the same time?
>
> ML|||If recursion is the problem turn that off. I'm not being sarcastic. A
disabled trigger will allow other users to insert data into the table while
by-passing your procedure.
ML
Sunday, February 19, 2012
Debugging in QA
Hi,
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks
1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>
|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks
1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>
|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
Debugging in QA
Hi,
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
Debugging in QA
Hi,
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
Could anyone please guide me how can I debug a stored proc/ function in
Query Analyzer. and Is it possible to debug a trigger same way?
Thanks1.Make sure debugging
are enabled / installed on the sql server.
2.Trigger deb.: Use a stored procedure that fires the trigger, debug the sp,
that will let you step into the trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Zero.NULL" wrote:
> Hi,
> Could anyone please guide me how can I debug a stored proc/ function in
> Query Analyzer. and Is it possible to debug a trigger same way?
> Thanks
>|||I just want to add what I am facing when trying to debug a procedure
(created on master DB using sa login)
when I start debugging on this procedure in query analyzer, I recieve a
msg box which says:
SP debugging may not work properly if you log on as 'Local System
account'
while SQL Server is configured to run as a service.
You can open Event Viwer to see details.
Do you want to continue?
When I continue with this and execute this procedure by providing
parameter values, I get the print outputs, but procedure execution
doesn't break on break points!!
I am puzzled now how to work around with this? How can I break
execution on break points?
Thanks
debugger question
Is there any good debugger program for SQL 2000 trigger and package?
Never did that to packages, but you can debug triggers if you debug a
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegro ups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
Never did that to packages, but you can debug triggers if you debug a
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegro ups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
Friday, February 17, 2012
debugger question
Is there any good debugger program for SQL 2000 trigger and package?Never did that to packages, but you can debug triggers if you debug a
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegroups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegroups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
debugger question
Is there any good debugger program for SQL 2000 trigger and package?Never did that to packages, but you can debug triggers if you debug a
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegroups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
stored procedure calling a DML which fires the trigger, the debugger
will automagically jump in.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Is there any third party application which can do the debugging?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126593394.406063.45780@.g44g2000cwa.googlegroups.com...
> Never did that to packages, but you can debug triggers if you debug a
> stored procedure calling a DML which fires the trigger, the debugger
> will automagically jump in.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
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...
>
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...
>
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...
>
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...
>
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?
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>
--
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?
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>
Subscribe to:
Posts (Atom)