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

2
votes
2answers
14 views

Change ownership of my Databases in SQL Server 2016?

I installed MSSQL Server 2016 on Windows 10 Home, and created some databases. I then upgraded to Windows 10 Pro, and now since I am logging in to SQL as a different user (old user was local, new user ...
0
votes
2answers
32 views

Windows 10 - MSTSC UI has very bad performance

About a month ago I reinstalled my PC at work and put Windows 10 on it after I received my new SSD. While the system itself runs very smooth, the MSTSC UI (the connection dialog) is pretty much ...
-1
votes
1answer
23 views

Visual Studio Licence for a Medium Orginization

Microsoft is making me go crazy and here is why I am working a developer for a mid-sized (100 employees) company who is mainly into accounts. I am a member of a small team IT of 8 people that manage ...
-2
votes
0answers
25 views

Best/Any framework to edit SQL Database - preferably asp.net [closed]

I'm looking for either commercial or open source framework that will allow me to point it at an SQL Server database and it will build the pages for us/me. It doesn't have to be amazing, but will save ...
2
votes
2answers
32 views

Better Way to Export Data from MS SQL server

[TL:DR] I need to be able to export ad-hoc data from a MS SQL Server DB to a file on my local machine using a predetermined format with *Latin1 encoding. I wasn't sure if SSMS had a way to create a ...
0
votes
1answer
36 views

Multiple sql server versions on the same PC

For several reasons , I need to install several sql server versions on the same Pc : 2005 , 2008 , 2008 R2 , 2012 , 2014,2016. I've read somewhere that this can be done using different instance names ...
-2
votes
2answers
30 views

How to connect multiple websites to one database in same server

What would you do if you have one server and multiple websites in that server and you want to connect all of the websites to one MySQL database in the server? I know it decreases the security but I ...
0
votes
1answer
16 views

MS SqlServer tcp proxy

Is there a way to proxy a SqlServer connection through port 80? Maybe by using Fiddler? My machine is in network1 and the proxy machine and SqlServer are in network2 (there are no restrictions ...
0
votes
1answer
13 views

Communicate with SQL Server 2008 R2 through Hyper-V

I have an SQL server configured with a Server in Hyper-V and I am trying to access the database through the Host computer. When I ping the SQL server (static IP) they communicate and vice versa. Then ...
-1
votes
0answers
11 views

Quandl, How to pull data from Quandl using API

Does anyone have any thoughts on how to pull data from Quandl into a simple database, so that I can run a query or group of queries against that database to pull the information I need? For Example. ...
0
votes
2answers
85 views

Client connectivity issue (SERVER\Instance) while attempting to access SQL Server 2005 named instance.

Background: There is a custom java application specified to connect localhost database User-PC\MSSQL to work with. This machine need to be replaced with another new PC with better hardware. Issue: ...
0
votes
0answers
70 views

SQL Server 2016 Enterprise silent install

I'm trying to install SQL Server 2016 Enterprise unattended and I can not do. I have the original ".iso" image (SHA-1: 4B782D6B2512ED1844EF2B2549DB2C586D6BE88E) ;SQL Server 2016 Configuration File [...
1
vote
1answer
12 views

Allowing access to local SQL Server from local apps

On a brand new system (Win 10 in this case but hopefully not system specific), I've installed latest SQL Server and now I want to connect to it from local apps. What steps must be taken to allow ...
3
votes
2answers
28 views

SQL : Restrict view of tables in database

This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
0
votes
0answers
20 views

SQL Server Management Studio 2016 is always prompting me for scripts

I started using a database on Windows Azure and downloaded myself the SSMS 2016 to administer my DB. I haven't used SQL Server in a while and with the 2016 version every time I want to administer the ...
-1
votes
2answers
236 views

MSSQL 2016 express edition download [closed]

Been looking everywhere for this download but can't find it ?MS didn't not released the Express edition ??? ?Did they had any problems creating the express edition SKU for the release date (today, ...
1
vote
0answers
26 views

In SQL SERVER how to do ;Third Computed Column = First Computed Column + Second Computed Column + Basic Column [closed]

I use SQL Server. I have a table with A. One column is for "Interest" B. There are three computed columns : First_val , Second_val , Third_val First_val = 10 % of Interest , Second_val = 20 % of ...
1
vote
1answer
62 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 ...
1
vote
1answer
61 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
20 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
60 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 ...
0
votes
0answers
44 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
10 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
71 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 AttachDSNLessTable([...
0
votes
1answer
27 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
131 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
99 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
89 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
26 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
20 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
32 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 table/...
0
votes
1answer
55 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
23 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
12 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 it)...
0
votes
0answers
11 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
16 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
43 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
76 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
78 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
204 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
108 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
44 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
35 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
55 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
61 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
37 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
123 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
179 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
189 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 ...