Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2010-03-02 : 15:12:36
|
| Hi,could any one help to create folder named test into my c: path through sql without xp_cmdshellThanks in advance |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-02 : 15:24:37
|
| i guess u could sp_OACreate to create an instance of the FileSystemObject, Or a CLR routine, but really, SQL is the wrong tool for the job. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-03 : 15:07:17
|
whether there is any possiblity of without xp command?quote:
Originally posted by visakh16
you can use xp_create_subdir extended procedurehttp://www.mssqltips.com/tip.asp?tip=1460------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
create folder ithrough sqlserver