InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:32:29 GMT20http://www.sqlservercentral.com/Forums/Topic1087825-2765-1.aspxI 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. Mon, 25 Apr 2011 20:36:14 GMTgklundthttp://www.sqlservercentral.com/Forums/Topic1087825-2765-1.aspxThis Script is generating all kinds of Syntax Errors both in SQL 2005 and SQL 2008R2! Does anyone faced the same issue?Mon, 25 Apr 2011 14:37:07 GMTsreekanth bandarlahttp://www.sqlservercentral.com/Forums/Topic1087825-2765-1.aspxTrue, thank you, that would eliminate the need for those CTEs. I wish the servers in our environment were all 2008.Mon, 04 Apr 2011 07:35:36 GMTgklundthttp://www.sqlservercentral.com/Forums/Topic1087825-2765-1.aspxJust 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):[code="sql"]SELECT CONVERT(VARCHAR(12), 0x68656c6c6f, 1)--0x68656C6C6F[/code]ChrisMon, 04 Apr 2011 06:07:12 GMTChris Howarth-536003http://www.sqlservercentral.com/Forums/Topic1087825-2765-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/sp_help_revlogin/72817/">Script Logins</A>[/B]Sat, 02 Apr 2011 14:08:52 GMTgklundt