all groups > sql server misc > december 2003 >
You're in the

sql server misc

group:

Trigger Problem


Trigger Problem masha
12/14/2003 12:37:09 AM
sql server misc: Hi According to books online you can not write a trigger on system o
temporary tables.
But I want to know Is there any way so that I could write a trigger o
system Table : SysObjects.
Thanking You!
Toee
-
mash
masha@brain.net.p
-----------------------------------------------------------------------
posted via www.WebFrustration.com
Re: Trigger Problem John Bell
12/14/2003 9:41:45 PM
Hi

Not being able to do this is documented in books online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
atedb.chm::/cm_8_des_08_4nxu.htm

You may want to look at:
http://www.lumigent.com/Products/entegra/entegra.htm

Entegra's Unique Benefits

All data access is captured - unlike other approaches, which can miss
access directly against the database, viewing of data, and structural
changes



John

[quoted text, click to view]


begin 666 dot_pfs.gif
M1TE&.#EA"0`)`*(``/___[VEO81:A'M*>V,Q8P```````````"P`````"0`)
M```(*0`!``@@8(" ``('$EBX$&$`AA )0F18<.)"@Q8)',SH<")"@00-?@P(
"`#L`
`
end
AddThis Social Bookmark Button