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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-01-10 : 14:55:18
|
| Im trying to exec sp_help_revlogin which works but i want to output that a file on my network each night....is it possible with xp_cmdshell |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 17:53:10
|
| Here's how to do it with xp_cmdshell:Create a table that matches the output of the stored procedure.Then have this run each day:DELETE FROM YourTableINSERT INTO YourTable...EXEC sp_help...Run bcp.exe with the queryout option using YourTable as the query via xp_cmdshell.Tara Kizer |
 |
|
|
|
|
|
sp_help_revlogin