Microsoft Q&A

SQL Server

16,361 questions

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

16,361 questions with SQL Server-related tags

Sort by: Updated
1 answer

When using Tablediff I keep getting "Unable to access database"

I have SQL 2017 Standard running on Windows 2019 in a VM as a source VM. I also have a 2nd server running SQL 2019 Enterprise running on Windows 2019. I can connect to both and use both using SSMS, including querying any table. I'm using Windows…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-05T23:07:04.31+00:00
John Hales (ROI Mailbox) 0 Reputation points
answered 2023-06-06T14:02:26.88+00:00
John Hales (ROI Mailbox) 0 Reputation points
1 answer

Money box customar care helpline number 8293195697//8904596997

Jhmnbb for the same time again later ok thanks for sharing the account to this

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,095 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.
9,820 questions
asked 2023-06-06T13:09:17.8133333+00:00
xilalap509@vndem.com 0 Reputation points
answered 2023-06-06T13:09:28.7066667+00:00
xilalap509@vndem.com 0 Reputation points
2 answers

Connecting to System Center Configuration Manager (SCCM) using PowerShell from outside the SCCM server.

Hello everyone, I am seeking assistance in connecting to the System Center Configuration Manager (SCCM) using PowerShell from a remote machine. My primary objective is to establish a connection to the SCCM's database. (I wanted to work on some query…

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
14,783 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
2,735 questions
Microsoft Configuration Manager
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
747 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.
9,820 questions
asked 2023-06-06T07:26:47.57+00:00
Swahela Mulla 45 Reputation points
answered 2023-06-06T12:34:42.8233333+00:00
Garth 5,001 Reputation points MVP
0 answers

source file path/db name ssis

Hi Expert, how to get db name or source file path from packages for an example db name/file path packagename c:\path\ xyz.dtsx dbname.tablename x.dtsx

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,083 questions
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.
9,820 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,362 questions
asked 2023-06-06T12:30:27.6166667+00:00
Shambhu Rai 876 Reputation points
2 answers One of the answers was accepted by the question author.

Why can't Entity Framework handle cascade deletes on a maybe child

I don't know if this is a SQL Server issue or an Entity Framework issue. In addition, I am reticent to say "bug" as Microsoft tests so well, but this strikes me as a potential bug (or feature limitation). This is for a political campaign…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
521 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.
9,820 questions
asked 2023-06-05T23:36:18.4366667+00:00
David Thielen 966 Reputation points
commented 2023-06-06T12:19:33.87+00:00
David Thielen 966 Reputation points
1 answer

"SQL Server uses Windows authentication login and cannot connect."

The connection to the server was successfully established, but an error occurred during the login process. (provider: SSL Provider, error: 0 - This certificate chain is issued by an untrusted authority.) Login failed for user 'DESKTOP-IGIUBK4\yaolin'.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-06T02:58:43.11+00:00
zhuang yaolin 0 Reputation points
commented 2023-06-06T11:56:43.49+00:00
Erland Sommarskog 78,261 Reputation points MVP
1 answer

Is it OK to drop the User created Statistics

Hi, We have around 4.5K stats in a DB (DB size is 1TB, SQL version 2016 STD), so when we are updating the statistics as a part of our weekly maintenance plan, it is taking around 24 hours (WITH SAMPLE 50 PERCENT) to complete. So we modified the scripts…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-06T07:41:05.2733333+00:00
Udham Singh 96 Reputation points
answered 2023-06-06T11:54:23.28+00:00
Erland Sommarskog 78,261 Reputation points MVP
0 answers

SSRS 2014 + Report Manager Error + System.InvalidCastException: Specified cast is not valid.

Hi All - I'm getting a very strange error in SSRS 2014. Both Report Manager and Reporting Service are now unavailable. I get an error - An internal error occurred on the report server. See the error log for more details. (rsInternalError). When I…

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,362 questions
asked 2023-06-06T10:53:30.71+00:00
Paul Chandran 0 Reputation points
3 answers

How to fix upgrade architecture mismatch error in SQL 2008R2

Hello Team, I'm trying to upgrade a SQL Server 2008 x64 Developer install to a 2014 x64 Developer Install. It got failed while checking the rules and throwing this error --"Upgrade Architecture mismatch" failed. Error Message from details.txt: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-05T04:39:16.6733333+00:00
Rushikumar Kuntumalla 20 Reputation points
commented 2023-06-06T10:42:21.72+00:00
Erland Sommarskog 78,261 Reputation points MVP
1 answer

The sequence of index creation will affect applications performance

The sequence of index creation will cause different query plans to be executed, resulting in a performance issue. Steps 1 : Deployment from Azure Devops Step 2: Recreate dropped index in sequence 1 as below: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-05-31T07:39:53.1666667+00:00
Maggie Teo 0 Reputation points
commented 2023-06-06T10:38:23.3566667+00:00
Erland Sommarskog 78,261 Reputation points MVP
3 answers

mssql 2022 - random incorrect syntax '(' errors

MSSQL Version Microsoft SQL Server 2022 (RTM-CU2) (KB5023127) - 16.0.4015.1 (X64) Feb 27 2023 15:40:01 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: )…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-05-23T06:55:22.1066667+00:00
Greg 0 Reputation points
commented 2023-06-06T09:57:29.52+00:00
Erland Sommarskog 78,261 Reputation points MVP
2 answers

How do I install Express SQL Server 2022?

At first everything was going well, I downloaded a couple things. But I was getting confused, so I decided to eliminate everything and restart the process. And this appears now. Can I get back to normal? Please help

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-02T18:43:47.7766667+00:00
Lau Ramírez 0 Reputation points
commented 2023-06-06T09:15:48.6433333+00:00
AniyaTang-MSFT 5,631 Reputation points Microsoft Vendor
2 answers

sql server 2022 uninstall & reinstall error.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-04T10:09:54.2466667+00:00
Sanyog Tyagi 0 Reputation points
commented 2023-06-06T09:14:57.54+00:00
AniyaTang-MSFT 5,631 Reputation points Microsoft Vendor
4 answers

View taking long time for exevution

Hi Can anyone help me on to identify the issue related view. It is taking long time for execution when calling a view with condition. But when running the view query with the same condition it is running fast. How can we identify the cause of slowness.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-05T15:18:57.0266667+00:00
SVA 86 Reputation points
answered 2023-06-06T08:15:06.06+00:00
SVA 86 Reputation points
2 answers

Missing Stored Procedures in Linked Server view within SSMS

Why am I unable to see Stored Procedures or functions when I open a Linked Server in SSMS? I have created the Linked Server and can see the databases, but within each database, only tables and views are shown. The Linked Server is connected to another…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-02T06:56:28.3833333+00:00
Talal Hallaj 0 Reputation points
commented 2023-06-06T07:21:40.2766667+00:00
Talal Hallaj 0 Reputation points
2 answers

SQL server number of data files per file group

hi experts on prem SQL version : 2019 Virtual VM machines/ alwayson enabled use it: OLTP system We have large database over 1.5TB database on 10 datafiles . each 200gb aprox. could any one confirm any limitation or performance impact holding all data…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-05T02:16:10.3166667+00:00
Ashwan 521 Reputation points
commented 2023-06-06T06:29:05.7033333+00:00
Olaf Helper 29,041 Reputation points
1 answer

How to reduce run time when running Report Builder report using Parameter ?

Hi Team, I have a query which runs in less than a minute in MS SQL Server but takes ~60 min to run in MS Report Builder with the same connection. One difference I make in query is that : for MS SQL server, where clause looks like this where…

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,362 questions
asked 2023-06-05T12:54:02.1533333+00:00
Prem chander 0 Reputation points
answered 2023-06-06T05:44:27.78+00:00
AniyaTang-MSFT 5,631 Reputation points Microsoft Vendor
1 answer

Azure SQL data pool access for user

Hello I have a recent issue. Recently I was creating new sql databases from elastic pool and we have 2 users in database master -like slqadmin* and sauser* ( example) 1st is given by default by Azure and second is application user. Before recently all…

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.
9,820 questions
asked 2023-06-05T14:56:21.0333333+00:00
Kostiantyn Bezruchenkov 0 Reputation points
answered 2023-06-06T04:23:18.5233333+00:00
ShaktiSingh-MSFT 7,136 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

SQL is NULL

Hello, i have a column and this column can be fill with any decription and NULL value. When i make a filter to showing all records with 'NOT CAPTURED' on the column, why record with NULL value also filtered? We can see below when i put commend on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-06T00:47:07.8+00:00
Handian Sudianto 2,096 Reputation points
accepted 2023-06-06T02:00:28.26+00:00
Handian Sudianto 2,096 Reputation points
2 answers

Can Foreign Keys be Null?

Hello, According to me, FKs can't be null as otherwise It will violate the Foreign Key constraint. FK refers to primary key and Primary key can't be null. Can you help me understand this better?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,820 questions
asked 2023-06-05T12:07:19.8766667+00:00
sonal khatri 21 Reputation points
answered 2023-06-06T01:57:56.8333333+00:00
CosmogHong-MSFT 11,881 Reputation points Microsoft Vendor