Stack Exchange Network

Stack Exchange network consists of 175 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-server-2008]...

-2
votes
0answers
6 views

Remote Procedure call failed [on hold]

i am using asp.net web application data source : SQL SERVER 2012 application working fine,some time SQL SERVER through remote procedure called failed how to solve this Please help me
0
votes
0answers
7 views

How to configure Microsoft SQL server management visual studio

TITLE: Connect to Server Cannot connect to desktop-57. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was ...
1
vote
1answer
11 views

SQL query to find 3 consective records and rspective data

Need to pick the data where values are >=0.7 and appearing at least 3 consecutive times then hourly recorded per day Hours 00 0100 0200 0300 0400 0500 ValueNumber .7 ...
0
votes
0answers
18 views

Cannot install softwares on shared screen via ZOOM

I am trying to install SQL server and visual studio on my friend's system using a shared screen via the application ZOOM. I have downloaded the files in the said computer using screen sharing but I ...
0
votes
0answers
4 views

Applying EFS to SQL DB FileStream Vs Usage of drive space for EFS Processing

Can any one help me on below case related to EFS for File Stream folders. I am with SQL Server 2014 SP2 and Availability groups on Windows Server 2012 R2 Standard. I have 800 GB of FileStream ...
2
votes
0answers
27 views

Insert data to database using Excel VBA is not working

I have a macro that will upload data from multiple workbooks to the database. Table will differs based on what type of value/data being inserted. I have there tables. I can insert value in the first ...
0
votes
0answers
44 views

Can I automatically create a table in mySQL from a csv file with headers as column names?

I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the ...
0
votes
0answers
3 views

SQL Server Configuration Manager - Can't change “Start Mode” to Manual [migrated]

I'm running Windows 10 with SQL Server 2012. As I am not using SQL Server frequently, I am trying to change the "Start Mode" of all its processes to "Manual" (thru SQL Server Configuration Manager). ...
0
votes
0answers
29 views

SQL Server 2012 Job Seemingly not running at all, manual or scheduled, no logs

We recently installed a side-by-side instance of SQL Server 2017 on our DEV environment, and almost all of our DBs and jobs have migrated over. However due to compatibility issue, we still have a ...
1
vote
1answer
20 views

SQL Sever Management Studio 2008 does not let me back up my database

I tried to back up a server I created in SQL Server, but I received the following message: TITLE: Microsoft SQL Server Management Studio Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'. ...
0
votes
0answers
6 views

SSAS 2017 Power Query Editor Enter Data not loading

I'm using SSAS 2017, and the new Power Query window editor. I opened up the editor, used Query, and Enter Data. I entered a few rows, and then created a new table. But the table is grayed out, and I ...
0
votes
0answers
16 views

SSAS Tabular model with Azure SQL on datasource

I'm trying to create my first tabular model. My datasource is an Azure SQL Server database. I connect to my database with an SQL server authentification, and the test is OK. But when I try to refresh ...
0
votes
0answers
16 views

FTP connection failing when runing SSIS package with SQL Agent

I have an SSIS package that is fully functional that generates files and places them on to my ftp server. I have a connection manager for my FTP server and have the ftp server details and credentials ...
0
votes
0answers
21 views

Oracle connections broken in SSIS after uninstalling 32bit version of oracle client

I originally had 32 bit and 64 bit version of Oracle 12 client installed on my work machine. I uninstalled the 32bit version, because it was causing some conflicts with another application, but now ...
0
votes
2answers
102 views

Is there a way to enable tcp/ip protocol through powershell script or sql script?

The context: I got a Vagrantfile to provision a VM, this VM have SQL-SERVER 2012, 2014, 2016 and 2017 installed. When I check on the SQL SERVER CONFIGURATION MANAGER I saw that in every SQL-SERVER ...

15 30 50 per page