SQL 6.5 Before Update trigger
I have an ASP app which I am using a table trigger to track updates with.
I am able to track the updates successfully, but I am unable to get the
update table to show the row state BEFORE the UPDATE and AFTER the UPDATE
as it should. I dont think its a syntax problem with my trigger. I am
wondering if this method is even supported in 6.5.
I cant find any info on this at all. MSFT - in a push to force everyone
to upgrade - has removed all support documentation for MSSQL 6.5 from its
site - sans the How Tos and Troubleshooting guides for an upgrade to 2K.
Does anyone have any idea? Any comments are appreciated.
Thanks
[680 byte] By [
Terry] at [2007-11-9 17:49:16]
# 1 Re: SQL 6.5 Before Update trigger
You might want to take a look at Sybase information as SQL server 6.5 more
or less bought from Sybase. Perhaps they have some information that can
lead to your answer.
"Terry" <snakbrat@yahoo.com> wrote:
>
>I have an ASP app which I am using a table trigger to track updates with.
> I am able to track the updates successfully, but I am unable to get the
>update table to show the row state BEFORE the UPDATE and AFTER the UPDATE
>as it should. I dont think its a syntax problem with my trigger. I am
>wondering if this method is even supported in 6.5.
>
>I cant find any info on this at all. MSFT - in a push to force everyone
>to upgrade - has removed all support documentation for MSSQL 6.5 from its
>site - sans the How Tos and Troubleshooting guides for an upgrade to 2K.
>
>Does anyone have any idea? Any comments are appreciated.
>
>Thanks
>
Q*bert at 2007-11-11 23:17:09 >
# 2 Re: SQL 6.5 Before Update trigger
The SQL Server Books Online documentation ships with the database. Look on
your CD to find and install it.
"Terry" <snakbrat@yahoo.com> wrote in message
news:3e78da60$1@tnews.web.dev-archive.com...
>
> I have an ASP app which I am using a table trigger to track updates with.
> I am able to track the updates successfully, but I am unable to get the
> update table to show the row state BEFORE the UPDATE and AFTER the UPDATE
> as it should. I don't think it's a syntax problem with my trigger. I am
> wondering if this method is even supported in 6.5.
>
> I can't find any info on this at all. MSFT - in a push to force everyone
> to upgrade - has removed all support documentation for MSSQL 6.5 from its
> site - sans the How Tos and Troubleshooting guides for an upgrade to 2K.
>
> Does anyone have any idea? Any comments are appreciated.
>
> Thanks
>
