7,066 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers One of the answers was accepted by the question author.

How many ways are there to reset Windows 365 Business Cloud PC password?

1:- How many ways are there to reset Windows 365 Business Cloud PC password? 2:- Windows 365 Business Cloud PC password {not portal login password => (windows365.microsoft.com) } and M365 account passwords are the same or different. 3:- I have…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Windows 365 Enterprise
Windows 365 Business
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
5,053 questions
asked 2023-03-06T18:20:41.81+00:00
VIPIN KUMAR 20 Reputation points
accepted 2024-09-26T17:09:02.67+00:00
VIPIN KUMAR 20 Reputation points
2 answers One of the answers was accepted by the question author.

Remove last 3 charecters in column

Hi, I need to remove three characters(.00) in below table result: 111111111 without (last three characters i.e .00) chr1111111111.0011111111.0011111111.001111111111.001111111.00111111.0011111111.001111.001111111.00

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,785 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-25T07:54:04.8233333+00:00
mrrobottelg 60 Reputation points
commented 2024-09-26T09:54:56.0033333+00:00
mrrobottelg 60 Reputation points
2 answers One of the answers was accepted by the question author.

connection error

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Framework Microsoft SqlClient Data…

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,785 questions
asked 2024-09-25T14:04:16.1833333+00:00
Blessing Zinne 20 Reputation points
accepted 2024-09-26T08:41:32.7+00:00
Blessing Zinne 20 Reputation points
2 answers One of the answers was accepted by the question author.

Update statement

How to convert query into update statement... Unable to do it select rt.outstandingamount,rt.outstandingamount * TT_USD.RateMultiplier,ENTITY,FromCurrencyKeyFK,ConversionCurrencyKey,RateMultiplier from deltalake.FactARReceiptDetail RT LEFT outer JOIN…

Azure SQL Database
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,785 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-21T20:07:21.3333333+00:00
Vineet S 910 Reputation points
accepted 2024-09-26T02:32:25.3633333+00:00
Vineet S 910 Reputation points
3 answers One of the answers was accepted by the question author.

Can you update Microsoft SQL Express to a Microsoft Enterprise?

I was wanting to setup a Microsoft SQL server, and I was wondering if I initially set it up using the express version, would I be able to upgrade the server to an enterprise version, upon acquiring a license, that way I could retain the database. Also,…

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,785 questions
asked 2024-09-23T20:03:55.4933333+00:00
Holden Jolley 20 Reputation points
accepted 2024-09-25T14:12:01.54+00:00
Holden Jolley 20 Reputation points
1 answer One of the answers was accepted by the question author.

In SQL Server Reporting Services how do I add comments to a dataset query?

I am creating a report in SQL Server Reporting Services in Visual Studios 2019. When creating a query within the dataset properties, how do I add a comment line?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 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,918 questions
asked 2023-11-09T19:56:19.2233333+00:00
Stephen Schleyer 60 Reputation points
commented 2024-09-25T12:16:40.29+00:00
Chuck Roberts 105 Reputation points
1 answer One of the answers was accepted by the question author.

How to interpret deadlock xml

Here are four questions. There is no relevant information in the official documents, so I am testing and summarizing the law by myself, but I am not sure whether it is always correct, so I have come to consult you. If you have detailed information, you…

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,785 questions
asked 2024-09-25T03:18:05.1266667+00:00
博雄 胡 475 Reputation points
accepted 2024-09-25T09:55:46.4266667+00:00
博雄 胡 475 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server 2017/2019 DB backup to URL using gcp bucket

Is it possible to send the SQL Server backups to URL ( using GCP bucket) similar to Azure Blob. I used Azure blob storage but I don't see any option with GCP bucket. My requirement is - Send backup from a VM (gcp) to GCP bucket using SQL Server…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,843 questions
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,785 questions
asked 2022-05-31T20:17:38.997+00:00
Hafeez Uddin 296 Reputation points
commented 2024-09-25T07:18:30.88+00:00
Raju 20 Reputation points
1 answer One of the answers was accepted by the question author.

GCP VM SQL Server 2016, 2017 and 2019 DB backup to URL using GCP S3 bucket

Is it feasible to transfer SQL Server database backups to a URL, specifically a GCP S3 bucket which is similar to Azure Blob storage? Our organization operates GCP VMs for SQL Server versions 2016, 2017, and 2019, and we need to facilitate the backup…

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,785 questions
asked 2024-09-25T05:18:04.1333333+00:00
Raju 20 Reputation points
edited a comment 2024-09-25T06:55:13.77+00:00
Raju 20 Reputation points
4 answers One of the answers was accepted by the question author.

