Comments
Sort by recent activity
Hi, I just submitted the error. Please contact me if there's anything else I can do to expedite your investigation.
Cheers,
Chris / comments
Hi, I just submitted the error. Please contact me if there's anything else I can do to expedite your investigation.
Cheers,
Chris
Thanks folks. I have been using SMS 2008's generate scripts for this. It's a surprisingly well-hidden and poorly documented feature.
I'm surprised it's not requested more often. I need to do this kind of thing all the time, although I may do things in an unusual way.
For the record, I would love to have something that let me select rows from a result set in SMS and automatically generate an insert script for them. Quest Software's Toad for SQL Server almost does this, but their syntax only seems to work with SQL 2010. And since I'm using SQL Prompt I'm much happier in SMS than their tool.
BTW, kudos on your tools. They make my life better every single day (except maybe weekends). / comments
Thanks folks. I have been using SMS 2008's generate scripts for this. It's a surprisingly well-hidden and poorly documented feature.
I'm surprised it's not requested more often. I need to do thi...