Script Logins

  • Comments posted to this topic are about the item Script Logins

  • Just a reminder that in SQL Server 2008 onwards you can use the following to represent a binary value as a character string (rather than a CTE or sp_hexadecimal):

    SELECT CONVERT(VARCHAR(12), 0x68656c6c6f, 1)

    --0x68656C6C6F

    Chris

  • True, thank you, that would eliminate the need for those CTEs. I wish the servers in our environment were all 2008.

  • This Script is generating all kinds of Syntax Errors both in SQL 2005 and SQL 2008R2! Does anyone faced the same issue?

  • I have had errors with non-default collations or trying to create the procedure in a database in 80 compatibility. Hard to guess without knowing the errors.

  • Thanks for the script.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply