Re: Insert Into Without Log

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 11:04:32 -0500

I think you are talking about logging, i.e. these events are logged in the
transaction log. For instance a truncate can be rolled back if it is within
the confines of a transaction, even with bulk logged recovery model.

If you are asking about this command not showing up while using profiler you
can't stop it from showing up there, unless your trace is pretty specific. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dario Concilio [MCP]" <dco@experta-spa.com> wrote in message
news:egDf2MPGFHA.228@TK2MSFTNGP15.phx.gbl...
> ok,
> for example when I delete all records in a table without trace in sql
server
> log
> I type:
>
> TRUNCATE TABLE MyTable
>
> My question is:
> In this case? When I type INSERT INTO etc.. and I don't want to trace this
> task in sql server log. What can I do this?
>
> thx.
>
> "Hilary Cotter" <hilary.cotter@gmail.com> ha scritto nel messaggio
> news:%23rWuSGPGFHA.2976@TK2MSFTNGP09.phx.gbl...
> >I take it you are talking about
> > insert into tableName
> > Select * from TableName2
> >
> > if so, not
> > -- 
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> > "Dario Concilio [MCP]" <dco@experta-spa.com> wrote in message
> > news:uteqqhOGFHA.2032@tk2msftngp13.phx.gbl...
> >> Hi,
> >> Can I create an Insert Into Query without sql server registration log?
> >>
> >> Thx.
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: begin and end transaction and transaction log
    ... found to truncate the transaction log is to stop and start the SQL ... If you run with full recovery and want to be table to restore to a point ... Books Online for SQL Server 2005 ...
    (comp.databases.ms-sqlserver)
  • Re: begin and end transaction and transaction log
    ... found to truncate the transaction log is to stop and start the SQL ... If you run with full recovery and want to be table to restore to a point ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • begin and end transaction and transaction log
    ... This is more of an architectural question about SQL Server. ... below that updates a table using begin and end transaction I am unable ... found to truncate the transaction log is to stop and start the SQL ...
    (comp.databases.ms-sqlserver)
  • Re: begin and end transaction and transaction log
    ... to programmatically truncate the transaction log. ... found to truncate the transaction log is to stop and start the SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Single point of failure
    ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)