RE: Manage TRIGGER on BLOBs Field
From: PaoloRi (PaoloRi_at_discussions.microsoft.com)
Date: 11/29/04
- Next message: Wayne Snyder: "Re: How to store HTML code in SQL server table"
- Previous message: Tom Moreau: "Re: SELECT by quarter of hour"
- In reply to: Mike Epprecht (SQL MVP): "RE: Manage TRIGGER on BLOBs Field"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 04:41:03 -0800
Thank's Mike for your answer, but i have one more question:
1)I saw Instead Of but I don't know if I should make this trigger on the
view or on the table,
2) I have not found any examples on Instead of for Blobs field...do you have
some about them...
Thank's again
PaoloRi
"Mike Epprecht (SQL MVP)" wrote:
> Hi
>
> TEXT and IMAGE data type fields have the following rules in Triggers:
> 6.5 compatability mode: Null is returned
> 7.0 compatability mode: Not allowed
> 8.0 compatability mode: Only available in INSTEAD OF triggers and not in
> AFTER triggers.
>
> 8.0 is the default mode for SQL 2000 databases.
> This is documented in BOL under Creating Triggers.
>
> See if INSTEAD OF triggers will work for you (see BOL)
>
> Regards
> Mike
>
> "PaoloRi" wrote:
>
> > Hi,
> > Does somebody know how to make AUDIT with TRIGGER on BLOBs FIELD?
> > Thank you for your help
> > PaoloRi
- Next message: Wayne Snyder: "Re: How to store HTML code in SQL server table"
- Previous message: Tom Moreau: "Re: SELECT by quarter of hour"
- In reply to: Mike Epprecht (SQL MVP): "RE: Manage TRIGGER on BLOBs Field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
