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 |
|
langkew
Starting Member
5 Posts |
 Posted - 2004-08-30 : 14:55:45
|
| Using BCP and xp_cmdshell can export a table to a text file.But i'am not a rolemember of 'sysadmin',how can i export it to a text file not using xp_cmdshell? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-30 : 14:58:50
|
| You can use DTS to export the data to a file. You don't need permissions to xp_cmdshell for this. Or you could run bcp from the command line. All you need for both is select permission on the table or view.If you need to do this from a stored procedure, you'll need to get access from the DBA. The DBA can use a proxy account for it so that you don't need sysadmin.Tara |
 |
|
|
langkew
Starting Member
5 Posts |
Posted - 2004-08-30 : 15:11:27
|
| Thanks! But i don't know what is a proxy account. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-30 : 15:15:15
|
| Read the remarks section for the xp_cmdshell topic in SQL Server Books Online. The DBA should be able to help you implement it.Tara |
|
|
|
|
|
|
Export a table to a text file with member:db_owner