Script Logins

• gklundt

  Ten Centuries

  Points: 1130

  More actions

  April 2, 2011 at 2:08 pm

  #248962

  Comments posted to this topic are about the item Script Logins

• Chris Howarth-536003

  SSCommitted

  Points: 1775

  More actions

  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

• gklundt

  Ten Centuries

  Points: 1130

  More actions

  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.

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  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?

• gklundt

  Ten Centuries

  Points: 1130

  More actions

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 16, 2016 at 7:17 am

  #1879236

  Thanks for the script.