Monthly Archives: March 2011

Restore Visual studio its original state

Some times Visual studio environment settings and customizations not working properly due to the Corrupted window layout file, corrupted menu customization file, or corrupted keyboard shortcuts file. To restore the visual studio its original state follow the below steps. 1. … Continue reading

Posted in Articles | Tagged , | Leave a comment

Create a unique key that is case sensitive

To apply case sensitive on particular column we modify the column below way. ALTER TABLE mytable ALTER COLUMN mycolumn VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CS_AS After create constraint on column ALTER TABLE MYTABLE ADD CONSTRAINT UK_MYTABLE_MYUNIQUEKEY UNIQUE NONCLUSTERED (MYCOL)

Posted in Uncategorized | Tagged , | Leave a comment