How do I get a refund from citMsll?
How do l get a refund from citMsll? In order to return, please create a refund/return request or request a call back from our supportteam 0'9234'320'841 on Citymall mobile application within the time period specified in the Table below..??In order to…
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Protocol Error in TDS Stream in SSIS - connected host has failed to respond
Hello, We are having issue when we are running SSIS package and getting following error: Code: 0xC0202009 Source: Sync Details Data FLow sqlssis OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Application unable to connect to Listener intermittently on port 1433
We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the error…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
unable to install sql server exit code -2068052377
I was using 2018 ssms with sql server and it worked up to a few days ago. I've tried several ways to fix this. I ran repair setup and goes thru the repair but still have the issue. I uninstall and reinstall. I check service.msc and and tried to…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Visio Professional 2019 Currently selected visio driver is not compatible with data source.
I am using brand new copy of Visio Professional 2019, and SQL Server version 15.0.2080.9, both installed on a stand-alone Windows 10 machine. I am using the Reverse Engineering wizard. No matter what ODBC driver I select, or what level DSN it is…
Recover Resource Group and SQL Server and SQL DB within
I deleted an old Resourge Group with SQL DB within, can i recover within Azure Portal? We have no Backups.
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
SQL Server 2019 Maintenance Plan Tasks Toolbox Missing
Unable to add tasks to new maintenance plan because there is no Maintenance Plan Toolbox. How can we create or recover this Toolbox? This is a new install of SQL 2019 and first time adding maintenance plan on this server.
Is there a 64 bit SSMS?
I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…
![](https://techprofile.blob.core.windows.net/images/x_JVNt_k6k-PHRUMl2BAqg.png?8D9BFE)
Bacpac file won't restore due to columnstore indexes on columns with specific data types.
Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Server infected with arthur virus
Server infected with arthur virus. all file extensions are with ,arthur . I need help knowing if I can access data from another server, I am currently on "East US 2" and want to use the "west us" backup. What recommendations do you…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Discrepancy in results when running TSQL query with iif
Hi, SQL server version: running on Azure Sql Database 12.0.2000.8 RTM SQL Azure DB compatibility level 160 I am getting discrepancy with the following results, the same thing with case statement, and with patindex. declare @inputString nvarchar(max)…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
MY SQL SERVER INSTALLATION ERROR
Hello everyone, I'm currently on Win11 Pro 23H2. I have installed and uninstall My SQL express couple times but having no luck in success installation. I didn't know the cause of this issue. Hope you guys could get me a possible fix Thank you and Best…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Questions about always on’s data synchronization method
Hello I am curious about data synchronization of secondary in always on. Secondary confirmed that the redo thread reads the log cache or redo log file and synchronizes it to the data file and index file. I have doubts about the synchronization method…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
SQL Server 2022 Developer Edition failing install with error code -2068052310
I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found and giving me the exit code -2068052310. I've downloaded and…
![](https://techprofile.blob.core.windows.net/images/f-pBqnyG00GUoUNG0-bOmg.png?8DC43D)
Server container is always restarting
We are deploying our backend using an Azure web app. We decided not to use serverless Azure Functions based on our experience with Firebase functions, as they usually do not allow file uploads within the same application. On Azure, the problem is that…
How to talk to a SQL Database in Azure Gov from a Teams chat?
How alk to a SQL Database in Azure Gov from a Teams chat?
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Issue with SQL Server compatibility level 2022 and sp_executesql
One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)