Home Forums SQL Server 2005 T-SQL (SS2K5) 701: There is insufficient system memory to run this query RE: 701: There is insufficient system memory to run this query

  • Assuming the service pack doesn't work have you thought about taking a different route?

    And fair warning I'm not an expert on replication. I know just enough to be dangerous.

    Have you considered just taking & applying a new snapshot?

    Or if you are just working with 1 or 2 tables using BCP or some other method to export the data and just completly overlay the existing data? Again using BCP or BULK COPY or something like that?

    I wouldn't recommend either if it wasn't for the large number of changes you seem to be making already.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]