SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,981 questions
0 answers
SQL Server 2022 upgrade fails
I have 3 instances; I was able to upgrade 2 of them no problem. However, I get a bogus error when upgrading the last one, The drive containing the sql binaries have 7GB free, the upgrade needs 115MB, yet it fails due to lack of space! Error: …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
0 answers
Permissions error in SSMS with a dataverse datalake
Hello, I'm having an issue with creating a PowerBI report - specifically connecting to a data source. I created a view in a datalake in SSMS based on dataverse data but keep experiencing this issue. My colleague cannot replicate the error and I'm not…
asked 2024-11-05T16:03:32.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 2%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jesse Ruiz
0
Reputation points
commented 2024-11-07T21:03:57.5933333+00:00
Jesse Ruiz
0
Reputation points
0 answers
how to manage existing transactional replica database table using SQL management
Today i have done transactional replica database using sql management and now data is synchronizing correctly between publisher and subscriber database, Now my situation and doubts are How to add new column field to existing table in replica database…
asked 2024-11-07T20:02:28.7333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
coder rock
356
Reputation points
asked 2024-11-07T20:02:28.7333333+00:00
coder rock
356
Reputation points
1 answer
One of the answers was accepted by the question author.
Snapshot for transactional replication taking too long for large database in SQL Server Management Studio
Snapshot for transactional replication taking too long for large database (70GB) in SQL Server Management Studio, from one to anther system but when I create the publisher and the snapshot agent starts, it takes very very long time and even not…
asked 2024-11-05T18:58:31.18+00:00
coder rock
356
Reputation points
accepted 2024-11-07T19:39:06.2933333+00:00
coder rock
356
Reputation points
2 answers
Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”
Hello, I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.” I have attached a screenshot of the deployment details and included the error message…
asked 2024-11-05T09:15:43.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 41%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DoFast
26
Reputation points
commented 2024-11-07T19:01:04.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
725
Reputation points Microsoft Vendor
0 answers
I would like to start using Microsoft Teams as a ticketing system; if that is possible.
Good afternoon, my name is Frederick and I'm housing operations coordinator. I would like to start using Microsoft Teams as a ticketing system; if that is possible. Can you point me in the right direction so someone can help me set that up. Our school…
asked 2024-11-07T18:12:39.0233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Buie, Frederick D
0
Reputation points
asked 2024-11-07T18:12:39.0233333+00:00
Buie, Frederick D
0
Reputation points
3 answers
VS Version 17.11.5 - SSRS report RDLs open BLANK
Hello, Version 17.11.5 - SSRS report RDLs open BLANK I have submitted this from VS but have not received any help. It gets set to Triaged or marked as a duplicate and I have not heard back. I am a tad surprised this is not a widespread issue because…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,191 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,938 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
In the UK South region, we face SQL Server login issues. The ensureCreated method fails with “Login failed for user ‘myUsername’.”
In the UK South region, we are experiencing issues with the SQL Server login. Although we are using the correct username and password, the login fails when attempting to call the method ensureCreated from Entity Framework, we encounter the error:…
asked 2024-11-04T15:17:49.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 23%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nikithakoshy
80
Reputation points
commented 2024-11-07T17:55:35.13+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
3 answers
DB Mail issue
Hello! Maybe I forgot something... please help me please to understand the following: If I have some job that must notify email operator upon its (for example) failure - should these email notifications be sent (and received) if DB Mail is…
asked 2024-11-06T15:41:10.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hram Admin
20
Reputation points
answered 2024-11-07T17:00:26.2+00:00
Hram Admin
20
Reputation points
0 answers
Identifying Unused Tables in AAS Cube Over the Last 30 Days
I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
Why after patching latest SQL Server 2017, connection to SQL instances must entered port number?
I was patching SQL Server 2017 (svr1\insA and svr1\insB) together with following patches in the following order: KB5016884 - Cumulative update 31 (CU31) for SQL Server 2017 kb5029376 - CU Updates KB5040940 - Security update for SQL Server 2017 CU31…
asked 2024-11-07T15:35:54.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYB%3C/text%3E%3C/svg%3E)
Yee Beng Wong
0
Reputation points
asked 2024-11-07T15:35:54.9733333+00:00
Yee Beng Wong
0
Reputation points
0 answers
Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report
So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports. The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
0 answers
Unable to access Azure SQL through SSMS
We have some external client that use SSMS to access their SQL database through SSMS. Having an issue with one client. I have added their entire /24 range in the networking rules. Error A network-related or instance-specific error occurred while…
asked 2024-11-07T13:43:50.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 23%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Fazio
36
Reputation points
asked 2024-11-07T13:43:50.2166667+00:00
Jeff Fazio
36
Reputation points
3 answers
Upload and restore .bak file to Azure SQL Database from Local Machine
I have a .bak file on my machine I am trying to restore into an azure database. I then created an Azure storage/blob account to hold this file, to restore via ssms but unfortunately, the file is large (about 35GB) and crashes my machine multiple times.…
asked 2024-07-09T09:06:52.5033333+00:00
Babawale Dawodu
110
Reputation points
answered 2024-11-07T13:28:33.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 51%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Denny Webb
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Browser for SQL Server 2017 and 2019
Browser for SQL Server 2017 and 2019 Hello, my question is the following. Despite having the latest updates released for SQL Server 2019 and 2017, I notice that SQL Server Browser does not change versions, remaining in the versions mentioned below. I…
asked 2024-11-06T12:25:39.8366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 15%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rafael da Silva Salgado
20
Reputation points
commented 2024-11-07T13:23:30.65+00:00
Rafael da Silva Salgado
20
Reputation points
1 answer
Support Plans for 32-bit ODBC Driver ## for SQL Server and 32 bit Architecture (Application) on 64 bit Windows
We are in a plan to migrate our 32 bit VB6 huge 25 year old Application into 64 bit compatible application hence we would like to know, Is there any specific or formal statements regarding Microsoft long-term plans on Support Plans: The Support for…
asked 2024-11-07T06:25:26.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 51%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Suresh Balasubramanian
0
Reputation points
answered 2024-11-07T08:23:36.93+00:00
LiHongMSFT-4306
27,961
Reputation points
1 answer
How to covert UTC time to CST
I have a dataset recorded in UTC format. I want to covert it and add a field as CST. I used convert(datetime, switchoffset(convert(datetimeoffset, @UTCTime), datename(TzOffset, sysdatetimeoffset()))) to covert CST. However, I found it changed the time…
asked 2024-11-04T22:10:18.3466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 43%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%3C/text%3E%3C/svg%3E)
2956
1
Reputation point
commented 2024-11-07T07:00:33.2933333+00:00
LiHongMSFT-4306
27,961
Reputation points
1 answer
Why are ODBC statements still being registered as commits in SQL Server even though autocommit is off?
Hi, When executing (INSERT/UPDATE) statements through an ODBC driver for SQL Server, with SQL_ATTR_AUTOCOMMIT set to OFF on the connection, the autocommit behavior does reflect this, in practice. I.e., the data being updated is not available on the…
asked 2024-11-06T17:01:30.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Alex
0
Reputation points
answered 2024-11-07T06:46:11.9233333+00:00
ZoeHui-MSFT
37,446
Reputation points
0 answers
Problem in download SQL Express (ODCB driver not recognized)
Hello, my problem is simple: I want to download SQL Express locally and I'm asked to download ODCB driver. Regardless of many restarts and re/uninstalls, ODCB driver remains unrecognized and install keeps on failing (see picture below):…
asked 2024-11-06T09:44:13.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 69%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEP%3C/text%3E%3C/svg%3E)
Elja Placido De Oliveira
20
Reputation points
commented 2024-11-07T02:49:49.24+00:00
LiHongMSFT-4306
27,961
Reputation points
1 answer
One of the answers was accepted by the question author.
Problems with passing Binary as a table-valued parameter
I'm using table-valued parameters to pass binary values. I used SQLBindParameter and passed the values as SQL_C_BINARY, SQL_BINARY, BinarySize, etc. as the arguments, but when I run SQLExecute, I get an error or the result is different from what I…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,981 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,758 questions
asked 2024-11-06T01:19:40.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 96%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kwan
20
Reputation points
commented 2024-11-07T01:33:45.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 33%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rodger Kong
360
Reputation points