Questions tagged as 'ssms'

1
answer

The class does not support aggregations (or the object of the class is remote) (HRESULT exception: 0x80040110 (CLASS_E_NOAGGREGATION))

In the PC that I develop has a Windows 10 OS, I installed some time ago VS2013, SQL Server 2008 R2 Express and SQL Server Management Studio (for issues of clients that work with this version of the DB). I'm trying to generate a query to a tab...
asked by 16.12.2015 / 23:23
1
answer

How can I export data from a table separated by; instead of,

Hello, I am trying to export a table but automatically exporting it as a field terminator ',' and what I would like to follow is that the field separator is ';'. For this I am using a stored procedure. What I get is: Part_Number, Too...
asked by 05.01.2018 / 07:16
1
answer

SQL AUTO-INCREMENT in SSMS

I have exported a PhpMyAdmin database. When I open the document that I generated when exporting with Microsoft SQL Server Management Studio , it shows me the queries of all the tables and data in the database (so far). Since some of the instr...
asked by 18.05.2017 / 17:56
1
answer

Error starting SQL Server Management Studio 2012

I have a problem with SQL SERVER 2012, the inconvenience is that when I open it, it sends me an error that tells me that it stopped working as if some process was working, the strange thing is that it was working and from nothing it started to t...
asked by 18.07.2017 / 00:43
1
answer

remote connection to SQL Server 2017

I have a problem connecting remotely to SQL Server. I have the following: A Windows 2012 R2 server, with SSMS 2017, and with SQL Express Edition. A database, called Test, and the instance is SQLExpress. I also have remote access enabled,...
asked by 15.08.2018 / 21:05
2
answers

SQL Server Management Studio color in keywords

Good morning: I have installed the Microsoft SQL Server Management Studio 2016 version 13.0.15900.1 and even though I'm looking for it, I can not get the keywords to be in a different color. I read that I had to enable the Intellisense but I hav...
asked by 04.04.2017 / 15:40