Re: How to limit the number of sql statements ?

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 05:55:02 +0530

hi rishi,

SQL Server 2000 implemented recovery models which were equivalent of setting database options
like 'trunc. log on chkpt' and 'select into/bulkcopy' . To see this compatibility visit
following url.

check section "Recovery Models and Database Options"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_bckwd_3vlc.asp

If you are using sql 2000, then you will have to change the recovery model of the database to
simple. 

-- 
Vishal Parkar
vgparkar@yahoo.co.in

Relevant Pages

  • Re: Write query to find Recovery Model...
    ... > "Brett Davis" wrote in message ... >> Is there a query that i can write to find out the recovery models for all ... >> my system and user databases on my server? ... >> I am using SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
  • Re: dts & transaction logging
    ... "Allan Mitchell" wrote: ... Because the DB is SQL Server 7 did you mean to specify these options select into/bulkcopy and trunc. ... Recovery models came in for SQL Server 2000 IIRC. ... Was this hint already available for the SQL7 bulk insert DTS task? ...
    (microsoft.public.sqlserver.dts)
  • Re: Boss wants me to program
    ... It allows you to create GUI apps that can work with a variety of database options, such as Access or MS SQL Server. ...
    (comp.lang.python)
  • Re: How to limit the number of sql statements ?
    ... >SQL Server 2000 implemented recovery models which were ... equivalent of setting database options ... To see this compatibility visit ...
    (microsoft.public.sqlserver.mseq)
  • Re: changing recovery model
    ... It is NOT necessary to cycle the server when changing recovery models. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)