quote:
where do you adjust all the major settings in sql? is it done in enterprise manager?
To change the "major" settings for a DATABASE in SQL Server, use ALTER DATABASE or sp_dboption. BOL has info for these procedures.
HTH,
Jay
ps. Is there a specific setting you are trying to modify?