Re: Insert Into Without Log

From: Dario Concilio [MCP] (dco_at_experta-spa.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 17:31:33 +0100

I see.

Then..... Can I type this?
BULK INSERT INTO DestinationTable [...]
                                    FROM OriginTable
                                    WHERE [..]

"John Kane" <jt-kane@comcast.net> ha scritto nel messaggio
news:ui2kkiPGFHA.428@TK2MSFTNGP15.phx.gbl...
> Dario,
> Effectively, you want to turn of logging of logged (inserts) transaction
> in
> the database log. Correct?
> If so, then the answer for INSERTs is no. There will always be a certain
> level of logging of logged (insert, delete, update) in the database
> transaction log, however, you can minimize this via setting the database
> recovery model to "bulk insert" and then use BULK INSERT to insert data
> into
> your (large?) table to minimize the growth of the transaction log...
>
> Hope that helps,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
>
>
> "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: ISA Connection to SQL Logging DB Drops
    ... troubleshooting logging issues: ... Starting Saturday the connection between ISA and the SQL DB ... > I check the SQL Database to make sure the USERID is good and that the ISA ... I then go over to the ISA storage server console and the the ...
    (microsoft.public.isa)
  • Re: Simple transaction question ????
    ... in SQL data base through store procedure or function but then sounds more ... 1- I am not used to the SQL syntax in SQL server side, ... 2- Before storing those data in other database table, ... if you have to manage transaction that spawns a single database then ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [fw-wiz] Protocol inspection
    ... There are a couple products aiming at that space. ... Basically, it's an SQL ... layer with a limited set of transaction options. ... state is stuffed into the database and a single page-view results ...
    (Firewall-Wizards)
  • Re: dataadapter.Update() multiple table update strategies
    ... not much on HOW to submit a massive update to a transaction sproc. ... block with all the needed SQL. ... Am I supposed to not do SQL joins, but instead pull my whole database ... Or should I create multiple data adapters for each SQL table UPDATE I need ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Insert Into Without Log
    ... level of logging of logged in the database ... transaction log, however, you can minimize this via setting the database ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)