Microsoft Q&A

SQL Server

14,825 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

6,034 questions with SQL Server-related tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

MS SQL 2019 Developer Edition Download Link

Hi, I'm trying to find link for MS SQL 2019 Developer Edition. But all links lead to https://www.microsoft.com/en-us/sql-server/sql-server-downloads where SQL 2022 is. Where can I find link to download SQL 2019 Dev?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-07T16:31:34.9033333+00:00
Pavel.Dyachuk 136 Reputation points
accepted 2023-02-08T09:12:04.2166667+00:00
Pavel.Dyachuk 136 Reputation points
7 answers One of the answers was accepted by the question author.

indexes in view

Hi Expert, How to create indexes in view as it is taking more than hour to run alter view view1 as select col1,col2,col3... from table1... total 35 columns

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 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.
8,591 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,132 questions
asked 2023-02-02T16:38:54.7266667+00:00
Shambhu Rai 726 Reputation points
accepted 2023-02-08T07:43:55.8+00:00
Shambhu Rai 726 Reputation points
3 answers One of the answers was accepted by the question author.

index not exists

After removing the indexes from the table, using the sys.indexes query, the removed indexes are still displayed. Although the deleted indexes do not exist in the table index folder. If this query is Join with sys.partitions, we will have the output of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-06T16:23:10.3333333+00:00
MohammadAmin Moazami 0 Reputation points
accepted 2023-02-08T05:29:47.9033333+00:00
MohammadAmin Moazami 0 Reputation points
3 answers One of the answers was accepted by the question author.

[SSRS] How to get detail error message by table :ExecutionLogStorage

I execute SQL without error message detail , only Status rsProcessingAborted : SELECT B.Path ,a.* FROM [ReportServer].[dbo].[ExecutionLogStorage] A,[ReportServer].[dbo].[Catalog] B WHERE A.REPORTID=B.ItemID AND B.Path ='Reportpath' ORDER BY…

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,132 questions
asked 2023-02-07T09:30:23.36+00:00
ShaoYu Hung(洪紹渝) 20 Reputation points
answered 2023-02-08T03:01:56.4466667+00:00
ShaoYu Hung(洪紹渝) 20 Reputation points
3 answers One of the answers was accepted by the question author.

Can an INSERT statement block SELECT ?

Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can anyone help me understand in what scenarios it may happen? Thanks, Sam

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-05T12:05:08.78+00:00
Samantha r 406 Reputation points
commented 2023-02-07T22:41:53.9533333+00:00
Erland Sommarskog 68,536 Reputation points MVP
4 answers One of the answers was accepted by the question author.

can replication be limited to just some tables in the db?

hi , can replication be limited to just some tables on the db or must it be on the entire source db? and if the source has timestamps, will there be any problem for sql to keep them as is on the target/replicated db?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-01-26T13:10:53.7766667+00:00
db042190 1,416 Reputation points
accepted 2023-02-07T16:23:52.1466667+00:00
db042190 1,416 Reputation points
2 answers One of the answers was accepted by the question author.

Change Tracking - Multiple xdes_id in table [sys].[dm_tran_commit_table] for the same commit_ts

Change Tracking is activated on a Microsoft SQL Server 2012 To get the Commit Date of the changes we LEFT JOIN on table [sys].[dm_tran_commit_table] FROM CHANGETABLE(CHANGES [Grf].[ChangementStatut], 55169) ct LEFT OUTER JOIN…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant 1 Reputation point
commented 2023-02-07T13:54:02.9466667+00:00
Steve Toutant 1 Reputation point
1 answer One of the answers was accepted by the question author.

database reference for Linked Server Object

Hi all, I imported a SQL Server 2016 database into a VS 2022 SQL Server Project and the import finished without exceptions. When I tried to build the project, though I got a whole bunch of warnings about non existent referenced objects and that is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-03T13:32:39.6266667+00:00
VASILIANU Vlad -C I O 20 Reputation points
accepted 2023-02-07T12:26:11.4666667+00:00
VASILIANU Vlad -C I O 20 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server (SSMS) not listing all of the network servers

Using SSMS on the network server (which contains the network server DB) and laptop workstations, when executing SSMS on the network server, it only lists itself when selecting "Browse for more on the "Server Name" pull-down menu. However,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-04T01:57:36.94+00:00
Giacomo Raucci 81 Reputation points
answered 2023-02-07T11:18:55.79+00:00
Giacomo Raucci 81 Reputation points
9 answers One of the answers was accepted by the question author.

join 3 views in one view

