manojg
partitioned view is not updatable because a partitioning column was not found
I was testing partitioned views using the following script USE DB1 GO CREATE TABLE [dbo].[employee](...
Date: 04/14/2016
Script Task Editor in SSDT 2012 is crashing : Error 'Microsoft.VisualStudio.Progression.Actions.GetNodeAtSourcePosition'
After all the confusion, I managed to get the database project template appear on my Visual Studio...
Date: 04/11/2014
An error occurred while executing batch. Error message is: The directory name is invalid
I faced the error as mentioned in the title, while executing a query using linked server. The...
Date: 05/09/2013
What version of CLR is used in an executable
- Open Visual studio command Prompt. 2. execute ILDASM.exe. This will open a GUI. 3. From...
Date: 05/03/2013
How to find the .NET versions installed
- open Visual studio tools command prompt 2. execute clrver.exe and you will get the versions...
Date: 05/03/2013
SQL Server connection issues
After installing sql server 2012 along side of sql server 2008 R2, i was not able to connect to the...
Date: 04/08/2013
shortcut to remove empty lines from sql query window
Most of you would have seen that while pasting the result of sp_helptext in query window, it throws...
Date: 11/14/2012