THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata » sp_helptext   (RSS)
  • A handy search procedure

    I often see questions about searching stored procedures, functions, etc. for specific keywords. Maybe it's an object reference they're looking for, or all of the places where they use built-in functions like GETDATE() (I once had to replace all of these with GETUTCDATE() to cater to servers where we couldn't control the time zone settings). Many ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 6, 2011
  • sys.sp_hexadecimal : A Quasi-System Object?

    In KB #918992 and KB #246133, which describe how to transfer logins between instances, Microsoft recommends creating a user procedure in master called sp_hexadecimal (with no schema prefix, tsk tsk). Since I know there have been a lot of people who have created this procedure in SQL Server 2008 R2 and Denali, in spite of the fact that the articles ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 6, 2011
Privacy Statement