Jeff Moden (5/21/2008)
David Burrows (5/21/2008)
Keep think about submitting something but can't think of anything that ain't already been done 🙁...
I saw one article by a fellow recently. He wrote about a handful of (I thought) very well known undocumented stored procedures like sp_MSForEachTable. Some folks made some pretty nasty comments about writting about something so obvious. But, to those that don't know, it's no so obvious. Sure, people can search for such things, but like all such research, most folks need to know that such a thing even exists before they can do a search.
...
I worked with SQL Server for almost 9 years and while I had "heard" about the sp_MSForEach stored procedures I had never used them and still have not, but the article did provide some ideas on how to use them. There are also some instances where I may use sp_MSForEachTable in the near future and I would have done it by hand if not for this article on "well known" undocumented stored procedures.
As this demonstrates any article published will likely find someone who needed to know what was in it. I look at as, if I provide help to 1 person the time and effort it took to write the article is worth it. Granted I have only written 1, but I did find it quite rewarding.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question