17,981 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
4 answers

How to import password protected Excel file into sqlserver using ssis

Hi All, I want to import password protected excel file into SQL Server using SSIS. Please help me

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
asked 2020-08-19T07:36:18.593+00:00
vaishu 1 Reputation point
commented 2020-08-24T08:44:21.667+00:00
Monalv-MSFT 5,896 Reputation points
2 answers

SQL Server - How to keep DB access up while creating a bacpac file

First, we are a startup with a relatively big (14 GB) database and a small budget. We need a current, weekly would be ok, copy of the database for local use. The bacpac method works well, except that during the export process DB access slows to a crawl,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-18T01:16:29.31+00:00
Kal Kallevig 1 Reputation point
commented 2020-08-24T08:03:54.76+00:00
m 4,271 Reputation points
3 answers

SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.

Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute this package using DTExec utility. "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec" /ISSERVER…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
asked 2020-08-17T16:26:02.5+00:00
Sarang Deshpande 1 Reputation point
commented 2020-08-24T07:50:34.407+00:00
Monalv-MSFT 5,896 Reputation points
3 answers

Can I deploy to SQL Server 2014 SSIS Catalog from Visual Studio 2017?

We are testing Integration Services Catalogs with SQL Server 2014. We are trying to find a way to deploy from Visual Studio. When we try from Visual Studio 2017 Pro (with data tools) we receive the following error. ![18800-image.png][1] I'm trying…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,621 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
asked 2020-08-19T19:42:28.107+00:00
alhowarthWF 296 Reputation points
commented 2020-08-24T07:16:06.173+00:00
Monalv-MSFT 5,896 Reputation points
2 answers

UniqueIdentifier - Performance Issues Though doing a Index Seek

Dear Experts, I have two Tables with 800 Million Records in each where the Two Tables which I have Uniqueidentifier Column in the both as Primary Keys and one is references to other table. While the Select is done with other tables including these…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-21T09:36:27.27+00:00
Azmath Momin 61 Reputation points
commented 2020-08-24T07:15:23.277+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
5 answers

.Net SqlClient Data Provider Queries "Stuck

We started to notice that a bunch of client-side exe apps that run simple SQL queries (Insert, delete) are stuck. When we copy the query and run it manually it completes in seconds, but it seems like all these jobs are stuck. Any ideas why and/or what…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-17T07:11:10.667+00:00
reuvygroovy 776 Reputation points
commented 2020-08-24T06:49:03.18+00:00
Cris Zhan-MSFT 6,606 Reputation points
1 answer

Visual Studio C# 2012, MS Sql Server Express 17

OK Folks, I've been developing code in Visual Studio C# V12, using MS Sql Server Express V2017 for a year. -No Problems. Code compiled, and I could test and deploy code. -I added a database in MS Sql Server Express V2017 -total unrelated to my…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-23T00:37:19.257+00:00
Scott Hamlin 1 Reputation point
answered 2020-08-24T06:42:26.497+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
3 answers

BCP date format

I am attempting to import data using bcp. The data contains dates formated as Jan 03 2019 12:00:00:00.000000AM. BCP rejects this data, saying this is an invalid date format. I believe BCP expects a date formatted as 2019-01-03 12:00:00:00.000000. …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions
asked 2020-08-21T03:31:31.837+00:00
Ted Dykhorst 1 Reputation point
commented 2020-08-24T06:42:01.547+00:00
MelissaMa-MSFT 24,176 Reputation points
2 answers

How to Process Cubes on Different Server?

Hi guys, I am trying to process SSAS cubes on server"B" by kicking SSIS on server"A" with the EffectiveUserName option. The job executing user is an AD user whitch has admin authority on both server "A" and…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
asked 2020-08-18T05:50:26.93+00:00
Shohei 1 Reputation point
commented 2020-08-24T06:38:32.937+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Heterogeneous Logreader encountered an error in call to LoadReplCmds when processing state 'SYNCINIT_FETCH'

