Super User
Super User

Questions tagged [ms-sql]

Use this tag for questions related to the MS SQL Server, the management relational database by Microsoft. Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. Do not confuse it with [mysql], the Oracle's one. Tag questions specific to a version with [sql-server-2012], [sql-server-2008]...

The MS SQL Server is a management relational database created by Microsoft.

Which tag
Use the tag for questions related to the MS SQL Server, the database management relational database created by Microsoft.
Tag with the question related to each database server that implements SQL (Structured Query Language) and is not specifically related with the Microsoft version.
Tag specific questions with the relative specific version tag , ...

In brief

Microsoft released many different editions of Microsoft SQL Server, aimed at different audiences and for different workloads. It represents two (SQL Server and SQL Server Compact) among the 59 relational database management systems reported by Wikipedia comparison page in the October 2015 [1].

It is reported [2] that it uses T-SQL and ANSI SQL as its primary query languages.

Where to learn more:

Related tags

  • For the Structured Query Language.
  • For the an Open Source database now owned by Oracle.
  • For each database server that implements SQL (Structured Query Language) and is not specifically related with the Microsoft one.
  • For the version of the PostgreSQL Global Development Group.
  • ,,... for the specific version ones.
92 questions
23
votes
16 answers

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This happens even when nobody else is accessing the…
Andrew J. Brehm
  • 5,342
12
votes
1 answer

Additional User Account, Windows Authentication in SQL Server Management Studio

I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management Studio. We have always used windows…
James Dunn
  • 243
6
votes
3 answers

How to mute windows beep sound in SSMS 18.5 everytime you tab in the table designer?

FOUND THE ISSUE: Seems it's not a known bug and I've reported it on their Uservoice. This seems to happen only on SSMS 18.3.1 onwards up to SSMS 18.5. On SSMS 18.2 and lower the issue does not happen. Thanks everyone! Original text: Each time I use…
DARKGuy
  • 268
5
votes
2 answers

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. this is my…
mbrc
  • 151
5
votes
1 answer

Compiling PHP 7 with mssql support

So I'm trying to switch to PHP 7. Unfortunately I'm in need to connect to an MSSQL Server so I'll need the dblib driver for pdo. With PHP5 you could ust the php5-sybase Package. So I tried to do it manually following this "Guide". freetds compiled…
Shaeldon
  • 101
4
votes
3 answers

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
fluf
  • 211
3
votes
0 answers

Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014

OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. I've done that several times and I still get the…
John Schultz
  • 300
3
votes
0 answers

How do I make a dump of a MS SQL database using SQuirreL SQL?

Unfortunately I cannot use Microsoft's database tool to access my MS SQL server, so I need to use another tool like SQuirreL SQL. How can I make a backup (i.e. dump) of the database?
clamp
  • 1,282
3
votes
2 answers

Can I add Maintenance Plan in SQL Server for Linux?

I am using SQL Server 2017 for Linux, and the Maintenance Plans are missing from the Management menu. Does anyone knows if the Maintenance Plans are available for SQL Server for Linux? I can't find anything related to this topic.
theofilis
  • 133
3
votes
1 answer

PowerShell SqlServer module only imports functions and aliases, but no cmdlets

I am trying to use the SqlServer PowerShell module, available on the PowerShell Gallery. After installing, either to -Scope CurrentUser or in an admin session, doing Import-Module SqlServer only results in three commands being imported into the…
NReilingh
  • 5,883
3
votes
1 answer

Dbeaver export result set to multiple CSV files

I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than one huge, unmanageable file with 24 million lines…
jaydel
  • 131
3
votes
1 answer

Convert DateTime with Decimal Time Longer Than 3 digits?

I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT. CSV fields get imported as VarChars and I'm trying to specify the datatypes. In the data provided in…
Ƭᴇcʜιᴇ007
  • 113,841
2
votes
1 answer

How to pick rows in MS SQL based on column values?

I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a group then need to consider all the values. Sample…
Tech Sawy
  • 21
2
votes
1 answer

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: 39262.3631094907. When I use Excel's date format it comes up…
THill1981
  • 165
2
votes
0 answers

Cannot load riched20.dll into memory

In WindowsXP 64bit while installing MSSQL 2008 installation terminates showing error message "Cannot load riched20.dll into memory..." How to fix it?
Bakhtiyor
  • 940
  • 6
  • 22
  • 35
1
2 3 4 5 6 7