How to Execute an Operating System Command From Within SQL
Server ?

Answer Posted / guest

The xp_cmdshell extended store procedure makes it possible
to execute operating system commands from within SQL
Server.
Example:

EXEC Master..xp_cmdshell 'Dir c:\'

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know the isolation level that sql server support?

744


Do you know what are the reporting services components?

752


What happens if null values are involved in bitwise operations?

840


What is parameterized reports in ssrs ?

127


What new changes are being made in SQL Server?

843


What are the restrictions while creating batches in sql server?

804


Do you know sql server 2008 introduces automatic auditing?

721


What are group functions in query statements in ms sql server?

783


What is co-related sub query?

783


What are the differences between DDL, DML and DCL in SQL?

990


How to return the second 5 rows in ms sql server?

832


What are the different authentication modes in sql server?

867


What is the recovery model? List the types of recovery model available in sql server?

702


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

756


Tell me about pre-defined functions of sql?

907