Comments by BechirBenltaief (Top 2 by date)

BechirBenltaief 4-Jan-15 8:46am View

hi,
you can insert "tp_ListId" value in history table in the same or another database table.
for the value, i think the type of "tp_listId" is GUID, so you can't predict his value.

to find the insert value of "tp_listId" add in your trigger "select tp_listId from INSERTED"

hope that help
Bechir.

BechirBenltaief 4-Jan-15 8:40am View

hiyou will find "sql server configuration manager" as program.
type SQLSERVERMANAGER9.msc
or search for it in your installed programs

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid