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 CommentsI 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 CommentsToday 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 CommentsToday 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
Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.
Valid XHTML and CSS. ^Top^