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

Answer Posted / thatiparthi brahma reddy

EXEC Master.dbo.xp_cmdshell 'Dir d:\'

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transactional replication?

712


Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

717


What are transactions and its controls?

796


How to insert and update data into a table with "insert" and "update" statements?

699


How to recover from sql injection? : sql server security

700






What is sql server english query?

743


What is index, cluster index and nonclustered index?

686


How to drop an existing table?

726


Explain what is log shipping?

811


What is triggers and stored procedures?

687


Explain what is lock escalation?

765


Tell me what is sql profiler?

791


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1724


What is difference between clustered index and non clustered index?

796


When we should use @@error?

700