Script Logins

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gordon Klundt » Script Logins

Script Logins

Rate Topic

Display Mode

Topic Options

Author

Message

gklundt

Posted Saturday, April 02, 2011 2:08 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 3:42 PM
Points: 26, Visits: 110

Comments posted to this topic are about the item Script Logins

Post #1087825

Chris Howarth-536003

Posted Monday, April 04, 2011 6:07 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 30, 2013 8:03 AM
Points: 266, Visits: 1,025

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

Post #1087993

gklundt

Posted Monday, April 04, 2011 7:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 3:42 PM
Points: 26, Visits: 110

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

Post #1088045

sreekanth bandarla

Posted Monday, April 25, 2011 2:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 2:30 PM
Points: 3, Visits: 174

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

Post #1098291

gklundt

Posted Monday, April 25, 2011 8:36 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 3:42 PM
Points: 26, Visits: 110

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.

Post #1098386

« Prev Topic | Next Topic »

Permissions