Re: How to limit the number of sql statements ?

From: rishi (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 14:53:00 -0800

Hi!
We dont have this option in SQL 2000. It is in SQL 7.
Though we have auto shrink option there. I am not sure of
using this option. Moreover currently Tlog is 40 gigs.
Any suggestion?????

Relevant Pages

  • Re: SQL express performens lagg
    ... for 1 client app wich is running on it self... ... as i also said b4 i have tryed other SQL servers with smaler footprint... ... fastes i could get my hans on if i dont want any Fans! ... XPe image incl Express takes op 250Mb og the hdd and starts in aboudt 13 sec ...
    (microsoft.public.sqlserver)
  • Application Role
    ... that is accessing a SQL DB. ... I dont want to set the APplication ... but I would like to somehow implement ... I know that Application Roles dont use Connection Pooling, ...
    (microsoft.public.sqlserver.security)
  • Re: Syntax error in INSERT INTO Statement
    ... I dont know what was wrong in my code ... running the query ... >keep a QueryDef set up as an SPT and stuff it w/ an SQL ... >> OrderHeaderId, OrderDetailId, CreatedDate, CreatedBy)" ...
    (microsoft.public.access.queries)
  • Question about sql job, SQL 7 versus upgrade to SQL 2000
    ... I just realized that I dont need to do anything because ... >I have a server that until yesterday had SQL 7 on it, ... It's a scheduled job to be run each night, ... upgrading to SQL 2000. ...
    (microsoft.public.sqlserver.server)
  • Re: Dataset performance
    ... thanks a lot for your answers but dont forget the scenario, ... extremely important not to process the data on the SQL... ... Alberto Ortega ...
    (microsoft.public.dotnet.framework.adonet)