Playing with CURSOR for update

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]
([TestID]
,[Value])
VALUES
(1
,1)
GO 50

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.

 

Solution:

One

Continue reading […] Playing with CURSOR for update […]

 

SSIS service does not support multi-instance

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.
——————————
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For

Continue reading […] SSIS service does not support multi-instance […]

 

Upgrading the edition of SQL Server

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.

By

Continue reading […] Upgrading the edition of SQL Server […]