In a few posts about debugging in Whidbey, I have asked questions that were responded to in my comments with one magic word “Visualizers”. Watch for an upcoming MSDN article by the Program Manager for the debugging team, Scott Nonnenberg. Apparently bits and pieces of it are in the PDC release but undocumented.
Also, you should be able to see some of this magic in the Advanced Debugging Techniques session from PDC which I have to invent some extra time to watch myself.
The long way is “Web Services Enhancements”.
The short way is “whizzy”
After this morning’s horrorshow* , I think I’ll just go back to my old fashioned method of creating scripts and the running them on the production sql server rather than trying to get fancy again and export them.
*that’s a “Clockwork Orange” reference by the way for all you youngsters! 🙂
I was just exporting some brand new sprocs from my dev sql server to my production sql server.
When doing it, I got an error and when I looked at the error it said that it couldn’t drop a particular TABLE for some reason.
I wasn’t dropping tables! What is it doing? Egads!
Now I have to go through the application to make sure that nothing got whacked (yes we have backups every 6 hours..)
update: yes tables got dropped … thank goodness for our backups (every 6 hours). Though I explicitly only chose sprocs as objects to be exported, we still have figure out WHY this happened. Big thanks to my friend and SQL Server Guru, Roman Rehak! And I should probably go to the local SQL Server User Group meeting tomorrow night – the topic is BackUp and Restore!!