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

3
votes
2answers
21 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 ...
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
1answer
39 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 ...
-2
votes
1answer
39 views

Are we allowed to use Microsoft SQL Server logo in our marketing materials? [closed]

Our software has used Microsoft SQL Server for a long time, and we've recently upgraded our compatibility with the latest versions of SQL Server. We would like to explain this in our regular What's ...
0
votes
0answers
15 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
50 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 ...
4
votes
2answers
5k 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
119 views

MSSQL 2016 express edition download

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, ...
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 ...
1
vote
0answers
194 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
962 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
25 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
43 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
49 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
14 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
324 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
41 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
377 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
27 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
199 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
9 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
549 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
55 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
18 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
494 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
91 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
79 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
58 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 ...
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
19 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
25 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/...
5
votes
2answers
683 views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
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 ...
10
votes
6answers
10k views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
1
vote
1answer
130 views

Tools to manage SQL Server and Oracle database from the desktop

I am using SQL Server 2008 and Oracle 11G on my system. Running both database services is making my system very slow. In order to stop the services I have to go to Services and stop them manually. ...
4
votes
1answer
383 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
3
votes
2answers
6k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
0
votes
0answers
91 views

Microsoft SQL: dealing with invalidated databases

I created a Microsoft SQL Server database that has now changed location. (The details are probably unimportant, but for the curious, I originally created it in a folder on an external drive mapped to ...
1
vote
1answer
957 views

Is it possible to replicate SQL Server Express 2008 => SQL Server Express 2012?

Is it be possible to configure the one way replication between SQL Server Express Edition 2008 => SQL Server Express Edition 2012?
0
votes
3answers
75 views

Removing Microsoft SQL Server

I have quite a lot of Microsoft SQL Server installed on my computed which I'ld like to unistall. They were probably used by the previous computer owner, who used it for his software developing, and ...
1
vote
4answers
108 views

Will the Microsoft SQL transaction log by default be enabled during install?

I was asked this question in an interview? Does it depend on version of the server or is it always same (enabled or disabled by default)?
3
votes
1answer
5k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...