Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain sp_configure commands, set commands?

Answer Posted / bhasskar

sp_configure :
The xp_cmdshell option is a server configuration option
that enables system administrators to control whether the
xp_cmdshell extended stored procedure can be executed on a
system.
—- To allow advanced options to be changed.

EXEC sp_configure ’show advanced options’, 1

GO
—- To update the currently configured value for advanced
options.

RECONFIGURE

GO

—- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

—- To update the currently configured value for this
feature.

RECONFIGURE
GO
SET:
This command is used to set the values to the variables
ex:
declare @id int
set @id=2




Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between insensitive and scroll cursor?

1161


What are the different types of data sources in ssrs?

196


Explain error handling in ssis?

1025


Why SQL Agent is used?

1153


Can two tables share the same primary key?

928


Where to find ntwdblib.dll version 2000.80.194.0?

962


What do we need queues in sql service broker?

1065


What is difference between count (*) and count 1?

930


What are the steps you will take to improve the performance of a poor performing query?

979


Which are the new data types introduced in sql server 2008?

881


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1035


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111


Why normalization is used?

1013


Explain the properties of subqueries in sql server?

1082


How many columns can we include on clustered index ?

991