 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / February 2005Insert Into Without Log
Hi, Can I create an Insert Into Query without sql server registration log? Thx. I take it you are talking about insert into tableName Select * from TableName2 if so, not  SignatureHilary 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 > Hi, > Can I create an Insert Into Query without sql server registration log? > > Thx. 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. >I take it you are talking about > insert into tableName [quoted text clipped - 5 lines] >> >> Thx. 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. SignatureHilary 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 > ok, > for example when I delete all records in a table without trace in sql server [quoted text clipped - 18 lines] > >> > >> Thx. 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 SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > ok, > for example when I delete all records in a table without trace in sql server [quoted text clipped - 18 lines] > >> > >> Thx. I see. Then..... Can I type this? BULK INSERT INTO DestinationTable [...] FROM OriginTable WHERE [..] > Dario, > Effectively, you want to turn of logging of logged (inserts) transaction [quoted text clipped - 33 lines] >> >> >> >> Thx. Dario, No, the BULK INSERT syntax only allows "BULK INSERT [ [ 'database_name'.] [ 'owner' ].] { 'table_name' FROM 'data_file' } [ WITH ... various options" - see SQL Server 2000 BOL title "Bulk Insert" for more details... However, what you can do is use "SELECT INTO" and select into a new table as SELECT INTO will only work with new and not existing tables, specifically, SELECT * INTO DestinationTable FROM OriginTable WHERE [..] You can also use BCP.exe and you may want to read "Using SQL Server 2000 Recovery Models" at http://www.devx.com/getHelpOn/10MinuteSolution/16532/1954?pf=true Hope that helps! John SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > I see. > [quoted text clipped - 40 lines] > >> >> > >> >> Thx. Is not there other way? > Dario, > No, the BULK INSERT syntax only allows "BULK INSERT [ [ 'database_name'.] [quoted text clipped - 63 lines] >> >> >> >> >> >> Thx. Dario, Basically, you cannot turn off transaction logging in SQL Server 2000, you can only use the below methods (Bulk insert, SELECT INTO, BCP.exe) to minimally log transactions to the database transaction log. FYI, this question is often asked in other newsgroups, but the answers are the same there... Regards, John SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > Is not there other way? > [quoted text clipped - 65 lines] > >> >> >> > >> >> >> Thx. Thank you. :-) > Dario, > Basically, you cannot turn off transaction logging in SQL Server 2000, you [quoted text clipped - 83 lines] >> >> >> >> >> >> >> >> Thx. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.