18,206 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

Parallel Processing in SSIS

Dears I have the following scenario in SSIS. There are two packages, Outer.dtsx and Inner.dtsx. the Inner package is called inside the Outer package in the workflow. To increase the performance, as the workload is heavy, I added a sequence container,…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,474 questions
asked 2020-08-26T13:24:30.52+00:00
Khidir Elsanosi 21 Reputation points
accepted 2020-08-26T19:27:47.057+00:00
Khidir Elsanosi 21 Reputation points
1 answer One of the answers was accepted by the question author.

Upgrade SQL 2008 Cluster to SQL 2012 Cluster

We are currently attempting to upgrade SQL 2008 Cluster to SQL 2012 Cluster. 3 node cluster. We were able to upgrade the A and B nodes but unable to upgrade the passive C node. The passive node doesn't have a database. In order to upgrade the A and B…

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,950 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
965 questions
asked 2020-08-24T19:17:15.42+00:00
JL Tech Support 21 Reputation points
accepted 2020-08-26T19:06:54.5+00:00
JL Tech Support 21 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to connect to Azure SQL DW & DB via SSMS, SSDT - error 10060

Hi, I'm trying to connect to Azure SQL Data Warehouse via SSMS and SSDT from my local with SQL Authentication and AD universal MFA, but I'm unable to and getting error number 10060 (Connected host failed to respond ). I've added my client IP to…

Azure SQL Database
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
582 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,504 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,950 questions
asked 2020-08-05T16:25:52.757+00:00
Neil Pereira 81 Reputation points
accepted 2020-08-26T16:15:13.157+00:00
Neil Pereira 81 Reputation points
2 answers One of the answers was accepted by the question author.

Why am I being prompted to define query parameters for my dataset?

Why am I being prompted to define query parameters for my dataset when I select "Refresh fields"? It is simply calling a stored procedure.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,835 questions
asked 2020-08-25T20:01:31.147+00:00
Tom Stone 521 Reputation points
accepted 2020-08-26T14:47:04.793+00:00
Tom Stone 521 Reputation points
5 answers One of the answers was accepted by the question author.

SQL Server Agent Weirdness

Hello Running SQL Server version Microsoft SQL Server 2017 14.0.3281.6 (X64) I have a query which when run in SSMS finishes exactly when I want it to, what it does it goes to a different server and checks if a job has completed ether successfully or…

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,950 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2020-08-25T11:44:20.827+00:00
Peter Nolan 21 Reputation points
answered 2020-08-26T09:42:13.383+00:00
Peter Nolan 21 Reputation points
5 answers One of the answers was accepted by the question author.

Safe way to remove uniqueidentifier which is a primary key (clustered index) on a large 300 GB table in SQL Azure DB

Dear All, I have this table on an Azure SQL DB (S4 compute tier) which is 300 GB in size. On checking, I saw that the primary key is on an uniqueidetifier ID column. The fragmentation is over 99% as expected. As we know, it is not recommended to…

Azure SQL Database
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,950 questions
asked 2020-08-16T01:34:15.4+00:00
mo boy 396 Reputation points
commented 2020-08-26T08:55:52.767+00:00
mo boy 396 Reputation points
2 answers

I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager.

I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager. I would like assistance with someone that is an expert in Visual Studio. Steps to recreate the problem. Open visual studio 2019. …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,474 questions
asked 2020-08-25T21:35:57.49+00:00
Philip Lamphear 1 Reputation point
answered 2020-08-26T08:19:21.553+00:00
Monalv-MSFT 5,896 Reputation points
1 answer

Access to Read-only Database to a non-SA user

Is there a way to allow a user (non-SA) access a read-only DB without setting the DB to read-write? Thanks.

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,950 questions
asked 2020-08-10T17:16:37.037+00:00
Rob Chin 1 Reputation point
commented 2020-08-26T07:28:59.953+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

windows系统中如何关闭52.139.168.125的数据包发送

windows系统自动不定期向52.139.168.125发送数据包，经过观察似乎是因为sqlceip.exe的运行而产生，请问sqlceip.exe是一个怎么样的程序，有没有关闭sqlceip.exe程序的方法，以及关闭该程序会否对系统产生不良影响。 谢谢。

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,950 questions
asked 2020-08-21T05:45:00.36+00:00
HW Xian 121 Reputation points
accepted 2020-08-26T05:58:46.997+00:00
HW Xian 121 Reputation points
3 answers One of the answers was accepted by the question author.

Query SQL Error Log with T-SQL

Hi Team, I am treying to query SQL error log using T-sql. There is some issue with T-SQL. I am not getting error logs from last 24 hrs. CREATE TABLE #ErrorLogInfo ( ID INT…

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,950 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2020-08-21T21:07:24.6+00:00
Vijay Kumar 2,016 Reputation points
accepted 2020-08-26T04:05:46.843+00:00
Vijay Kumar 2,016 Reputation points
0 answers

