Post reply

Script Logins

  • April 2, 2011 at 2:08 pm

    #248962

    Comments posted to this topic are about the item Script Logins

  • April 4, 2011 at 6:07 am

    #1306926

    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

  • April 4, 2011 at 7:35 am

    #1306969

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

  • April 25, 2011 at 2:37 pm

    #1315589

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

  • April 25, 2011 at 8:36 pm

    #1315673

    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.

  • May 16, 2016 at 7:17 am

    #1879236

    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