QUESTION POSED ON: 05 March 2006 How can I encrypt a CSV file using stored procedure in SQL Server 2000?
>
EXPERT RESPONSE
In SQL Server 2000, you would need to shell out to run a command to do this (via xp_cmdshell) or create an extended stored procedure that you call from the code. In SQL Server 2005, you could do this with a CLR stored procedure.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
