-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Star_Venkat
Message 1 in Discussion
sp_configure: This is used to set or displays the global configuration
settings for the current server. If you want to set these configurations at
database level we have to use Alter database statement. Syntax: Exec
sp_configure 'Option Name','value' Example:
[code]
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
[/code]
Now, in the above query we have set the option as 1,So that, we are asking the
server to display the advanced options. The return type is O or 1. Now for
immediate effect, we have to run 'reconfigure' statement.
[code]
Reconfigure
exec sp_configure [/code] The above query will display all the advanced
options located in our server machine. Scenario: Suppose i want enable the
clr in my sql server then its considered as an advanced option and we have to
enable it using sp_configure command. To achieve the task, execute the below
query,
[code]
exec sp_configure 'clr enabled',1
[/code] Regards,
Venkatesan Prabu. J
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
