We have an server that runs SQL Server 7 on an NT system. One database has
processes running that are not documented. I have written triggers to report
any deletions, inserts or updates made against the database's tables. All I
can report is that an insert, update or delete has occurred, the Date and
Time it occurred, and the table the operation was against.



I have read that temporary/virtual tables are created whenever an insert,
update or delete occurs. I have not found any documentation about these
temporary/virtual tables.



I have not been able to get the logs running. Viewing the logged data should
give me an idea of what actions are taking place. The way that I enabled the
Log Security Events was by Right-Clicking on the registered server and
choosing properties, then clicking on the security tab, and enable 'All'
audit level. To view the logs, in SQL Enterprise Manager-->Management-->SQL
Server logs. I have 6 old logs that span a few hours for a given day. These
days are either late last year and very early this year.



Does anyone have information about the temporary tables or logging an SQL
Server 7? Any would be appreciated. Thanks


--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008

> I have read that temporary/virtual tables are created whenever an insert,
> update or delete occurs. I have not found any documentation about these
> temporary/virtual tables.

You are talking about the inserted and deleted tables. In Books Online, on
the Index tab, type inserted or deleted, you should find their documentation.
They are also listed under triggers.

Linchi

"Daniel" wrote:

> We have an server that runs SQL Server 7 on an NT system. One database has
> processes running that are not documented. I have written triggers to report
> any deletions, inserts or updates made against the database's tables. All I
> can report is that an insert, update or delete has occurred, the Date and
> Time it occurred, and the table the operation was against.
>
>
>
> I have read that temporary/virtual tables are created whenever an insert,
> update or delete occurs. I have not found any documentation about these
> temporary/virtual tables.
>
>
>
> I have not been able to get the logs running. Viewing the logged data should
> give me an idea of what actions are taking place. The way that I enabled the
> Log Security Events was by Right-Clicking on the registered server and
> choosing properties, then clicking on the security tab, and enable 'All'
> audit level. To view the logs, in SQL Enterprise Manager-->Management-->SQL
> Server logs. I have 6 old logs that span a few hours for a given day. These
> days are either late last year and very early this year.
>
>
>
> Does anyone have information about the temporary tables or logging an SQL
> Server 7? Any would be appreciated. Thanks
>
>
> --
> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
>
>
>

and doing so will with SQL7?

--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:25A4AAF2-3A37-42ED-B1AA-8E6C92874C1F@microsoft.com...
>> I have read that temporary/virtual tables are created whenever an insert,
>> update or delete occurs. I have not found any documentation about these
>> temporary/virtual tables.
>
> You are talking about the inserted and deleted tables. In Books Online, on
> the Index tab, type inserted or deleted, you should find their
> documentation.
> They are also listed under triggers.
>
> Linchi
>
> "Daniel" wrote:
>
>> We have an server that runs SQL Server 7 on an NT system. One database
>> has
>> processes running that are not documented. I have written triggers to
>> report
>> any deletions, inserts or updates made against the database's tables. All
>> I
>> can report is that an insert, update or delete has occurred, the Date and
>> Time it occurred, and the table the operation was against.
>>
>>
>>
>> I have read that temporary/virtual tables are created whenever an insert,
>> update or delete occurs. I have not found any documentation about these
>> temporary/virtual tables.
>>
>>
>>
>> I have not been able to get the logs running. Viewing the logged data
>> should
>> give me an idea of what actions are taking place. The way that I enabled
>> the
>> Log Security Events was by Right-Clicking on the registered server and
>> choosing properties, then clicking on the security tab, and enable 'All'
>> audit level. To view the logs, in SQL Enterprise
>> Manager-->Management-->SQL
>> Server logs. I have 6 old logs that span a few hours for a given day.
>> These
>> days are either late last year and very early this year.
>>
>>
>>
>> Does anyone have information about the temporary tables or logging an SQL
>> Server 7? Any would be appreciated. Thanks
>>
>>
>> --
>> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
>>
>>
>>

> and doing so will with SQL7?

They are there so that triggers can operate. They are not there for
performance reasons, if that's what you are implying by ""... If you
want to know more about inserted/deleted you should read up on them in Books
Online.

wasnt implying anything, i was merely asking if books online would with
the temp and virtual tables..

the information has been found and the programmer is reviewing at this
time...

thanks for the assistance..

--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C4A22500.C2B7%ten.xoc@dnartreb.noraa...
>> and doing so will with SQL7?
>
> They are there so that triggers can operate. They are not there for
> performance reasons, if that's what you are implying by ""... If you
> want to know more about inserted/deleted you should read up on them in
> Books
> Online.
>