|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Logging Changes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I would like to create a log of any changes made to a
table containing approx. 50 fields.
I've created a trigger using the COLUMNS_UPDATED()
function but continue to get an error. I think the error
is caused by the large bitmask value that the function
requires for a 50-field table.
Can someone offer some advice here.
Thanks,
Paul
| |
| Dejan Sarka 2002-10-05, 9:12 pm |
| Paul,
Have you checked my answer from yesterday before posting the same question
again?
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Paul" <ward_paul@hotmail.com> wrote in message
news:543d01c261dc$735fc1f0$3ae
f2ecf@TKMSFTNGXA09...
> I would like to create a log of any changes made to a
> table containing approx. 50 fields.
>
> I've created a trigger using the COLUMNS_UPDATED()
> function but continue to get an error. I think the error
> is caused by the large bitmask value that the function
> requires for a 50-field table.
>
> Can someone offer some advice here.
>
> Thanks,
>
> Paul
| |
|
| Sorry, but I don't see any nodes ( responses ) assigned to
yesterday's post.
Thanks,
Paul
>-----Original Message-----
>Paul,
>
>Have you checked my answer from yesterday before posting
the same question
>again?
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Paul" <ward_paul@hotmail.com> wrote in message
> news:543d01c261dc$735fc1f0$3ae
f2ecf@TKMSFTNGXA09...
>> I would like to create a log of any changes made to a
>> table containing approx. 50 fields.
>>
>> I've created a trigger using the COLUMNS_UPDATED()
>> function but continue to get an error. I think the
error
>> is caused by the large bitmask value that the function
>> requires for a 50-field table.
>>
>> Can someone offer some advice here.
>>
>> Thanks,
>>
>> Paul
>
>
>.
>
|
|
|
|
|