Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data

There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data.

A Hex on Your Database

RE: Create an ALERT for successful Backup ???

USE MESSAGE 18264 to create the alert!ex:IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Some body run a BACKUP successfuly'))  ---- Delete the alert with the same name.   EXECUTE msdb.dbo.sp_delete_alert @name = N'Some body run a BACKUP successfuly' BEGIN EXECUTE msdb.dbo.sp_add_alert @name = N'Some body run a BACKUP successfuly', @message_id = 18264, @severity […]

RE: Alerts via SMTP

Thanks Martin! I'll check it out. Sandra

RE: What makes a good developer?

Dalecorey, Glad we agree on the outcome of this discussion. And yes, you are right that both intelligence AND logic are needed for a programmer. Does this thread qualify for the longest one?[/qoute] I'm certainly trying to make it the longest one ...

RE: Problems with maintenance job

Hi Allen, quote: This KB seems answer your question. partially is does. I've investigated the code along with the developer. What actually happens in the app is: Someone makes a screenshot and can place this into a VB RTF control in the GUI. Now the RTF is bound to an ADO data control. Hm, all […]

RE: Errors on our production server

Please disregard the last message. Evidently, you need to shut down EM after setting the database to single user mode, then all works fine. Terry