So, what is mean?

Long story short,
a table without a clustered index is called Heap. But you can also add non clustered index without a primary key.

You can list all heap tables with the following script.

SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes AS IDX ON TBL.object_id = IDX.object_id AND IDX.type = 0 ORDER BY TableName

and

SELECT TOP 1000 o.name, i.type_desc, o.type_desc, o.create_date
FROM sys.indexes i
INNER JOIN sys.objects o
ON i.object_id = o.object_id
WHERE o.type_desc = ‘USER_TABLE’
AND i.type_desc = ‘HEAP’
ORDER BY o.name
GO

--

--

The full error can be seen in the screenshot below :

The issue is caused by something to do with the value that is returned by default in the configured Named pipes. Firstly,

– Open SQL Server Configuration Manager
– Branch out SQL Server Network Configuration
– Click on the Protocols for your instance.
– In the right-hand pane, right-click on Named pipes and then click properties.

– Change the value in the field Pipe Name to

\\.\pipe\sql\query

Click ok. Then restart the SQL Instance. You should now be able to connect to the instance.

--

--

Alim Dogan

Alim Dogan

16 Followers

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.