Welcome to Sign in | Help
in Search

System out of memory

Last post 11-20-2006, 3:13 PM by xmldeveloper. 1 replies.
Sort Posts: Previous Next
  •  11-20-2006, 2:59 PM 942

    System out of memory

    Am rulat un script in query analyser care are intradevar cam multe randuri, de inserturi, si imi da la un moment dat

    System out of memory...este un bug sau are nevoie de mai mult RAM pe calculator?

    de ex. 2 milioane de randuri de tip insert la o memorie de 1G RAM 

    Filed under:
  •  11-20-2006, 3:13 PM 943 in reply to 942

    Re: System out of memory

    Incercati SET NOCOUNT ON inainte de rularea scriptului pentru a stopa afisarea numarului de randuri afectate de fiecare instructiune.
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems