SQL Server

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…

Money box customar care helpline number 8293195697//8904596997

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

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…

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

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…

"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'.…

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…

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…

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: …

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: …

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: )…

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 2022 uninstall & reinstall error.

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.

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 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…

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…

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…

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…

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?