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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-02-23 : 09:13:32
|
vinod kumar writes "how to create a os file in sql server,is it possible to create a file from db machine to on other machine.please replay immedeatlyvinod" |
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-02-23 : 09:39:27
|
Do you mean is it possible to move a database os file from one machine to another? If so, yes you can but it's usually safer to backup the database, move the backup file, and then restore the new database onto the differemt server from the backup.Raymond |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-02-23 : 20:21:04
|
Or if you're wanting to create a text file (or some such) from with SQL Server, you might need to research xp_cmdshell. But it really depends on what you want to do with it. Interacting with the OS from withing SQL Server could lead to headaches you don't want. The more info you give us, the more ideas we'll give you.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|