Top Answers

1. Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
   5 votes
2. How can I determine the status of a job?
   3 votes
3. How do you update a table with a large number of updates, while maintaining the availability of the table for a large number of users?
   3 votes
4. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
   3 votes
5. Is it possible to get SQL Server to log into an SFTP and upload a file just by using T-SQL commands, no SSIS?
   3 votes