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
26 views

Running Parameterized Stored Proc From Power Query

I have been following the tutorial HERE but anytime I try to refresh the workbook, it gives me an error of: DataSource.Error: Microsoft SQL: This database function doesn't support the query option ...
0
votes
0answers
31 views

SQL server case statement [migrated]

I have the following case statement that I am struggling to get to work. I can see what the problem is but am unsure on how to fix it. CASE WHEN DateDiff(n,Oppo_Opened,GetDate()) < CASE WHEN ...
1
vote
1answer
31 views

How to force SQL server to use maximum network bandwidth

I have a program written in Delphi that uses SQL Server 2008 as database engine. I am on a p2p link provided by two nano station m5. When I run a specific query inside of the program, the network ...
0
votes
0answers
11 views

Disable Excel Data Connections when no connection to the database

Is it possible to pause/disable Excel data connection on a macro? I don't want to remove the data connections, I would just like to create an option to disable them if the user can't connect to our ...
-1
votes
1answer
31 views

Convert SQL Server queries to SQLite queries [closed]

What is the best converter to convert the SQL query to sqlite query? I have a script file which have lot of scripts written in SQLServer. I want to convert it to SQLite queries. Please suggest me a ...
-2
votes
0answers
8 views

I would like to run a SQL Reporting Services service against my Azure Database how can I do this cheaply?

I have an Azure Sql Database. I don't have any SQL Server licences, but would like to be able to run SQL Reporting Services. Happy to pay for something, but I don't really want to pay for a full SQL ...
0
votes
0answers
15 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
0
votes
0answers
6 views

sp_send_dbmail spamming Event Log

I have some unknown but work-relevant process on my development computer executing every 10 seconds. It calls a stored procedure in SQL Server. Part of this stored procedure is to call ...
0
votes
1answer
40 views

How to speed up off-site access to Access application

I built a calendar-type application on MS Access 2013 with SQL Server as the back-end (each day on the calendar is a subform). About 20 tables are connected using the line Call ...
0
votes
1answer
16 views

Clustered SQL database requires full recovery mode?

The application we provide customers with requires an SQL database. Due to the nature of the application, we recommend the recovery mode to be set to Simple as it is not critical data that is stored. ...
1
vote
0answers
52 views

SQL SERVER 2016 Plugin's not working [closed]

Recently I installed SQL SERVER 2016 in my PC Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
0
votes
1answer
62 views

MySQL won't start

I recently tried to run a basic MySQL command. Then I got the following response: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I then ...
1
vote
1answer
47 views

Convert date from SQL text to Excel date format

I'm trying to export from my pervasive SQL database to Excel. the date is stored as CHAR(8) I need them in a recognized date format for Excel so that I can use date filtering. What do I have to add ...
0
votes
1answer
23 views

Link excel file to SQL table

In all versions of Microsoft Access, I used to link access table to any excel file. Can this be done with SQL server 2012 without the need to import the file itself?
0
votes
0answers
15 views

System Center 2012 R2 App Controller will not connect to SQL Server

So I am trying to implement App Controller 2012 R2 in my Hyper-V setup. I am running 1 VM that has 2 instances of SQL Server 2012 Developer edition (Default and Erpdev) and one with SQL Server 2012 ...
0
votes
0answers
23 views

Can Excel dropdown list be powered by SQL table (or view)?

I want to enter contractor acronyms into Excel cell. I want to achive: Validating contractor acronym with SQL table/view Autocomplete contractor acronym with SQL table/view while typing SQL ...
0
votes
0answers
28 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
0
votes
0answers
22 views

Accessing Static Internal IP from outside my LAN

I have a static private(Internal) IP for my desktop PC and i have a sql server database on this PC that i can access inside my LAN from any other computer , but when i connect to a wifi outside my LAN ...
0
votes
0answers
11 views

SQL Server Management Studio 2008 UI Issues

I work in a Citrix VDN virtual machine. When I get disconnected from my session and come back in, SSMS UI has a bunch of mini windows exploded all over the screen (sorry, no better way to describe ...
0
votes
0answers
10 views

Curious search behavior in Sql Server 2014, searching for dot also returns comma results

Background I'm getting some unexpected search results, consider the following pseudo-query: SELECT SomeField1WithSearchCriteria, SomeField2WithSearchCriteria, ...
0
votes
0answers
14 views

installation issue in windows 8 sql server 2008

I have installed vs 2010 ultimate and sql 2008 in windows 8.but after installation sql is not found.i checked in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn also.There is an INSTALLOG ...
0
votes
0answers
5 views

AAA server with GUI and alert system

I am working on a project in which I plan to display the logs generated by an AAA server in a user friendly GUI view. Then evaluating the logs of the database, if any unprivileged user tries to access ...
0
votes
0answers
34 views

Risks of changing the account MS SQL Servers run under

I have a MS SQL Server 2008 R2 that was setup and is running under a "Virtual System Account" (NT Service\MSSQLSERVER). The problem is, that MS SQL Server isn't able to do backups (from within SQL ...
1
vote
1answer
53 views

How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?

I have tried this question on Stack Exchange - Database Administrators (http://dba.stackexchange.com/q/129286/51925), but I don't get any responses, so I'll try here. I'm struggling with remoting ...
0
votes
0answers
48 views

Localizing SQL Server Reporting Services (SSRS) in Chrome

We have a report in SSRS that our users open in Chrome. The English version works great. However, we notice that Chrome does not appear to localize the built-in controls when we change the browser ...
-1
votes
1answer
139 views

C# console Application with DB

i have c# program connected to SQL server and it is working very good but when i am trying to install this program in other PC it doesn't work unless SQL installed the data base is very simple .. i ...
0
votes
1answer
70 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
34 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
20 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
46 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
35 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
29 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
79 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
142 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
94 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
358 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
67 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
21 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
214 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
15 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
1answer
166 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
215 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
324 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 ...
3
votes
2answers
4k 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
21 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
24 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
952 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
39 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
175 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 ...