How to Execute an Operating System Command From Within SQL
Server ?
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 layers of tcp/ip protocol combined of? : Sql server database administration
Explain syntax for disabling triggers?
How many replicas are maintained for each SQL Azure database?
What are null values in ms sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to write a query with a right outer join in ms sql server?
What is the default Port No on which SQL Server listens?
What is sql server english query?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to disconnect from a sql server using mssql_close()?
What is a result set object returned by odbc_exec()?
What are the properties of primary key?
What are the types of indexes?
What is indexed view?
How to convert numeric values to integers in ms sql server?