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

1
vote
2answers
11 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 ...
2
votes
1answer
3k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
0
votes
2answers
31 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 [on hold]

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 ...
1
vote
2answers
30 views

Simpler data export from MS SQL server

[TL:DR] Is there some way to create a workflow in SMSS (or using PS script) where it's easy to export ad-hoc data from a MS SQL server to a file on my local machine, using a pre-determined format with ...
1
vote
2answers
8k views

how to synchronize local and remote database?

I have a database in SQL server on local computer, we have the same database on remote p.c , i want to sync it with remote server, is there any script for SQL server or any plugin? Thank you. OS: XP-...
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 ...
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
2answers
6k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the ...
2
votes
1answer
2k 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 ...
-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
1answer
40 views

Pause VM when SQL server idle

In OSX Mountain Lion, I run a Windows Server 2003 VM solely to run SQL Sever 2008. It chews up a lot of battery life. Is there some way to automatically pause the VM when the SQL Server is idle and ...
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 ...
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 [...
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
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
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 ...
0
votes
2answers
52 views

Log file viewer not displaying database where error occurred

Something keeps being logged to files located here: C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER\MSSQL\Log Files like these keep getting updated: SQLFT0000700007.LOG 15 errors per ...
5
votes
2answers
6k 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 ...
-1
votes
2answers
235 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
198 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
2
votes
1answer
966 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
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 ...
3
votes
3answers
6k views

Archive Outlook mail items into SQL Server

I am looking (and so far not finding any) for a solution to archive e-mail items from my Outlook into SQL Server. My PST is beginning to get really really big, and I'd love to extract my older e-mail ...
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 ...
0
votes
2answers
326 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. I get the notice: unable to connect to the database server name, and that ...
2
votes
2answers
2k views

Visual Studio 2012 SQL editor missing tool bar

I have a number of SQL script files in a database project. When I open some of them, the editor includes a toolbar, with options to connect to database, execute the script, etc. However, when I open ...
-1
votes
1answer
59 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
2answers
387 views

How Do I Suppress SQL Server “Informational” Messages?

I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for ...
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 ...
1
vote
1answer
222 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
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 ...
1
vote
1answer
203 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
0
votes
1answer
558 views

SQL Server: Audit permission denied

Is there any easy way to see those events in SQL Server 2008 for which permission was denied on a query (along with the text of the query and the specific object that permission was denied to)? I ...
1
vote
1answer
74 views

How to find my network and database access [closed]

Our company gets audited pretty regularly and I was wondering if there's an easy way to find out which accounts have access to what on our network? We're an all windows development shop, so all our ...
0
votes
1answer
70 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
1answer
589 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 ...
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) ...
1
vote
4answers
2k views

Connecting from Mac OS X 10.6 to MS SQLServer

I develop iPhone Apps so my set up is a Mac running Snow Leopard (10.6). However the databases that the App connects to all run SQL Server (2005 or 2008). I would like a native (free?) solution to ...
0
votes
1answer
98 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
88 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 ...
8
votes
4answers
10k views

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
5
votes
3answers
9k views

Windows 10 .NET 3.5 installation

I'm on build 9841 of Windows 10. I downloaded .NET 3.5 SP 1 full. I double click the installer but nothing happens. Is that .NET version not compatible with Windows 10? I need it to install SQL Server ...