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. Shut down all instances of Visual Studio.

2. Click Start, the choose Run….

3. Type “devenv.exe /resetuserdata“.

This command will take a couple of minutes to run as Visual Studio cleans up and sets itself back to its original state.

Advertisements

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)