May 29, 2003 at 6:32 am
where do you adjust all the major settings in sql? is it done in enterprise manager?
May 29, 2003 at 7:06 am
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?
May 29, 2003 at 7:55 am
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.
May 29, 2003 at 8:24 am
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.
May 29, 2003 at 8:32 am
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"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply