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. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], ...

learn more… | top users | synonyms

1
vote
1answer
199 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
1answer
24 views

Remove all references to removed Sql Server database

One of my programs that I have written, creates on installation a SQL Server database. The database name is hardcoded in the sources. Now I have the problem, that on a clients machine the program was ...
0
votes
2answers
15 views

Steps Needed to Install .Net and SQL Express on Windows Server 2012

Please forgive the simplicity of this question, but I work mostly with Linux servers and older versions of Windows Server. My exact question is how are packages installed on Windows Server 20212, ...
0
votes
2answers
5k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the ...
0
votes
1answer
5 views

Can't click on SQL Profiler

I used to be able to launch SQL Profiler from SSMS with no problem, but now when the application starts I can't click on anything. It just dings at me. It's almost like there's a dialog open off ...
0
votes
1answer
3k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
0answers
7 views

What is the best way to archive a large SQL DB table

Question: I am looking for recommendations on how to archive about 80% of the data in a SQL DB table. Software: I am using SQL Server Management Studio on a windows server. Background Info: I have ...
2
votes
1answer
6k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
2
votes
1answer
3k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
0
votes
1answer
76 views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
0
votes
1answer
11 views

How can I determine which SQL db my Access app is pointing to?

There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this? The linked table manager appears to point to something but doesn't give ...
0
votes
0answers
8 views

MS SQL 2012 Express hangs on add DB when you click the files tab

I'm running SQL Express 2012. Sometimes when I'm restoring a DB and click on the files tab to link the DB to the actual files, the management studio just hangs. I manage a large number of small DB's, ...
1
vote
1answer
33 views

Replicated SQL Database Recovery Model

I currently have a number of large databases replicating to secondary servers for reporting purposes. The publication DBs are all in simply recovery as we back these up nightly as that's as much as ...
0
votes
1answer
16 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking ...
0
votes
1answer
66 views

Do i need all of those MS SQL server and MS C++ Redistributable?

Steam has off sale games and i have planned on getting 8 games. With that, i'm starting to prepare my computer to receive those games by cleaning up some useless stuff. Though when i was on "Programs ...
0
votes
2answers
36 views

Buying MS SQL server, confused about CAL needs [closed]

I'm extremely confused as to which version of SQL server to buy... I've found versions for around $599 and then some for around $1,100... Currently we're running Express and only need to upgrade ...
0
votes
1answer
70 views

SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation

I'm on Windows 7 Professional SP1. I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
1
vote
1answer
47 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
1
vote
1answer
13 views

How do I add an AzureAD user to SQL Server for windows authentication

When users are logging in to a Windows 10 desktop with an Azure Active Directory account how do I add them as a user to SQL Server? Using the Search dialog from the Add Login dialog doesn't seem to ...
0
votes
0answers
13 views

Cannot connect to SQL Server 2008 R2 from 3rd party program

I am running SQL 2008 R2 on a pc. I usually connect to a server instance from a 3rd party program all on the same machine, but suddenly I cannot connect. When I try I get message about network ...
0
votes
3answers
10k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
1
vote
2answers
908 views

Where is sql configuration manager in windows 10?

I just have upgraded to windows 10. I can't find sql server configuration manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in All Apps. This is just a picture of ...
2
votes
1answer
521 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
1
vote
0answers
65 views

SQL Server Results to File Creates extra lines at end

When I route the output of my queries to a file, there are one or two blank lines at the bottom. When I run the query though SSMS (2008 or 2012), I get two extra blank lines. When I run the query ...
0
votes
1answer
64 views

Port 80 used by Microsoft-HTTPAPI/2.0

The port 80 is used by Microsoft-HTTPAPI/2.0 and cannot be stopped. I have tried many solutions, but no one worked. Here is what I have done. Also, here is what is on the page : Not Found HTTP Error ...
1
vote
0answers
86 views

Hibernate Entities generated using IntelliJ have no Foreign Keys generated

I have a normalized SQL Server database with 20+ tables on it that created using SQL Server Management Studio 2014. I am able to connect to this database in IntelliJ and follow along with the steps ...
1
vote
2answers
6k views

Windows 10 .NET 3.5 installation

