17,972 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Find what I am looking for

This was my query page url: https://learn.microsoft.com/en-us/search/?terms=sp_enumerrorlogs I got: "8,300 results for 'sp_enumerrorlogs'" I searched 5 or 6 pages without encountering "sp_enumerrorlogs" in the article…

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,748 questions
asked 2020-08-26T15:43:49.37+00:00
David Rogers 1 Reputation point
answered 2020-08-27T06:07:07.843+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

VB.NET ReportingService2005 QueryDefinition.CommandText

I would like to know if there is a good example of ReportingService2005 QueryDefinition.CommandText using vb.net. My goal is to retrieve / get the SQL within the rdl report. I found this Link but no examples how to use it. any suggestions 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,748 questions
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,806 questions
asked 2020-08-25T14:44:15.323+00:00
jim brown 271 Reputation points
answered 2020-08-27T03:11:21.2+00:00
ZoeHui-MSFT 33,126 Reputation points
2 answers One of the answers was accepted by the question author.

define query parameters for my dataset in SSRS

Why am I being prompted to define query parameters for my dataset in SSRS when I select "Refresh Fields" when it is simply calling a stored procedure? There is an SSRS report parameter for each stored procedure parameter.

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,806 questions
asked 2020-08-25T20:36:07.843+00:00
Tom Stone 521 Reputation points
commented 2020-08-27T01:52:24.413+00:00
Joyzhao-MSFT 15,566 Reputation points
3 answers

dimension security on a combination of dimensions

0 I have 2 dimension tables scenario and compensation. scenario already has dimension security applied. Now we need to implement dimension security for compensation. Compensation is dependent on scenario. For example we have a separate table which has…

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-05T12:47:44.07+00:00
sudipta sen 1 Reputation point
answered 2020-08-27T01:43:13.493+00:00
Lukas Yu -MSFT 5,816 Reputation points
3 answers One of the answers was accepted by the question author.

compatibility_level and LEGACY_CARDINALITY_ESTIMATION

Hi everyone, we migrated from sql 2012 to sql 2016 and since then we have been facing some performance issue. We decided to change the compatibility level to 110 (sql 2012) and set the LEGACY_CARDINALITY_ESTIMATION= ON. It helped but then we were still…

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,748 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,553 questions
asked 2020-08-26T02:13:54.83+00:00
Rohit Kochar 36 Reputation points
commented 2020-08-26T23:46:16.363+00:00
Rohit Kochar 36 Reputation points
2 answers

Get the transaction amount inside the trigger database - SQL Server

Group Knowing that inside the trigger that controls the creation of a table, inside it is a transaction process. How could I identify, within a database trigger that when a certain table was created, the person was using a transaction…

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,748 questions
asked 2020-08-26T00:48:01.597+00:00
Claudinei Aparecido da Silva 1 Reputation point
answered 2020-08-26T22:13:44.85+00:00
Erland Sommarskog 101.1K Reputation points MVP
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,454 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,748 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.
959 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.
570 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,389 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,748 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,806 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,748 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,553 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,748 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,454 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,748 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,096 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,748 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,748 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,553 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,748 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,096 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,748 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,553 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,096 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,748 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,096 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,748 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,096 Reputation points Microsoft Vendor