sstpl कैश लोन कस्टमर केयर नंबर 8249583099 // 6304082019/
BCA 5th odi match prediction of devices allowed by the
Small credit CusTomeR Care Toll+Free number 6304082019//8249583099. nn
You are the best sir please aap
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…
AA Game Customer Care Helpline Number (+91) 9827487724 (9831228895/. Call me.
A good day have a good day have a good day have a great day have a good time with my family
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…
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…
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…
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
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…
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…
How to install SQL Server in windows 11? I'm getting error code : 2061893606 while installing.
Could you plz help me with this error. how to fix it..?
Getting the Integration run time error while created the linked service for Sql server in datafactory
Getting the Integration run time error while created the linked service for Sql server in data factory, can anyone help to solve this error Cannot connect to SQL Database. Please contact SQL server team for further support. Server:…