Will CRED refund money?
Hello sir please send me Cred amount refund immediately contact us= 09676-87-0728 = credit card rent payment bill due payment amount recharge any ...9676-87-0728..
How can I talk to redBus Executive?
How can I talk to redBus Executive?Redbus ✅786-50-49-864✅ Executive no problem ✅786-5049-864✅
SQL Server 2019 NULL default constraint for nullable column
I have to take care of a SQL Server 2019 database. What I found is that a lot of the exisiting tables have nullable columns and even though an additional NULL default constraint. Here an example: CREATE TABLE [dbo].[Customer]( [ID] [INT]…
JavaScript not working with ssrs report in edge
I working with an ssrs document and have images with a go to url that I inserted a JavaScript javascrpt:void(window.open http:\ the command completed works on a url command line within edge but if I click on the item nothing happens with the ssrs…
I have a trouble in creating sql server for the region (US) east US.
I have a trouble in creating sql server for the region (US) east US. It is showing like , : Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go…
How to change the color of the database icon?
Dear AlI, I tried to take a database online. Then the "X" disappeared and the database icon turned to . How do we make it to its normal status?
Entity Framework Core 8, table with a user-defined data type. UDT
We are migrating a 4.5 large application which uses sql data reader to query the MS SQL database to .NET 8 EF core. The database has at least one user-defined column, code below. There is currently 20 years of data in the database. We are migrating…
SQL Merge Replication
Part of the SQL Merge Replication configuration is that a snapshot is taken. When the subscriber is joined/connected to the Distributor the merge agent applies the snapshot changes. When the publisher is first set up the Snapshot is set up on a schedule…
Configure service account in Azure SQL Server
Good morning, I have an SQL Server running on an Azure Virtual Machine, and I've been tasked with creating a 'Service Account' and configuring the SQL Server services (SQL Server and SQL Server Agent) to use this new account. Currently, my SQL Server is…
SQL Managed Instance Synching in Failover Group Stopped working
We have a primary SQL Managed Instance in a failover group with a secondary read-only Managed Instance. Has worked great for 3 years. Transactions stopped synching 4 days ago. sys.dm_geo_replication_link_status says its in CATCH_UP mode but we can see…
Data Sync between One Server to another Server
I would like know what would be the best practice to do Sync data between Prd Sql server to another server(Reportal server)? Currently, I'm taking DB backup and restore from prod to another server(Reportal server) every morning. I was thinking to do…
How to resolve timeout issue while taking SQL Server backup and what is the demerits of making SqlCommand.Timeout property to infinity and is there a way to avoid?
Hi Currently, I am doing a small research about taking backups from SQL Server using external tools that execute backup queries to take backups. Usually, the tool utilizes SqlCommand to execute backup queries along with checksum for performing backup…
Sqlserver services failed to start after applying patch KB5040948
Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 15151, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken…
SQL Server Data Masking on varchar column?
Hello, goal is to mix up the data in a given column so it becomes unrecognizable...sounds like SQL Server Data Masking would be the recommended option (or something else)? If yes Data Masking is going to be used... so as an example current data contains…
Multiple SSL certs on one server for encryption of SQL data in motion
I have a 3-node Always On cluster with 10 instances on each cluster node. Each instance has two AGs, each of those with it's listener, thus 20 listeners. I installed on each cluster node an SSL cert provided by my organization -- I think Microsoft CA. …
How to fix Query Store in READ_ONLY mode due to read_only reason 262144
We are running Microsoft SQL Server 2022 Enterprise edition version 16.0.4115.5 (X64) SQL Server has 254 Cores, 7.5 TB RAM dedicated for SQL Server SQL Server is running in HA cluster -1 primary and 3 secondary replicas (1 synchronous, 2 asynchronous…
Extracting Last Name before comma
The name in the file are coming in two different format : Ahad,Ali Abdul -- Format 1 Doe John, West -- Format 2 I am using the following derived column expression: FINDSTRING(my column," ",1) != 0 ? (SUBSTRING(my column,1,FINDSTRING(my…
SSMS : 18.12.1 and 18.6 : clicking New Query button crashes SSMS; 'SQL Server Agent' service doesn't start at all.
Hello All ! SSMS : 18.12.1 and 18.6 : clicking New Query button crashes SSMS; 'SQL Server Agent' service doesn't start at all. ============================================= OS: Windows 10 pro : version: 10.0.19044 steps: Installed SQL…
I am trying to connect with Oracle database in VS2022. When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'.Please help on this
I am trying to connect with Oracle database in VS2022 to create SSIS package. I have installed microsoft connector both 32 and 64bit.When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'.…
VS2022 report design tab blank when opening VS2017 rdl
I have a VS2017 project with SSRS .rdl files. It opens fine in VS2022 but when I open any report the Design tab is originally blank. It will display once I open a Dataset OR click to another report and back. I have searched exhaustively, and it has been…