Kine’s info (Dynamics NAV and personal topics) : MS SQL 2000http://msmvps.com/blogs/kine/archive/tags/MS+SQL+2000/default.aspxTags: MS SQL 2000enCommunityServer 2008.5 SP2 (Build: 40407.4157)Pay attention to permissions when upgrading DB from SQL 2000 to SQL 2005 http://msmvps.com/blogs/kine/archive/2008/02/06/pay-attention-to-permissions-when-upgrading-db-from-sql-2000-to-sql-2005.aspxWed, 06 Feb 2008 16:06:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1499855kine0http://msmvps.com/blogs/kine/rsscomments.aspx?PostID=1499855http://msmvps.com/blogs/kine/commentapi.aspx?PostID=1499855http://msmvps.com/blogs/kine/archive/2008/02/06/pay-attention-to-permissions-when-upgrading-db-from-sql-2000-to-sql-2005.aspx#commentsStory Today I solved one &quot;mystery&quot; which leads to data loss. But from the beginning... We have upgraded HW and MS SQL to version 2005 on 64bit platform. Everything without problems, because SAN was used, transferring the DB was just Detach/Attach...(<a href="http://msmvps.com/blogs/kine/archive/2008/02/06/pay-attention-to-permissions-when-upgrading-db-from-sql-2000-to-sql-2005.aspx">read more</a>)<img src="http://msmvps.com/aggbug.aspx?PostID=1499855" width="1" height="1">Dynamics NAVMicrosoftMS SQL 2000MS SQL 2005Bug