When in MS SQL server and you need to find some text in a stored proc, but you have 100’s of them, what do you do?
Came accross sp_findtext when searching for an issue today. I was doing maintenance on an app I hadn’t looked at in over 18 months.
sp_findtext
Tags
agile art ascii art atti book c# conference conferences Confreaks Dreamhost git google goruco LARuby larubyconf09 Linux microsoft mips o'reilly os x personal brain prorubyconf08 publishing quote rails release Ruby rubyconf rubyconf2008 ruby hoedown ruby on rails ruby user group Second Life slc.rb smidig software development sparc sql subversion travel tweet video web wordpress YELLOWPAGES.COMArchives
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- December 2007
- November 2007
- August 2007
- July 2007
- June 2007
- April 2007
- March 2007
- January 2007
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
-
Pages
Meta
-
sp_findtext
Posted by CobyR on January 17th, 2007sp_who, sp_who2, and sp_who_3
Posted by CobyR on September 17th, 2006I have used sp_who and sp_who2 frequently as a DBA on Microsoft SQL servers. I came across sp_who3 a year or so ago, and have used it since. It’s a handy sproc to have when working on MS SQL 2000.
sp_who_3 : an enhanced and efficient version of sp_who
It’s always the little things…
Posted by CobyR on July 13th, 2006I’m getting over more hurdles in Ruby. The amount of material on the web regarding Ruby and RoR is great, but some of the simplest things seem to take me the longest to figure out.
Using Ruby to import data from some Excel spreadsheets on Windows, things are going great the win32ole automation is straightforward, [...]
New Server
Posted by CobyR on June 24th, 2006I left Vehix.com in October of 2005, however due to my four years there, and the good relationships I have had with many people there, I have continued to host my site on one of the play servers used by the technology team. That has all ended, I now have my own server up [...]