SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char

July 25, 2010 on 8:30 pm | In SQL Authority | No Comments

I just came across very simple error and the solution was even simpler. While concatenating NEWID to another varchar string, I had to CONVERT/CAST it to VARCHAR and I accidentally put length of VARCHAR to 10 instead of 36.

Read the original: 
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char

SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win

July 24, 2010 on 8:30 pm | In SQL Authority | No Comments

Today is the last day to win MSDN subscription on this blog. SQL Server MVP Madhivanan is known name. As there are more than 150 comments, I had requested him to help me out with deciding the winner.

See the original post:
SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win

SQLAuthority News – The story of the world – Spatial Data types – July 24, 2010

July 23, 2010 on 8:30 pm | In SQL Authority | No Comments

Today I will be speaking on the subject of Spatial Database at Community Tech Days at Ahmedabad.

Go here to see the original:
SQLAuthority News – The story of the world – Spatial Data types – July 24, 2010

« Previous PageNext Page »

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^