Re: How to limit the number of sql statements ?

From: Rishi (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 13:30:17 -0800

Thanks Buddy!!!!!

>-----Original Message-----
>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: 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: 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: 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)