Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server]

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-...

0
votes
0answers
24 views

Restore a database in clustered SQL Server instances

I have two Dell boxes and a SQL Server (2014 Enterprise) instance runs on each box. They are clustered through Always On. Now I have a new database on my laptop and I need to restore it into the ...
0
votes
0answers
41 views

How to copy read only database?

I'm using SQL Server 2012. I have a read-only database and I have to create a replica from it and a new database should be read-write I tried to copy but it failed Then someone told me it's because ...
0
votes
0answers
16 views

Create Backwards Compatible SQL Server data connection in Excel 2016

I've recently been upgraded to Excel 2016. However I'm now finding that data connections I create to our SQL Server database cannot be refreshed by users with Excel 2013 - an error occurs. Is this a ...
0
votes
0answers
9 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
27 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
0
votes
1answer
55 views

SQL Server 2012 repair/installation fails

We have a Windows 2012 R2 server and want to run MS SQL Server 2012. It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
0
votes
0answers
15 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...
0
votes
0answers
13 views

SSRS Generating Large Log Files, Filling Drive

I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB ....
0
votes
0answers
50 views

What is the correct SQL command to use when “?” doesn't work as a parameter reference to a spread sheet in Excel?

When I changed the hard coded date (highlighted) to ? It returned conversion error message. What is the fix? Appreciate all the helps i can get. SET NOCOUNT ON DECLARE @lastdayofweek DATETIME ...
0
votes
0answers
17 views

All INSERTs done through MS Access old untouched forms now fail after creating new unrelated forms

I'm fairly new to MS Access, and the following issue has me completely stumped. I modified an existing .accdb MS Access project by creating new forms via the Form Creation Wizard that allow you to ...
0
votes
0answers
23 views

Can't connect to a SQL Server from Access

Via a Connection ODBC, we are trying to connect from an Access 2016 to a SQL Server, and we found this error message: Both computers are in the same workgroup and they can see each other. Also they ...
0
votes
0answers
15 views

SQL Server Manager Studio keeps creating Visual Studio 2015 and Vulnerability Assessment Reports folder in which both of these folder are empty

I'm using SSMS 2017. However, there is a problem. As soon as I open the app, it will create two folders: SQL Server Manager Studio (with Vulnerability Assessment Reports emptied ) Visual Studio 2015 ...
0
votes
0answers
47 views

Network and Machine configuration for Virtualbox VM running SQL Server 2016

(Not sure if this should be superuser or serverfault?) Background: My desktop machine is Win7 Enterprise, which won't run SQL Server (SS) 2016 or 2017. We'll upgrade to SQL Server 2016 in about 9 ...
0
votes
0answers
37 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
0answers
76 views

“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server

We have a setup where we use MS SQL Server with a linked Oracle server. Our database has views on the Oracle database. We have in-house written software (I'm the lead developer) which uses this setup. ...

15 30 50 per page