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

0
votes
0answers
22 views

SQL queries all taking longer to execute

We have a SQL Maintenance Plan process that runs on Sunday at 6PM, which does the following. Check Database Integrity Rebuild Index Update Statistics Clean Up History We notices Sunday night ...
0
votes
1answer
26 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
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
0answers
9 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 ...
0
votes
1answer
13 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
34 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
70 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
78 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
1answer
79 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
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 ...
1
vote
0answers
66 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
66 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
97 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
959 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 ...
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
0answers
16 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
195 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
32 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
79 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
35 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
71 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
39 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
27 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
114 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
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 ...
1
vote
1answer
42 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
306 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
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
0answers
16 views

Can I simply rename a TDE-encrypted SQL Server database?

I encrypted an SQL Server database using TDE.  What happens when I rename the database?
0
votes
0answers
130 views

Cannot set static IP address using Netsh

I have followed this article to set the following environment: DC: Windows Server 2008 R2 Enterprise (Full Installation) - Domain controller for the lab network, contoso.com SQL-A: Windows Server ...
0
votes
1answer
58 views

Huge amount of virtual size used by sqlservr.exe - is that normal?

I'm checking memory leak on my computer currently, is that the high usage of virtual memory by the sqlservr.exe related
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 ...
2
votes
1answer
53 views

How to load files according to Created Date in Windows command prompt

In SQL Server using xp_cmdshell, I was able to load files according to Modified date using a command for e.g., z: & forfiles /m *.jpg /s /d 07/16/2015 /c “cmd /c echo @fdate @ftime @path” But I ...
0
votes
0answers
247 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 ...
1
vote
1answer
391 views

Sharing a database over the local network

We have some plate nesting software at work which I use daily. Recently, I thought I'd try to get the shared database up and working so the boys in the workshop could use the software on another PC ...
0
votes
1answer
46 views

Rebooting Old Server

I have a question that may be really easy to answer. Our company got a new server a while ago. This server acts as our DNS, SQL, Web, NAS, and Active Directory. We are moving to a new office and I ...
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
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 ...
0
votes
1answer
37 views

How to unlimit the number of simultaneous connections on windows?

How can I make microsoft windows to accept more then 20 connections, I have a microsoft sql server express that seems to be dropping connections after 20 connections. Any sugestions? Windows 2008 ...
0
votes
0answers
35 views

See SQL Server Reporting Services without logging in?

I have installed SQL Server 2015 with SSRS and I have some reports I need to run, but in order to access http://reportsserver/Reports I need to start Internet Explorer in administrator mode. This is ...
0
votes
1answer
67 views

Making a pivot table month filter

I'm trying to compile some reports through an Excel pivot table connected to a MS SQL database. Now the data I'm working with consists of a bunch of dates formated as dd/mm/yy. I want to make a filter ...