You can get it from system views:

Example:

select

so.name, st.name, sc.text

from sys.triggers st

inner join sysobjects so on st.parent_id = SO.id

inner join syscomments sc on st.object_id = sc.id

where so.name ='<TableName>'

Thanks Wayne, this worked for my scenario. Much appreciated. 🙂

The code needs to identify the columns that have changed. This needs to be a part of a stored proc which receives single security ID as parameter and it retrieves...

Apologies for the confusion, the columns that have changed should be selected dynamically. Requirement is to identify the changed columns for any securityID.

I was able to resolve this error. While deploying the package, in "data sources" in the connection string I added - Password = <my DB password>; and it worked. It...

I tried using proxy account but it didnt work either.

Password to the connection manager is stored there itself. Package configuration is disabled.

The protection level is "Encryt All with password" and the SQL agent services is having - log on as "LocalSystem". This is the first job being created on the server,...

Its embarassing :blush: . Thank you!!

Yes correct. Existing cluster needs to remain untouched and cluster should become active-active.

You can ignore step 1 without effecting anything.

In short, I need to trap errors at line numbers x, y ,z and, if error happens, need to rollback the changes,...

Yes, right.

Yes.

The DB is in SQL server 2000 and need to do through job only, cant do through SSIS/DTS.