How to Execute an Operating System Command From Within SQL
Server ?
- 3 Answers
- 7818 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar
If your server is not configured for "xp_cmdshell" command
then at first you need to reconfigure for that. To
reconfigure, execute the following:-
sp_CONFIGURE 'xp_cmdshell', 1
GO
RECONFIGURE
GO
Then execute the following:-
EXEC master.dbo.xp_cmdshell 'Dir c:\'
Regards
Sanjeev kumar
Contact If your problem are still not solved.
thanks
skdeveloper0@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How many types of local tables are there in sql server?
How do I open port 1433?
How to encrypt data between dialogs?
Define model database?
What is named calculation? : sql server analysis services, ssas
What is the difference between stored procedure and functions?
Explain primary key?
What is dml command?
How do you check sql server is up and running?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Suggest a method of joining two tables.
How to list all dsn entries on your local machine using odbc_data_source()?
Explain in details security in SQL azure?
What is an inner join?
When you use @@error and try-catch?
