SQL Server Memmory problem
-
I am trying to load a DB up with about 3100 tables of data using C#. Somewhere around table 1770 I get the following message "Microsoft SQL Native Client: Not enough storage is available to complete this operation." Does anyone know how to fix this problem, any help would be greatly appreciated. Thanks in advance, Michael
-
I am trying to load a DB up with about 3100 tables of data using C#. Somewhere around table 1770 I get the following message "Microsoft SQL Native Client: Not enough storage is available to complete this operation." Does anyone know how to fix this problem, any help would be greatly appreciated. Thanks in advance, Michael
Well you are doing something wrong, we load 1000s of table every day, peak is about 2k per hour. There is not enough info to be able to help here. How are you loading the data in, BCP, BulkCopy, 1 record at a time? Is you client having the problem or is it just relaying the error from the server. Have you checked the transaction log size of the server, the event log of the server, the database properties of the server.
Never underestimate the power of human stupidity RAH