Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain the properties of a relational table?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is master database? : SQL Server Architecture
Explain security with sql azure?
Why should one not prefix user stored procedures with ‘sp_’?
What do you understand by coalesce in sql server?
What does truncate do?
How to create a new login name in ms sql server?
What is the difference between a view and a stored procedure?
What is the use of stored procedure?
what are the critical issues you have resloved in your company
What is join and name different type of joins?
How to use old values to define new values in update statements in ms sql server?
Scalability, Availability, Integration with internet, etc.)?
What are the key configuration files for sql server reporting services ?
