Search results matching tags 'Microsoft' and 'SQL 2005'http://bloggingabout.net/search/SearchResults.aspx?a=1&o=DateDescending&tag=Microsoft,SQL+2005&orTags=0Search results matching tags 'Microsoft' and 'SQL 2005'en-USCommunityServer 2008.5 SP2 (Build: 40407.4157)No Identity Specification on DB Copy in SQL Mgmt Studio?http://bloggingabout.net/blogs/egiardina/archive/2007/08/09/no-identity-specification-on-db-copy-in-sql-mgmt-studio.aspxThu, 09 Aug 2007 18:55:00 GMT813b6dfd-644e-4573-a816-eebab56ba0d0:336699Richthofen<p>So slowly but surely some of our databases are making it from SQL Server 2000 to SQL Server 2005. In that process, some of our databases are moved using the quick &#39;copy&#39; method.&nbsp; Simply right click on the DB in SQL Management Studio, go to tasks, select Copy Database. <br /></p><p>However, on my setup:</p><p>Microsoft SQL Server Management Studio&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;9.00.1399.00<br />Microsoft Analysis Services Client Tools&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2005.090.1399.00<br />Microsoft Data Access Components (MDAC)&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)<br />Microsoft MSXML&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2.6 3.0 4.0 5.0 6.0 <br />Microsoft Internet Explorer&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;7.0.5730.11<br />Microsoft .NET Framework&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2.0.50727.832<br />Operating System&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;5.1.2600</p><p>When moving from a SQL 2000 -&gt; 2005 copy, the new database fails to maintain the &#39;identity specification&#39; as YES on the primary keys of my tables. Subsequently, I had to manually add the identity spec. back on about 10 tables. Lame!</p><p>I wanted to report this bug to Microsoft, but figuring out how to report a bug is like pulling teeth! There&#39;s no general public bug submission form; you can go through their &#39;connect&#39; program but its a huge pain in the ass. If they want to write better software, Microsoft should at least give me a bug report form. <br /><br />&nbsp;</p>