Errors during build of SQL Server 2022 Projects with VS2019 Professional & AzureDataStudio

Stuck with this issue for longer time. I am trying to create SQL Server Projects for a DB being in SQLServer2022 using VS2019 Professional. DB is old running/being in use since 2009. How much ever I try I face the following warnings & errors, but…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
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,785 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
114 questions
asked 2024-09-18T06:08:31.24+00:00
Radhai Krish 216 Reputation points
accepted 2024-09-25T05:06:58.87+00:00
Radhai Krish 216 Reputation points
2 answers One of the answers was accepted by the question author.

How to get License information from SQLServer installer

We are using SQLServer in our on-prem product. We need to declare open source license of all the dependencies. How can FOSSA extract license from the installer programmatically without manual installation?

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,785 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
95 questions
asked 2024-09-24T08:45:24.0366667+00:00
Lavika 20 Reputation points
accepted 2024-09-25T05:01:45.4566667+00:00
Lavika 20 Reputation points
3 answers One of the answers was accepted by the question author.

How to Update-Database in PM console when getting "Could not load assembly..." error?

Hello, I cannot apply migrations to database by Package Manager Console command Update-Database. On every attempt I get error: Could not load assembly "My_Project". Ensure it is referenced by the startup project 'My_Project'. Before mentioned…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
741 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,553 questions
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,785 questions
asked 2024-09-13T13:56:24.9266667+00:00
Filip Veselý 20 Reputation points
edited the question 2024-09-25T03:15:06.13+00:00
Jack J Jun 24,491 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

DB CM_log.ldf with large size

Hi, I have sccm in the Always On availability group, the CM database size = 5GB but the log file CM_log.ldf = 50GB, how can i reduce the size? thanks.

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,785 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2021-11-04T19:00:52.04+00:00
Lazher YAAKOUBI 381 Reputation points
commented 2024-09-24T22:51:07.3033333+00:00
Vinith Singh 0 Reputation points
2 answers One of the answers was accepted by the question author.

SSMS select count 3billion errors out -

Hi there, First time one of my tables is 3 Billion records. When i queried table count in SSMS select count(*) from table i got the below error. Does it mean SSMS cant provide row count for tables greater than 2.5 Billion (max int range) rows? How to…

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,785 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,088 questions
asked 2024-09-23T21:33:22.1833333+00:00
RJ 166 Reputation points
commented 2024-09-24T21:29:22.7633333+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Processing monthly Partition from SQL Job using Stored Procedure

Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…

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,785 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
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,785 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant 125 Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant 125 Reputation points
1 answer One of the answers was accepted by the question author.

Processing monthly Partition from SQL Job using Stored Procedure

Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…

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,785 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
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,785 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant 125 Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant 125 Reputation points
1 answer One of the answers was accepted by the question author.

Issue with Unrestricted Telnet Access to Azure SQL Database Server Despite Firewall Rules

I have provisioned an Azure SQL Database server and configured the server security settings as follows: Public access: Selected "Selected Networks" Firewall rule: Whitelisted public IP addresses to allow access to the database However, when…

Azure SQL Database
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,785 questions
asked 2024-09-20T02:36:53.1133333+00:00
Mithila Lishan 166 Reputation points
accepted 2024-09-24T10:36:04.6466667+00:00
Mithila Lishan 166 Reputation points
2 answers One of the answers was accepted by the question author.

Convert Julian dates in Normal date

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

Azure SQL Database
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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
Azure SQL Database
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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-19T18:36:21.3566667+00:00
Vineet S 910 Reputation points
accepted 2024-09-23T18:47:18.9466667+00:00
Vineet S 910 Reputation points
2 answers One of the answers was accepted by the question author.

Convert Julian dates in Normal date

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

Azure SQL Database
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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
Azure SQL Database
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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-09-19T18:36:21.3566667+00:00
Vineet S 910 Reputation points
accepted 2024-09-23T18:47:18.9466667+00:00
Vineet S 910 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Database and TLS 1.2

Hello, I received an email regarding transitioning to TLS 1.2 by 31 October 2024. I use Azure SQL databases SQL servers, I am not sure if I need to do anything to the SQL database or the SQL server regarding this transition. Please let me…

Azure SQL Database
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,785 questions
asked 2024-09-20T17:17:17.2+00:00
Hesham Eldeeb 20 Reputation points
commented 2024-09-23T17:11:57.1766667+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee