[Eclipsesql-bugs] [ eclipsesql-Bugs-1672635 ] 3.0.0: unable to run alter trigger on MSSQL

[SourceForge.net <no...@so...>]

Bugs item #1672635, was opened at 2007-03-02 19:30
Message generated for change (Comment added) made by spackers
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1672635&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Edward Rudd (urkle)
Assigned to: Nobody/Anonymous (nobody)
Summary: 3.0.0: unable to run alter trigger on MSSQL

Initial Comment:
When trying to execute an ALTER TRIGGER (or CREATE TRIGGER) statement with sqlexplorer while connected to an MSSQL database I receive the error "ALTER TRIGGER must be first statement of the Batch"

After walking through the sqlexplorer code, and watching the "activity monitor" in MSSQL, I found that sqlexplorer is setting the MAX result count before executing the trigger, thus the resultant SQL sent to MSSQL is

SET ROWCOUNT 100
ALTER TRIGGER dbo.TR_SMyTrigger ON dbo.MyTable
FOR INSERT,UPDATE AS
   IF UPDATE(MyField) BEGIN
     ....
   END

There needs to be a way to NOT set the rowcount when running these kinds of queries.

----------------------------------------------------------------------

>Comment By: spackers (spackers)
Date: 2007-10-19 01:36

Message:
Logged In: YES 
user_id=1335081
Originator: NO

Fixed in 3.5.0-RC2

----------------------------------------------------------------------

Comment By: Edward Rudd (urkle)
Date: 2007-04-18 14:04

Message:
Logged In: YES 
user_id=8488
Originator: YES

https://sourceforge.net/forum/forum.php?thread_id=1618744&forum_id=605856

I wrote my own extension to extract the triggers out.

I found a *workaround*  I have to slightly resize the sql explorer editor
window slightly and then the "limit rows" elements appear (they are hidden
before that for some reason).  then I uncheck the "limit rows" check box.

----------------------------------------------------------------------

Comment By: Austin Morgan (admorgan)
Date: 2007-04-18 13:19

Message:
Logged In: YES 
user_id=872984
Originator: NO

What version of SQLExplorer are you using?  There is not any code for
triggers currently in the repository for MSSQL.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1672635&group_id=132863