Sql server 2014 developer edition setup error

Am trying to install the Sql server 2014 developer edition on Azure virtual Machine at the end of the installation process i have got an error like 1.Reporting services,Database Engine services,Full-Text semantic extraction for search has failed to…

SQL Server on Azure Virtual Machines
Azure SQL Database
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,950 questions
asked 2020-08-21T14:28:54.52+00:00
Mr. Mohammed 1 Reputation point
commented 2020-08-26T02:14:08.167+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor
2 answers

Why can't I use the Import Data Wizard (on SSMS) to alter the default schema for new destination tables?

Hello, I hope this question is clear. I am still in the process of adding an image of the error message. I am using the wizard to import a flat file source into my database. I have SQL Server Express 2019. My goal is to create a table with…

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,950 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2020-08-22T02:02:35.43+00:00
hapless 1 Reputation point
commented 2020-08-26T02:09:51.447+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor
3 answers

Unable to see the "maintenance plan" option on sql 2008 express server to setup the backup schedules. logged in as admin

Hi Team, I have logged in as admin on the on-prem SQL server 2008 express edition but unable to see the "maintenance plan" option under "management" to schedule the backups to Azure storage account container. We have the 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,950 questions
asked 2020-08-22T22:18:59.137+00:00
thumma venkata sai sriram 6 Reputation points
commented 2020-08-26T02:08:39.443+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor
3 answers

Can I uninstall the MS SQL 2008 installation support files?

Hello everyone. We have a server (Windows Server 2016) with SQL Server 2016 Standard, but during installation of SQL 2016 also installed MS SQL 2008 Setup Support Files. The company need to uninstall MS SQL 2008 Setup Support Files, can I do it? Is…

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,950 questions
asked 2020-08-24T16:33:31.623+00:00
Javier Alfredo Lugo Rodriguez 1 Reputation point
answered 2020-08-26T01:26:13.263+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor
3 answers

Can't be able to add node to a SQL server failover cluster

While adding a node to a Sql server failover cluster, I am getting error like this - Error: The credentials you provided for the Sql server agent service are invalid.

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,950 questions
asked 2020-08-19T05:08:11.483+00:00
AMRITANSHU AMRITANSHU 1 Reputation point
answered 2020-08-26T01:22:51.777+00:00
m 4,271 Reputation points
3 answers

How can two sql servers have different disk read time in same SAN?

I have two sql servers in same SAN. The servers host the databases added in alwayson group. One of the servers is responding well but the other server is responding slowly while running queries. When I look at the disk read time one server has below 1 ms…

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,950 questions
asked 2020-08-19T03:36:12.88+00:00
Surendra Adhikari 211 Reputation points
answered 2020-08-26T01:22:24.447+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

Create a cursor that update field type char value in Sql Server

Hello , i want create a cursor that update column of my table Schools with more than three levels of education are level A, Schools with two levels of education are leveled with category B and other schools are leveled with category C. I tried…

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,950 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2020-08-25T00:51:44.173+00:00
jonathas moura 21 Reputation points
commented 2020-08-25T22:07:37.11+00:00
Erland Sommarskog 102.6K Reputation points
9 answers

sql server sa account disable

I am working on renaming and disabling the sa account the sa account has been renamed to sa_tmp the dbo user on all databases now show they are associated with the login sa_tmp if I disable the login, how should I handle all the schemas owned by…

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,950 questions
asked 2020-08-25T00:48:10.26+00:00
NeophyteSQL 241 Reputation points
answered 2020-08-25T22:04:09.327+00:00
Erland Sommarskog 102.6K Reputation points
4 answers One of the answers was accepted by the question author.

recovering space just eaten by my rollback

hi i'm sure i just consumed a lot of log space by rolling back the results of an in flight voluminous insert. my c: drive shows i'm down to bare bones. how can i recover that space before i move on? do i need to recover it, ie will sql blow it away…

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,950 questions
asked 2020-08-24T15:55:26.927+00:00
db042190 1,516 Reputation points
answered 2020-08-25T17:48:25.283+00:00
db042190 1,516 Reputation points
2 answers One of the answers was accepted by the question author.

adobe saves report incorrectly

Hi after some work, my subreport which is just one rectangle enclosing various "sub" rectangles etc looks beautiful when saved to word. But ridiculous when saved to pdf. the first sub rectangle prints on pg 2 out of order after the 2nd…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,835 questions
asked 2020-08-22T15:29:44.32+00:00
db042190 1,516 Reputation points
accepted 2020-08-25T17:42:02.24+00:00
db042190 1,516 Reputation points