Import .sql database file through command prompt MS SQL Server 2008

Import .sql database file through command prompt MS SQL Server 2008

Error – system.OutOfMemoryException() while executing a query in sql server 2008

Solution –  Open command prompt Start -> Run -> type cmd press enter
when command promt dialog box opens
Type – Sqlcmd -S [server instance name] -d [database name] -i [filename you want to import]
 
That’s it