Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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