afaik, there is a difference in Unique and Clustered. When you create unique index you may have 1 NULL values where as you can not have the NULL value in Primary key. So the conclusion is, if you have a unique index/key where in you have a NULL value it wo...

In addition to what Jacob has mentioned their is one more important point I would like to mention and that is, the multiple instances are for "abstracting". Example 1: Consider a scenario where a company have only one SQL box (this really happens in ...

<p>Sujith,</p> <p>SSMA is really a good tool for the migration http://www.microsoft.com/sqlserver/2005/en/us/migration.aspx, a year ago I've used this tool (from Sybase to MS SQL) and have a good experience with this.</p>...

<p>AFAIK, we can not change the key unless we know to convert it to hexadecimal value, if you do - search through the registry in HKLM/Software/Microsoft SQL Server (not recommended though). BTW, why you want to do this!!</p>...

<p>Hi,</p> <p>Yes, it depends on the component that you will be installing and using on your cluster environment i.e. SSIS, Transaction replication you must install MSDTC. I would suggest to refer the article http://itknowledgeexchange.techtarget.com/sql-...