We are having a Oracle as Publisher and distributor and subscriber is SQL SERVER. My Log reader Agent is getting failed showing below error : Error messages: Query timeout expired (Source: MSSQLServer, Error number: 0) Get help: http://help/0 …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-21T08:25:23.19+00:00
Neeraj Dubey 1 Reputation point
answered 2020-08-24T05:56:17.287+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

MDX code to get today's date

Hello, I created a query for Excel in Power Pivot using the visual designer. I currently have to change the dates every month. I need to modify it so it automatically returns the data for January from the current year until the current month. …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
asked 2020-08-21T14:09:13.197+00:00
L G 1 Reputation point
answered 2020-08-24T05:43:05.687+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Global variables using in other forms

I am making a software i want a global variable so that i can use across one form to other so basically i want to call roll no. that is written in an event datagridview row header event: Roll_No =…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,834 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-21T07:00:59.377+00:00
Zeeshan Haider 21 Reputation points
answered 2020-08-24T05:23:58.037+00:00
Daniel Zhang-MSFT 9,616 Reputation points
8 answers

Database trigger and there is login fail on the sql errorlog

I have the following trigger database trigger and then there is a error in the errorlog why is that ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-18T04:18:24.463+00:00
sakuraime 2,321 Reputation points
answered 2020-08-24T01:37:34.48+00:00
m 4,271 Reputation points
5 answers

Index Optimization job stuck - Sql 2008R2

Hello, We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's maintenance Solution but during job was running and Sql server Shutdown/Restarted and job still showing as in 'Progress'. This is a Sql Agent job we…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-17T17:22:28.687+00:00
pdsqsql 391 Reputation points
commented 2020-08-24T01:25:20.25+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
3 answers

SQL Server 2019 Highly Available Cluster - Setup

I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-17T14:33:35.027+00:00
Tolo, David 1 Reputation point
commented 2020-08-24T01:13:40.467+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
7 answers

SQL Server 2014 table compression

Hello, planning on running a SQL Agent Job to compress some Prod Tables which looks like will take a couple of hours to finish. Is it correct to say that during this Tables (only) compression job just the target tables will be unavailable/locked and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-19T23:21:22.477+00:00
techresearch7777777 1,796 Reputation points
commented 2020-08-23T21:25:06.43+00:00
Erland Sommarskog 101.4K Reputation points MVP
3 answers

MECM/WSUS - SQL option collocate or remote SQL?

Hi All Wanted to bounce my thoughts with fellow members. I am about to embark on a mini project for a customer. It's for a small experiment and a new network and infrastructure environment will be created on-premises. Unfortunately for this piece of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-20T08:43:34.89+00:00
Anonymous
answered 2020-08-22T22:17:56.813+00:00
Jason Sandys 31,161 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Updating a table based on values in the table

I have a temp table #XX that looks like this" ID KWID NAME ORDER 1447 1144 SW_6368_58_55.png NULL 1450 1145 SW_6942_58_55.png NULL 1451 1147 Arb3_43_55.jpg NULL 1452 1147 Arb1_43_55.jpg NULL 1453 1147 Arb2_43_55.jpg NULL 1598 1152…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions
asked 2020-08-22T00:45:59.007+00:00
Jim Seidel 61 Reputation points
commented 2020-08-22T21:57:34.327+00:00
Jim Seidel 61 Reputation points
4 answers One of the answers was accepted by the question author.

Actual Execution plan for query store

is it possible to capture actual execution plan inside query store ? or else need to use back xevent ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-20T04:57:53.157+00:00
sakuraime 2,321 Reputation points
accepted 2020-08-22T09:49:37.813+00:00
sakuraime 2,321 Reputation points
5 answers One of the answers was accepted by the question author.

Test if any SQL Server related questions already exist

I checked all 4 forums under SQL Server and I see 0 posts. However, I think I saw a thread somehow where I saw Uri has an answer. How come I don't see any questions in relation to SQL Server?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
asked 2020-08-04T03:35:39.533+00:00
Naomi 7,361 Reputation points
commented 2020-08-22T01:16:44.963+00:00
Ronen Ariely 15,096 Reputation points