SQL Server

Velo Credit CustOmeR care Toll-free Number)+91) 7866069405 //((((/(call))))//-/// call(/ 7866069405.

Haha your your mom said said he just don't don't

SSMS not flagging basic errors after IIF statement

I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then realized that no errors showed…

SSMS Issue for Local Connection

Hi,  We are facing an issue with Microsoft SQL Server Management Studio. We are unable to connect with local server.   We tried to reinstall the application, but it will run only till the system gets restarted. Once the system gets restarted, we are…

Can't connect to Azure Sql with SSMS or Azure Data Studio

I used to be able to get to me Azur Sql database via SSMS (Sql Server Management Studio) or Azure Data Studio but now I can't. Firewall rule error The server you specified x does not exist in any subscription in y Either you have signed in with an…

Unable to connect SQL server to Azure data factory

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-1J7NBOS', Database: 'DataWarehouse', User: 'ak2'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the…

Locking comparison SQL Server 2017 versus SQL Server 2022

We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…

Is it correct to make connection string dynamic?

Hi, I'm currently working on a project which need data from other databases. The database where I'll get the datas are depends on users. Now I want to make my connectionString dynamic. Is it correct to make connection strnig dynamic. The user will enter…

cant install sql server 22 on windows 11

Im trying to install sql2022 on windows11, Error installing SQL Server Database Engine Services Instance Features The system cannot find the path specified Error code: 0x80004005 i tried troubleshoooting didnt help.

¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )?

¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )? Secuencia del tiempo Se toma la decisión de ordenar licenciamiento de productos usados en la nuestra compañía, Microsoft, Adobe y otros A fines del año 2017 compramos una…

AKS deployed application to access on-prem server

Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…

while installing sql server developer , shows up error decompressing media server ?

how to fix "Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found" Could not find file 'C:\Windows\TEMP\fsd3ypse.dll'.

Event code: 3005 Event message: An unhandled exception has occurred. Event time: 4/29/2024 10:23:20 AM Event time (UTC): 4/29/2024 5:23:20 PM Event ID: 9b963c660c6142f28d1ee5d6ff0786a3 Event sequence: 61229 Event occurrence: 6 Event detail code: 0…

SQL Server Snapshot Agent suddenly getting error 1130 when trying to connect to Azure File Storage

I have the following SQL Server Replication Setup Publisher server is an Azure SQL Managed Instance, Subscriber server is the same server Storage is Azure File Share I'm trying to setup replication from a database on a managed instance (DB_1) to another…

SQL Server Maintenance Plan: Cleanup Task

Hello! Some time ago I noticed that my two maintenance plans were working incorrectly: the cleanup tasks that must have been deleting files older then 2 weeks had not been really deleting anything and my oldest files were ~29.02.2024. The reason was that…

Can't figure out why The select list for the INSERT statement contains fewer items than the insert list

Hi everyone, I want to create a stored procedure that will create a table and return value, but I got this message: Msg 120, Level 15, State 1, Procedure sp_Month01_FYCalendar, Line 36 [Batch Start Line 9] The select list for the INSERT…

Transactional Replication on a SQL Managed instance as a subscriber with pull subscription

We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this

We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work

Hi We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work. We have come across documention which says its has limitations onwiht regards to publisher/subscriber and…

Reclaiming free space from TempDB in azure sql managed instance

the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…

How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311

We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I…

i have few snapshot transactions, now i need to put nolock/read uncommit for perticular table

hi, I have few snapshot transactions , now my admin has informed me that put no lock in all tables in snapshot transactions, as it was blocking locking deadlocking with others. so I suggested to put read uncommited instead of snapshot when u are…