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

  1. 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

  1. 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