how to show a trigger at OS and Gui level

[Former Member]

We have a SAP system on SQL server 2000.

We want to know if a table has a trigger on it OR not.

Could you help tell how to get this info: either at OS DB level

or R/3 gui level?

Points guaranteed. Thanks!

[Former Member]

Hi Jennifer,

open MMC -> MS SQL Server -> Databases -> <SID> -> Tables -> right click on table -> All Tasks -> Manage Triggers

Is that what you meant?

Regards,

Sven

[Former Member]

Sven:

Thanks!

Could you tell how to

1) view the trigger using a "select * from <table_name> where trigger_name='xxx';

2) view the trigger from an R/3 transaction (SE11)?

I am new to SQL server, so step by step instruction is appreciated.

Thanks again.

[Former Member]

Hi Jennifer,

something like this should do the job:

use <SID>

select * from sysobjects where type = 'TR' and name='xxx'

Please have a look at Books Online and read the documetation of table sysobjects. As far as I know, SAP is not using triggers at all in normal operation (I might be wrong!) on SQL Server. At least I never came across any triggers causing problems. That's why I also don't know how to identify triggers with SE11.

I quickly checked different systems with Basis 6.20, 6.40 and 7.00 and couldn't find any triggers. What are you really looking for (Stored Procedures)?

Regards,

Sven

[Former Member]

Sven:

Thank you so much!

Do you have any document for SAP on SQLserver, I mean the docs

you daily used and created? If so, would you please share? My email

is jennifer_lee2006@yahoo.com.

I am an SAP/Oracle person and just jump into SQLserver.

Best,