Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't change the start up parameter - "-m;" Expand / Collapse
Author
Message
Posted Wednesday, July 8, 2009 4:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 16, 2010 12:15 AM
Points: 17, Visits: 149
I changed the start up parameters in sql server from multi user to single user mode by including the “-m;” on the advance tab through configuration manager. Now for some reason I cant edit the start up parameters ( I want to remove the “-m;” , it gives me a error).

Has any one run into this issues? Is there any other place that I can fix the start up parameters
Post #749127
Posted Wednesday, July 8, 2009 5:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 28, 2009 11:23 AM
Points: 184, Visits: 166
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuration-manager.html
Post #749168
Posted Friday, July 10, 2009 3:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 16, 2010 12:15 AM
Points: 17, Visits: 149
Thanks , but I didn't find any thing that helped me
Post #750912
Posted Friday, July 10, 2009 3:28 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 13, 2014 12:27 PM
Points: 267, Visits: 386
You can also remove it from registry and recycle SQL Server.

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #750915
Posted Friday, July 10, 2009 5:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
same issue for me... I restarted sql server... NO gain... Pls give address of registry....

Also one question. How can I use BCDEDIT.exe to add /3GB switch?
Post #750960
Posted Friday, July 10, 2009 5:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
How to see what is there in the BCDEdit.exe file? Following link gives information about this file but is not enough

http://www.vistaforums.com/FORUM/Topic587-9-1.aspx
Post #750970
Posted Friday, July 10, 2009 9:25 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\In my it was first instance(MSSQL.1)\MSSQLServer\Parameters\ SQLArg3


MJ
Post #751519
Posted Sunday, July 12, 2009 1:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:05 PM
Points: 386, Visits: 318
have you tried changing it from services.msc or SQL server configuration manager ?
Post #751676
Posted Monday, July 13, 2009 4:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 16, 2010 12:15 AM
Points: 17, Visits: 149
Thanks a lot. This is what i was looking for
Post #751914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse