Microsoft Q&A

SQL Server

14,828 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

14,828 questions with SQL Server-related tags

Sort by: Updated
2 answers

Database Mirroring Doubt

I read that in Database Mirroring, every transaction on primary database is replicated to mirror database. I have a doubt here. The mirror database is not accessible, so how the mirror database gets updated?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-06T06:00:59.36+00:00
Chaitanya Kiran 576 Reputation points
commented 2023-02-08T01:52:39.8933333+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
1 answer

How to uninstall SQL,because it won't let me.\

TITLE: Remove SQL Server 2019 ------------------------------ There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom of the setup page, then provide valid parameters. ------------------------------…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-05T18:38:27.5866667+00:00
Buta443 0 Reputation points
commented 2023-02-08T01:51:47.6933333+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
2 answers

Is there an issue if back up of SQL Express DB is restored on MS SQL Server DB?

Is there an issue if back up of SQL Express DB is restored on MS SQL Server DB?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-03T12:27:15.4033333+00:00
Shrihari Sondur 0 Reputation points
commented 2023-02-08T01:50:45.9133333+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
4 answers

asp.net setup doubts

Hello We Have developed one small web application which has aspx page and cs file c# as a code behind. We use database as sql express 2008 R2 Microsoft SQL Server Express Edition with Advanced Services ( sql server management studio …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
1,211 questions
asked 2023-02-03T11:07:51.19+00:00
RAVI 256 Reputation points
commented 2023-02-08T01:50:13.4866667+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
2 answers

SSIS tool tips are not disappearing VS2019 16.11.22

Various tags pop-up, seemingly at random, when I'm editing an SSIS package. They often stay there for quite a while always at the front of the screen as I move the VS window around. If I select another app, they disappear. In the case of this…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,457 questions
asked 2023-02-07T21:10:17.8966667+00:00
Nick Ryan 366 Reputation points
answered 2023-02-08T01:44:49.7133333+00:00
ZoeHui-MSFT 18,896 Reputation points
4 answers

How to fix ODBC error 772 windows 11 22H2

ODBC connection with sql server 2005 (compatible 2000) failed after november update. January update didn't fix the problem. Already tried with installing newer version of the ODBC driver, but this didn't work. Anyone any other idea ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-01-11T11:19:04.2766667+00:00
Kristine Heyman 5 Reputation points
answered 2023-02-08T00:57:38.16+00:00
Gordon Harris 0 Reputation points
1 answer

How to prevent SQL Server from adding additional parenthesis and changing the definition of a column on it's own when executing a create table script

We have to change the increment value and reseed the identity definition for columns on several tables within one of our databases.  We accomplish this by using the, “alter table ‘X switch ‘Y“, command which allows us to merely switch the partition from…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-05T19:31:12.1966667+00:00
Alex Wergeles 0 Reputation points
commented 2023-02-07T23:14:01.62+00:00
Alex Wergeles 0 Reputation points
2 answers

Fragemented indexes

Hi All, Is there a way to tell at what level the index pages are fragmented ? is it leaf level or intermediate levels of the index is fragmented? just a side note, does sys.dm_db_index_physical_stats () show us leaf level fragmentation or does it shows…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T07:26:19.8366667+00:00
Samantha r 406 Reputation points
answered 2023-02-07T23:01:54.9233333+00:00
Erland Sommarskog 68,536 Reputation points MVP
3 answers One of the answers was accepted by the question author.

Can an INSERT statement block SELECT ?

Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can anyone help me understand in what scenarios it may happen? Thanks, Sam

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-05T12:05:08.78+00:00
Samantha r 406 Reputation points
commented 2023-02-07T22:41:53.9533333+00:00
Erland Sommarskog 68,536 Reputation points MVP
4 answers

SQL Tempdb taking up space

Hi friends, we have two synchronous and one asynchronous sql 2016 servers with Always On. Our tempdb are six files in one volume on one disk and another six files on another disk for a total of 12 files. During the early morning routines, a curious…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-05T00:36:15.62+00:00
Sandro Alves 41 Reputation points
commented 2023-02-07T22:35:09.28+00:00
Erland Sommarskog 68,536 Reputation points MVP
3 answers

Why does sys.dm_hadr_cluster return a row on SQL 22 on Linux when AlwaysOn is enabled?

Hi folks- I have a SQL 22 on Windows instance and a SQL 22 on Linux instance. I have enabled AlwaysOn on both and created a read-scale/clusterless AG that spans the two. When I query sys.dm_hadr_cluster on Linux, I receive the following…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-02T18:34:09.6133333+00:00
Brandon Tucker 6 Reputation points
commented 2023-02-07T22:17:15.2633333+00:00
Erland Sommarskog 68,536 Reputation points MVP
2 answers

Two node Always On cluster setup

Hi All, SQL Server 2019 - CU18 Windows 2019 - 2 Node Cluster. 8 CPU Cores - 96GB RAM --> Would this CPU and RAM be sufficient ? Have around 120 databases with total size of 350GB and a very busy processing with over 2000 connections to the databases…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-03T05:58:02.5366667+00:00
Carlos D 21 Reputation points
commented 2023-02-07T22:12:48.7+00:00
Erland Sommarskog 68,536 Reputation points MVP
2 answers

How to put DB in signle user mode which is in Cluster

Hi Team, As part of some activity, i am planning to put SQL DB in single user mode? This is SQL Cluster (Active/Passive). What is the procedure?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-06T18:46:00.01+00:00
Vijay Kumar 1,851 Reputation points
commented 2023-02-07T21:57:50.8833333+00:00
Erland Sommarskog 68,536 Reputation points MVP
2 answers

The SELECT permissions was denied on the object 'dm_os_host_info', database 'mssqlsystemresource, system

Hi Team, Recently i am working on one test server, by mistakenly i revoked some permissions. After that when i try to login i am getting error and i don't have any login account(Systadmin) to login to the server. Please suggest me how to fix that. I do…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-05T18:32:17.36+00:00
Vijay Kumar 1,851 Reputation points
commented 2023-02-07T19:29:14.62+00:00
Vijay Kumar 1,851 Reputation points
4 answers One of the answers was accepted by the question author.

can replication be limited to just some tables in the db?

hi , can replication be limited to just some tables on the db or must it be on the entire source db? and if the source has timestamps, will there be any problem for sql to keep them as is on the target/replicated db?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-01-26T13:10:53.7766667+00:00
db042190 1,416 Reputation points
accepted 2023-02-07T16:23:52.1466667+00:00
db042190 1,416 Reputation points
1 answer

SSRS permissions issues.

Greetings. I have a group of folks that I want to allow the ability to author reports within specific folders only. Within the home/ folder1 structure they have the Browser role. Within the home/ folder1/ custom structure they have all roles possible.…

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,132 questions
asked 2023-02-03T22:19:54.0633333+00:00
chrisrdba 276 Reputation points
commented 2023-02-07T14:33:17.4766667+00:00
chrisrdba 276 Reputation points
2 answers One of the answers was accepted by the question author.

Change Tracking - Multiple xdes_id in table [sys].[dm_tran_commit_table] for the same commit_ts

Change Tracking is activated on a Microsoft SQL Server 2012 To get the Commit Date of the changes we LEFT JOIN on table [sys].[dm_tran_commit_table] FROM CHANGETABLE(CHANGES [Grf].[ChangementStatut], 55169) ct LEFT OUTER JOIN…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant 21 Reputation points
commented 2023-02-07T13:54:02.9466667+00:00
Steve Toutant 21 Reputation points
3 answers

SSIS incorrect connection string format (intermittently)

I have migrated SSIS project from SQL server 2017 to SQL Server 2019. In this project connection strings are loaded dynamically from database - there are always 8 databases through which it iterates. After migration to SQL 2019 I periodically receive…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
asked 2022-11-23T19:10:08.22+00:00
Edgars Francis 1 Reputation point
commented 2023-02-07T13:44:28.4833333+00:00
Yitzhak Khabinsky 20,021 Reputation points
4 answers

SSRS report - Toggle column

I know I can toggle column's visibility based on another item. That means the other item would have a plus sign for a user to click on. What I want is to use the same toggle mechanism to collapse a column but without user interaction. Another words, to…

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,132 questions
asked 2023-02-04T12:36:37.15+00:00
Zolotoy 191 Reputation points
commented 2023-02-07T13:27:41.5866667+00:00
Zolotoy 191 Reputation points
1 answer One of the answers was accepted by the question author.

database reference for Linked Server Object

Hi all, I imported a SQL Server 2016 database into a VS 2022 SQL Server Project and the import finished without exceptions. When I tried to build the project, though I got a whole bunch of warnings about non existent referenced objects and that 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.
8,594 questions
asked 2023-02-03T13:32:39.6266667+00:00
VASILIANU Vlad -C I O 20 Reputation points
accepted 2023-02-07T12:26:11.4666667+00:00
VASILIANU Vlad -C I O 20 Reputation points