trigger priority orders

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

trigger priority orders

Postby dineshasanka » Fri Dec 01, 2006 10:58 am

trigger priority orders are not documented
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby david connell » Mon Dec 04, 2006 10:56 am

Hi there,
Thanks for the comment. I will see what we can do for the V1.1 release.
Regards
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Postby david connell » Mon Dec 11, 2006 12:26 pm

Hi there again,
After re-reading the code. I believe that that the trigger order is documented. (However only ordered triggers are documented.) I will change the next version to always document the order even if it's none. If I have missed the point etc please tell me.
Regards
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Postby dineshasanka » Mon Dec 11, 2006 12:32 pm

I can't check this as SQL Doc has expired. I got a licence key but it has expired. any reason
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby david connell » Mon Dec 11, 2006 12:42 pm

Hi there,
Are you using the Beta version?
(This product had no registration, but only a limited life-span). If you are using the Beta version then please un-install it and install the new version.

Otherwise please email the sales team, with your problem & licence key, they will be able to explain what product(s) the key unlocks etc. If you have any problems then please email me (david.connell@red-gate.com) with your details and I will find out on your behalf.
Regards
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Postby dineshasanka » Mon Dec 11, 2006 12:46 pm

my version is 1.0.0.0 is it beta?
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby david connell » Mon Dec 11, 2006 1:38 pm

Hi,
It does sound like it. How did you find out the version number please?
I tend to use Windows Explorer
Go to the installation folder, eg:
C:\\Program Files\\Red Gate\\SQL Doc
Right click on the file RedGate.SQLDocumentor.UI.exe, select properties.
Then select the Version tab and read the "File version:".
Regards
David
(Mine says 1.0.0.657)
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Postby dineshasanka » Mon Dec 11, 2006 1:42 pm

I got from the Check for Updates. in you method it will be
1.0.0.551
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby david connell » Mon Dec 11, 2006 1:59 pm

Yes I think so.
Please uninstall SQL Doc and then download the SQLPrompt bundle..
Here is the link.
https://www.red-gate.com/dynamic/downloads/downloadform.aspx?download=sqlprompt
The downloaded zip file will contain a copy of the SQL Doc installer.
Let us know how it goes.
Best regards
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Postby dineshasanka » Tue Dec 12, 2006 1:13 pm

now my version is 1.0.0.657

but I am not seeing trigger priority which were set by sp_settriggerorder
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby david connell » Wed Dec 13, 2006 3:27 pm

Hi there,
Is it possible for you to send me a snapshot of your database and the name of the trigger that does not show the priority please?
My email address is david.connell@red-gate.com
Regards
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 1 guest