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
51 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
226 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 ...
1
vote
1answer
58 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
824 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
7 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
19 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
328 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
78 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
67 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
281 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
634 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
44 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
15k 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
45 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
49 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
93 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 ...
9
votes
1answer
17k 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
55 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
222 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
364 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
23 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
64 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
21 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
50 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
210 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
229 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
214 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 ...
0
votes
1answer
329 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
64 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
64 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 ...
1
vote
1answer
270 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: ...
2
votes
0answers
597 views

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. ...
-1
votes
2answers
260 views

Is SQL Express pre-installed in Windows?

In Windows 7, 8 and 10, is there any SQL Server Express Engine included already in the freshly installed OS? If yes, which version of SQL Express comes with each OS ? I'd like to create and ...
2
votes
0answers
204 views

Error installing SQL Server

Yesterday I installed SQL Server 2014 onto a Win2012 server that has already SQL Express 2014 installed. I uninstalled/reinstalled it three times, but to no avail: The server wouldn't start after ...
0
votes
0answers
59 views

localdb gives random pipe connection string everytime starts up

I am using Entity Framework 6.1 and Visual Studio 2013. By default, EF produces "MSSqlLocaldb" as data source in app.config. In development, from time to time I have to run SQL query on the entity ...
2
votes
1answer
94 views

Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails

My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development. Since some of my development has to be done ...
0
votes
1answer
133 views

Dynamic field names in Excel queries

As explained here, Excel queries accept dynamic values (e.g. "where name = ?" and "?" can be linked to a cell of your choice). Alas, Excel queries don't seem to accept dynamic field names (e.g. the ...
4
votes
3answers
178 views

How do I force an application to recognise two names for a disk drive?

I have an extensive image database (3.25GB metadata, 90K images) held in a legacy product (idImager V5). This in turn utilises SQL Server 2005 as the underlying DBMS. Over time, I have been adding ...
2
votes
1answer
1k views

Do I need SQL Server paths in my PATH environment variable for it to work?

SQL Server adds things to my PATH environment variable, and over time that bloat makes me hit the 2048-char limit in Windows 7. Do I really need them there for SQL Server to run? This is on a ...