I'm on build 9841 of Windows 10. I downloaded .NET 3.5 SP 1 full. I double click the installer but nothing happens. Is that .NET version not compatible with Windows 10? I need it to install SQL Server ...
10
votes
10answers
28k views

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 ...
7
votes
1answer
10k views

When will SSDT-BI be available for Visual Studio 2015

From Microsoft's download page, SSDT-BI (SQL Server Data Tools Business Intelligence) for Visual Studio 2013 is available but not for 2015. When will Microsoft release SSDT-BI for VS 2015? ...
0
votes
0answers
15 views

Export from SQL server 2008 to Excel 2013 put results on specific cell

I'm using SQL Server 2008 also i have Excel 2013, i have query to return count, and now i'm looking to export the results to excel sheet that "already created" and put the results on specific cell, ...
1
vote
1answer
185 views

How do I allow multiple people to open my Access database?

I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the ...
0
votes
0answers
31 views

Plesk Windows server & MSSQL

I am running Windows Server 2012 R2 with Plesk 12 and SQL Server 2014. Going to : Home -> Tools & Settings -> Services, I can see with green : SQL Server (MSSQLSERVER), SQL Server ...
0
votes
0answers
17 views

How to detect if someone is running perfmon locally or remotely against my server

One of my Microsoft SQL servers is lagging and I'm wondering if someone is running perfmon on it either locally or remotely - how can I detect if someone is running perfmon on the server (either ...
1
vote
0answers
75 views

How to install SQL Server ODBC driver on OSX?

I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error: The ODBC driver that was selected for the source connection ...
0
votes
1answer
34 views

SQL server missing in ODBC

I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0
votes
1answer
69 views

SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only

I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
1
vote
1answer
38 views

How best to check connectivity of web server to database?

Our IT admin is asking for an api endpoint in our web application to use as a health check. The logic in the api should perform any simple database query to ensure that the web server can connect to ...
0
votes
1answer
41 views

Replace a filepath column in SQL with new file structure

I have recently changed the structure of a drive where I keep a lot of my 'estimating' files. The problem is, I use a program that has references to some of those files, in the old structure, stored ...
0
votes
0answers
25 views

Why does SSMS incorrectly report an invalid object name when the object does exist?

Why does SSMS incorrectly report an invalid object name when the object does exist? e.g. the table BinCollectionDay is in the current database And even better, how do I stop the incorrect ...
0
votes
1answer
110 views

SQL Server CTP installer - The application cannot find one of its required files

I have downloaded the exe file to install SQL Server 2016 CTP4. When I run the exe, it gives me the following message: The application cannot find one of its required files, possibly because it was ...
0
votes
1answer
10 views

formating of dates in sql server

This is my query select projectname,CONCAT([Budget Health],[ProjectBaseline0StartDate],[ProjectActualStartDate],[ProjectStartDate]) as budgethealth from [dbo].[MSP_EpmProject_UserView] Output is: ...
0
votes
1answer
7 views

Is SQL Server likely to give errors given this usage profile?

I'm developing a web service using asp.net web api 2 which is to be the owner of my SQL Server database. To simplify things, I'm writing a separate MVC site that is to use the same database, but ...
0
votes
1answer
16 views

Is it possible to get SQL string generated from clicking through UI commands in SQL Server Management Studio?

Ok, so SQL Server Management Studio (SSMS) lets me backup and restore SQL databases, which is pretty awesome an application QA Tester. It allows me to test different starting configurations without ...
0
votes
1answer
32 views

How can I detect the changes in my SQL Server database

I want to know the exact changes in my SQL Server database? Can I see the complete changes in a SQL Database
0
votes
0answers
12 views

Sql Blocked Query automation

I am running a Windows server 2012 standard and SQL Management Studio 2012 on it, i would like to get a dump of all the blocked queries to a excel sheet, if the queries get accumulated (greater ...
10
votes
5answers
26k views

Clean reinstall SQL Server Management Studio

I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well. Then, I installed ...
1
vote
1answer
41 views

Connecting to MS SQLServer from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain ...
0
votes
1answer
286 views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
0answers
6 views

How can you edit the list of servers displayed in the SSMS Connect to Server dialog?

How can you edit the list of servers displayed in the SQL Server Management Studio "Server Name" field of the "Connect to Server" dialog? I've got various old servers that I'd like to remove from the ...
0
votes
0answers
246 views

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...