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], [sql-...

learn more… | top users | synonyms

0
votes
0answers
25 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, ...
2
votes
1answer
1k 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
41 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
18 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
197 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
117 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
147 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
95 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
85 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
72 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
292 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
11 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
13 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 than)>...
1
vote
1answer
75 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
1k 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
8 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
18 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
20 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?
1
vote
1answer
500 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
82 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
74 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
318 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
778 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
49 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
53 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
1
vote
3answers
19k 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
50 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
53 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
117 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 ...
10
votes
1answer
19k 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? https://...
0
votes
0answers
61 views

RDP, IIS, SQL Server no longer working

Remote desktop, as well as SQL Server 2008 R2, as well as IIS 7.5 have all mysteriously stopped allowing connections via my local network. Originally, I thought that this could be the result of a root ...
0
votes
0answers
241 views

How to port forward through two routers in a network

I am trying to connect my SQL server through public network. So, I am having lots of problem in understanding it. One router is AirOS's(Outside my house) another is Iball's Baton(Inside my house). ...
0
votes
1answer
395 views

Compatibility between Windows 7 and Windows 10. [closed]

I receive the free update from Microsoft for Windows 10. At the moment I'm using Windows 7 Ultimate. I have several question, for which I can't find anything in google or at least my search words was ...
0
votes
0answers
27 views

Error When Logging In

I am able to log in with Windows Authentication, but my user account does not have any permissions to perform the operation (e.g. Exec, grand, alter, create…etc). Even though I am not able to create ...
0
votes
0answers
86 views

Unable to open SSMS from run window

I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012. For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
0answers
22 views

How do you create a sql 2014 cluster disk for a cluster across multiple hyper-v machines

I have an SQL 2014 cluster spread across multiple physical machines running Windows Server 2012 and Hyper-V. I'm attempting to install Skype for Business 2015. However the install script appears to ...
3
votes
1answer
51 views

Images Stuck on Server

I've run into a strange problem with images being "stuck" on the server. The problem began when I uploaded an updated picture via FTP (I use Cyberduck for Mac) to override the picture. This didn't ...
0
votes
1answer
255 views

Error Installing Windows SQL Server on Windows Server 2012 R2

I have been completely unable to install Windows SQL Server Express on Windows Server 2012 R2. Every time, I get: TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: Wait ...
1
vote
1answer
241 views

Crystal Reports Dynamic Parameter

Help someone. I have a Crystal Report (CR) that prompts for an acct number. The main report data source uses a sql view to take the acct number input and look up the information it needs to print ...
1
vote
0answers
40 views

Presenting relationship of rows in SQL Server

I have two tables named FORM and FORMACTION. The rows in FORM represent screens in a CRM system and FORMACTION represents which FORMs lead to which. e.g. FORM ID,NAME,LNAME 1,"CustomerD","Enter ...
0
votes
0answers
18 views

What SQL Server feature do I need to check to get SqlPackage.exe installed?

What SQL Server feature do I need to check to get SqlPackage.exe installed? Checking the one called "SQL Server Data Tools" (feature name BIDS) created the DAC directory and puts a few text files in ...
0
votes
1answer
35 views

Is there a database that speaks pure SQL?

My understanding is that SQL is the standardized basic framework for quite a variety of different SQL flavors like MS SQL, MySQL, PostgreSQL, ... But all of these different flavors introduce a ...
0
votes
0answers
17 views

performance issues with virtual Win 7 box running unattended WCF/MQ application

We have a virtual Windows 7 box running an (unattended) app (written in c#, using WCF 2) that connects to the iSeries Websphere MQ, retrieves messages then sends them to an external service provider ...
0
votes
1answer
231 views

Can't install SQL server 2008 or SQL Server 2014

When I try to run the SQL SERVER 2008 setup, it shows the following error and exits: SQL Server Setup has encountered the following error: Unable to cast object of type 'System....
0
votes
1answer
350 views

Connecting to SQL Server on AWS RDS

I have an SQL Server running on an AWS RDS Instance. I can connect fine using SQL SMgr on my local machine but I get an error message from an application I run on my local machine which needs to ...
2
votes
1answer
68 views

How to put Windows Server into something like “Standby mode” so I can safely pull the plug off of it?

I have an interesting problem - we are going to test our UPS backup system by pulling the plug in our server room for a short time. Ideally the UPS will kick in and nothing interesting will happen, ...
1
vote
0answers
75 views

Why is sql server native client version “not marked” in odbc data source administrator?

Normally there's a version number in there:
0
votes
1answer
21 views

Search views in multiple MS SQL databases for use of Order BY and record which view uses it

In the process of migrating over some old databases to new servers, we know that some views in some databases might be using an ORDER BY, but we're unsure which / where. We'd like to record which ...
0
votes
1answer
2k views

Why can't I connect to my local SQL Server Express (2014)?

After I installed Microsoft SQL Server Express (2014) on my local computer (for testing while building a web interface which uses databases), I could connect just fine, but for some random reason, now ...