mibuso.com

Microsoft Business Solutions online community
It is currently Sun Oct 26, 2014 12:02 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: [Solved] Easy way to find code behind triggers?
PostPosted: Tue May 01, 2012 1:25 pm 
Offline

Joined: Fri Sep 30, 2005 1:01 pm
Posts: 18
Location: Netherlands
Country: Netherlands (nl)
Hi,

I have a database where some people have written SQL code in triggers of a Navision database.
I want to find out where all this code has been written.
Is there an easy way (script) to list all triggers/tables that have SQL code?

Regards,
Arjan


Last edited by ArjanL on Tue May 01, 2012 4:58 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Easy way to find code behind triggers?
PostPosted: Tue May 01, 2012 2:33 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7993
Location: Flagstaff, AZ
Country: United States (us)
I haven't explored this myself, but a quick google search on "where are SQL triggers stored" gave me this link: http://www.sqlusa.com/bestpractices/findtriggers/

_________________
Daniel Rimmelzwaan
KCP Dynamics
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Easy way to find code behind triggers?
PostPosted: Tue May 01, 2012 4:53 pm 
Offline

Joined: Fri Sep 30, 2005 1:01 pm
Posts: 18
Location: Netherlands
Country: Netherlands (nl)
Got it.
Thanks :thumbsup:


Top
 Profile  
 
 Post subject: Re: Easy way to find code behind triggers?
PostPosted: Tue May 01, 2012 4:59 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7993
Location: Flagstaff, AZ
Country: United States (us)
graag gedaan :mrgreen:

_________________
Daniel Rimmelzwaan
KCP Dynamics
MVP - Dynamics NAV


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: