I have a table like this:
?View Code TSQLCREATE TABLE [dbo].[TestTable](
[TestID] [int] NULL,
[Value] [int] NULL
) ON [PRIMARY]
I populate the table with 50 rows like this:
?View Code TSQLINSERT INTO [Test].[dbo].[TestTable]
The goal is to manipulate the data in a way that the Value column has iterative values from 1 to 50 instead of just values of 1.
Continue reading […] Playing with CURSOR for update […]
I have a server with several SQL Server instances installed on it. Why can’t I connect to all instances of SSIS on my server? I can connect to the default instance, but not to the named instances.
The error I get is:
TITLE: Connect to Server
Cannot connect to MyServerName\test1.
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
Continue reading […] SSIS service does not support multi-instance […]
Today I realized that I had a clustered instance of a SQL Server 2008 R2, which was installed as a Standard edition.
The databases which were about to be moved to that instance were residing on a Enterprise edition test environment, and I know for a fact that they were utilizing some of the Enterprise features.
Continue reading […] Upgrading the edition of SQL Server […]