Hi Expert, i wanted to join three views in one using temp table i.e. Create view test1 as select col1,col2 into #temp1 from view1 select col1,col2 into #temp2 from view2 select col1,col2 into #temp3 from view3 select col1,col2 from #temp1 a join #temp2 b…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 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.
8,591 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,132 questions
Azure SQL Database
asked 2023-02-03T04:01:38.42+00:00
Shambhu Rai 726 Reputation points
accepted 2023-02-07T07:08:50.6033333+00:00
Shambhu Rai 726 Reputation points
1 answer One of the answers was accepted by the question author.

Maintenance on Mirroring witness server

Hi I have couple of automatic failover mirroring setups and a single host which acts as a witness for all the mirroring set up I have. Now I am planning a maintenance window on my witness server. I want to study the impact on my mirroring setup when my…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-03T16:37:56.2533333+00:00
udhayan d 131 Reputation points
accepted 2023-02-06T20:19:15.5733333+00:00
udhayan d 131 Reputation points
2 answers One of the answers was accepted by the question author.

Entity Framework Core can't create migrations table using created login

I am doing a some training with .Net 6.0, C# and Entity Framework Core. I got to the point that EF can generate a new migration but hen I run dotnet ef database update I am getting an error: Failed executing DbCommand (38ms) [Parameters=[],…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,028 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
429 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
643 questions
asked 2023-01-22T07:41:22.5733333+00:00
Yiyi Chen 20 Reputation points
commented 2023-02-06T10:37:20.4166667+00:00
Yiyi Chen 20 Reputation points
2 answers One of the answers was accepted by the question author.

WITH common_table_expression

Dear All, I'm using SQL server 2016. On the page Microsoft Documentation, I see the following code. However, I don't understand the meaning of the paragraph under the heading CTE_query_definition. Could anybody tell me the meaning of this paragraph? […

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-02T03:34:57.56+00:00
Anonymous
accepted 2023-02-06T08:41:44.3166667+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

blocking behaviour using hints

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried to check with application team, they said they are using with (ROWLOCK) hint in most cases. So, I tried to repro but not able to reproduce the issue of SELECT with…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-01T19:42:31.68+00:00
Samantha r 406 Reputation points
commented 2023-02-05T06:10:32.8766667+00:00
Samantha r 406 Reputation points
4 answers One of the answers was accepted by the question author.

How to move SQL server database to another drive

Hi How to move SQL server database to another drive? I tried before by making offline, move physical database file and make online again but it failed, please help

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-03T12:00:47.7266667+00:00
Hossam 20 Reputation points
accepted 2023-02-04T10:28:23.35+00:00
Hossam 20 Reputation points
2 answers One of the answers was accepted by the question author.

Help in Formatting without mentioning column name in SQL

Hi, How I can get the following desired result without mentioning column's name in the query. Select * from country CCode CName CPost CDest CSET CPOS CJOH 001 AU L1 RE 1 2 …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-01-25T18:15:20.3533333+00:00
Kenny Gua 291 Reputation points
accepted 2023-02-04T03:36:50.7266667+00:00
Kenny Gua 291 Reputation points
2 answers One of the answers was accepted by the question author.

TSQL Convert Binary64 text to an image so it can displayed in reports

We have some code, as follows which we are trying to convert Base64 string to an image so that it can be displayed in reports. However, in SSRS, we get the following error message when trying to display the image: What needs to be changed in this…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
asked 2023-02-03T16:42:26.8833333+00:00
vsslasd 466 Reputation points
answered 2023-02-03T20:49:54.9966667+00:00
vsslasd 466 Reputation points
2 answers One of the answers was accepted by the question author.

Can Microsoft SQL Server 2019(RTM) be restored on 2016 SQL Server?

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) Using management studio 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.
8,591 questions
asked 2023-02-01T03:48:50.6433333+00:00
Avyayah 1,146 Reputation points
accepted 2023-02-03T19:33:31.2433333+00:00
Avyayah 1,146 Reputation points
1 answer One of the answers was accepted by the question author.

SSIS package Error: Cannot create a task from XML for task "Script Task", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".

Hi, I get error while running DTExec.exe in cmd which executes SSIS package. The SSIS package job runs well when I run in VS 2019 manually, but throws error from cmd. command I have executed in cmd: "C:\Program Files\Microsoft SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
asked 2022-10-28T02:58:48.42+00:00
TC 41 Reputation points
commented 2023-02-03T16:35:21.3366667+00:00
Rajanand Ilangovan 1 Reputation point
2 answers One of the answers was accepted by the question author.

Unable to access unc shared folder remotely using pull subscription of snapshot replication

What could be the possible causes for a pull subscription of snapshot replication unable to access the unc shared folder remotely but a pull subscription is able to access the unc shared folder and replicate successfully? Where do I troubleshoot at…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 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.
8,591 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
368 questions
asked 2023-01-05T10:32:13.933+00:00
Cindy See 141 Reputation points
accepted 2023-02-03T09:58:53.1033333+00:00
Cindy See 141 Reputation points