Anil Singh | Code-sample.com

Hello everyone, I am going to share an interesting and very challenging task. Today's I execute a SQL Script in my SQL Server 2012. This SQL script have data around 5GB. Actually, script contain the schema and data both. When I executing this script in the Transact-SQL , I getting an error.  The error is   " Cannot execute script. Insufficient memory tocontinue the execution of the program. "  I tried so may type of mechanism to resolve and now, I finally resolved this issue. Steps are as given below. 1.        Open the cmd.exe as Administrator. 2.        Create the Documents directory. 3.        Put your SQL Script  file in the documents folder. 4.        Type the query with sqlcmd, server name, database name and script file name as like below T-SQL query. Transact-SQL command Query       ...