Whilst trying to do a simple query in Microsoft SQL Server Management Studio e.g.
SELECT TOP 10 * FROM dbo.DatabasePerInstance
I was getting the following error:-
An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'DateAdded'. The GetBytes function can only be used on columns of type Text, NText, or Image.
Thought it was a bit strange as is a really basic type of T-SQL. However I running Management Studio 2005 and this SQL Server I was connecting to was SQL Server 2008 r2.
Run the same version or higher Microsoft SQL Server Management Studio to do the T-SQL. Once I loaded up 2014 Management Studio no more errors.