How to Execute an Operating System Command From Within SQL
Server ?
- 3 Answers
- 7819 Views
- I also Faced
- E-Mail Answers
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
What are the types of sql server?
How do you size a resultset?
What is Replication?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain what is the function of sql server agent windows service?
What is default constraint in ms sql server?
Why use “in” clause in sql server?
What is the difference between upgrade and migration in sql server?
What is 5nf in normalization form?
What are the difference between primary keys and foreign keys?
Please explain go command in sql server?
Disadvantages of the indexes?
What is BLOCK statements in SQL?
what kind of lan types do you know? : Sql server database administration
How many types of the database links?
