Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Logins Expand / Collapse
Author
Message
Posted Saturday, April 2, 2011 2:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 16, 2016 2:13 PM
Points: 26, Visits: 140
Comments posted to this topic are about the item Script Logins
Post #1087825
Posted Monday, April 4, 2011 6:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 28, 2016 8:42 AM
Points: 314, Visits: 1,150
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
Posted Monday, April 4, 2011 7:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 16, 2016 2:13 PM
Points: 26, Visits: 140
True, thank you, that would eliminate the need for those CTEs. I wish the servers in our environment were all 2008.
Post #1088045
Posted Monday, April 25, 2011 2:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 354, Visits: 1,762
This Script is generating all kinds of Syntax Errors both in SQL 2005 and SQL 2008R2! Does anyone faced the same issue?
Post #1098291
Posted Monday, April 25, 2011 8:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 16, 2016 2:13 PM
Points: 26, Visits: 140
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
Posted Monday, May 16, 2016 7:17 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:55 AM
Points: 8,101, Visits: 812
Thanks for the script.
Post #1786516
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse