Article ID: 849642 - View products that this article applies to.
I have incorrectly set the memory setting in SQL Server and now the service will not start. What is the option to start SQL Server at the Command prompt of the server using the default memory settings?
Type in the following line at the Command prompt of the NT SQL Server:
sqlsrvr -c -dc:\sql60\data\master.dat -f
(where "-d" is the pathname to the master database)
You could also add these parameters using the Services window within the Control Panel, then start the MS SQL Server service.
This article was TechKnowledge Document ID: 1637
Article ID: 849642 - Last Review: October 15, 2011 - Revision: 3.0