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

I can reach at : durgacharanojha@yahoo.co.in

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.