setting in sql

Question

setting in sql

matt1

SSCommitted

Points: 1784
More actions
May 29, 2003 at 6:32 am

#58498

where do you adjust all the major settings in sql? is it done in enterprise manager?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jpipes SSChampion Points: 12230 More actions · Answer 1

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?

matt1 SSCommitted Points: 1784 More actions · Answer 2

i wanted to see if database roles and server roles had a menu to do selection. ie any kind of control settings that use a GUI.

matt1 SSCommitted Points: 1784 More actions · Answer 3

i have been going through the master database trying to see what all the tables do. like the system messges table has 4333 different kinds of sql messages that can be displayed.

jpipes SSChampion Points: 12230 More actions · Answer 4

Don't mess with the system tables. Enterprise Manager has a GUI for modifying server logins and roles, and database users and roles. Click to the Server --> Security --> Logins for Server Logins. Click to the Database --> Users for Database Users. Right click on the Database and select Properties. Then click through the tabs in the Properties dialog box, including the Options tab for an editable view of the database "settings"