Monday, March 3, 2014

Locked from Workspace that you don't have access to


If you have locked files on the Workspace that you cannot access and you want to unlock them, the easiest is to simply remove the workspace. This delete pending changes and locks.






Tuesday, July 2, 2013

The automatically saved settings file 'visual studio 2012\settings\CurrentSettings.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent settings for this session.


I moved my documents from d drive back to c and this is what I got in both Visual Studio 2012 and Microsoft SQL Server Management Studio

---------------------------
Microsoft Visual Studio
---------------------------
The automatically saved settings file 'visual studio 2012\settings\CurrentSettings.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent settings for this session.
---------------------------
OK  
---------------------------




--------------------------
Microsoft SQL Server Management Studio
---------------------------
The automatically saved settings file 'sql server management studio\Settings\SQL Server Management Studio\CurrentSettings-2013-06-06.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent settings for this session.
---------------------------
OK  
---------------------------


To fix it

1. Go to Tools/Options
Management Studio
Visual Studio

2. Go to Environment/Import and Export Settings and change the path to existing one. I've used the path to my documents





Monday, June 10, 2013

Default empty string value for varchar columns in Microsoft SQL Management Studio

To insert empty string as a default value in SQL Management Studio you need to enter ('') (open parenthesis, two apostrophes, and close parenthesis) into 'Default Value or Binding' field.


Thursday, June 6, 2013

Information about Interfaces in C# - what they can have and what not

This is taken directly from C# reference document from Microsoft (I recommend reading it)
  • An interface declaration may declare zero or more members
  • The members of an interface must be methods, properties, events, or indexers
  • An interface cannot contain constants, fields, operators, instance constructors, destructors, or types, nor can an interface contain static members of any kind.
All interface members implicitly have public access. It is a compile-time error for interface member declarations to include any modifiers. In particular, interfaces members cannot be declared with the modifiers abstract, public, protected, internal, private, virtual, override, or static.

Wednesday, May 29, 2013

How to unshelve code in Visual Studio 2012

There are two options to unshelve code from Team Foundation Server in Visual Studio 2012

1. File > Source Control >Find > Find Shelvesets

2. Team Explorer > Pending Changes > Actions > Find Shelvesets

1. Team Explorer
2. Pending Changes

3. Actions

4. Find Shelvesets