Microsoft Q&A

SQL Server

14,702 questions

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

14,702 questions with SQL Server-related tags

Sort by: Updated
0 answers

How to pass an Image as a parameter to an SSRS Report

Hello, We need to pass an image as a parameter to an SQL SSRS Report. How would this be done since there is only a date, number, bit and text type for SSRS parameter types ? Thank you

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,102 questions
asked 2023-01-31T20:50:06.0033333+00:00
vsslasd 446 Reputation points
1 answer

BULK INSERT with FIELDQUOTE

Can someone tell me why this doesn't work? Using SQL Server 2019. SSMS v18.1. FieldQuote option does not seem to be recognised by SSMS as it remains black rather than changing to blue for keywords. My data is as follows:- 12345, 124, "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,498 questions
asked 2023-01-31T16:38:57.29+00:00
JamesProsser 1 Reputation point
edited an answer 2023-01-31T20:42:29.2633333+00:00
Yitzhak Khabinsky 19,856 Reputation points
1 answer

SQL Server Migration Assistant for DB2 - Unable to connect using connection String Option

Trying to connect my Db2 server to the newly installed SSMA (V9.2). I have MS OLEDB installed (v6) and can connect successfully with the client however I can't run a samply query in MS OLEDB. In both tools, I'm getting the following error message:…

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.
366 questions
asked 2023-01-27T18:26:02.4666667+00:00
Amy Johns 0 Reputation points
commented 2023-01-31T19:20:06.4+00:00
Amy Johns 0 Reputation points
3 answers

Azure SQL DB audit stops working.

Greetings. I have a very simple Azure SQL DB audit that works exactly as expected... then stops overnight for some reason. So I can define my audit and confirm that it's set correctly: Set-AzSqlServerAudit -ResourceGroupName "myRG"…

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,498 questions
Azure SQL Database
asked 2023-01-31T17:29:31.43+00:00
chrisrdba 276 Reputation points
edited an answer 2023-01-31T18:55:19.16+00:00
chrisrdba 276 Reputation points
1 answer

Error installing SQL Server: Exit code(Decimal):-2061893606 Error description: Wait on the database Engine recoveryhandle failed SQL installation failed

Hello, I have been having issues installing the sql server The error log I got is pasted below Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: …

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,102 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,498 questions
Azure Database for PostgreSQL
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.
999 questions
asked 2023-01-31T09:39:28.58+00:00
Olusoji Daniel 0 Reputation points
edited the question 2023-01-31T17:44:54.65+00:00
Jeff McCashland 476 Reputation points Microsoft Employee
0 answers

Error Message in SQL Import and Export Wizard

I'm trying to import data into my SQL Server using SQL Server Import and Export Wizard and I keep getting this error message: TITLE: SQL Server Import and Export Wizard Could not retrieve table list. ADDITIONAL INFORMATION: A network-related or…

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,498 questions
asked 2023-01-31T17:24:36.2533333+00:00
KJP 0 Reputation points
0 answers

Odata Source in Foreach Loop Container

I am trying to migrate the data from the same table for 15 companies in Odata Source using Foreach Loop Container (the number of companies may change). But, I have difficulties in making this process dynamic. I will appreciate if you can you share your…

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.
366 questions
asked 2023-01-31T17:03:04.5333333+00:00
Yod 0 Reputation points
6 answers

Migration of SQL Server 2016 to new Windows Server 2019 Standard Machine

Hi, We are planning to migrate all of our Windows Server 2012 R2 Standard to Server 2019 Standard. For this, we will have to migrate our SQL server 2016 (2 instances Running in windows cluster) to new Windows Server 2019 Standard server machines. We…

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,498 questions
asked 2020-10-20T12:02:51.88+00:00
ahmed qureshi 21 Reputation points
commented 2023-01-31T17:00:56.79+00:00
MK@BWT 0 Reputation points
5 answers

Replication Monitor not working

Hi everyone, I recently noticed that replication monitor is not working properly. Whenever I try to launch it, the icon shows in the Taskbar of my indows but the application never actually open. Anyone with similar issue, please advise

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,498 questions
asked 2021-10-01T20:36:18.02+00:00
tobz 161 Reputation points
commented 2023-01-31T16:56:58.8933333+00:00
Shawn Joyce 0 Reputation points
2 answers

How to access the SSRS report from another computer?

I have created a SSRS report on my local computer. Now I want to access (view) that report from another computer. Is it possible? If yes, please kindly suggest to me the procedure for that.

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,102 questions
asked 2023-01-30T04:06:36.5833333+00:00
keshar joshi 0 Reputation points
commented 2023-01-31T16:20:37.5033333+00:00
keshar joshi 0 Reputation points
1 answer

Is there a way to check whether my nonclustered indexes are rebuilt while I rebuild my clustered index

Hi There, Is there a way to check whether my nonclustered indexes are rebuilt or not while I rebuild my clustered index. I just cant rely on create date and modified date in sys.all_objects. I am using create unique clustered index..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,498 questions
asked 2023-01-31T13:30:36.9866667+00:00
udhayan d 91 Reputation points
answered 2023-01-31T16:11:44.9066667+00:00
Zahid Nadeem 101 Reputation points
2 answers

how to get entries for a specific date?

Good morning all, We have MSSMS and our tables we have TimeStamp columns which are set as datetime. How can we select entries based on a specific date apart from using the below? SELECT * FROM table WHERE TimeStamp < '2021-09-03 23:59:59.999' AND…

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,498 questions
asked 2023-01-31T09:50:27.7733333+00:00
George Botonakis 0 Reputation points
answered 2023-01-31T15:59:50.44+00:00
Jingyang Li 4,366 Reputation points
2 answers

MSsql. How to find position

Hi, I have geography object which contains many LINESTRING I want to give distance from this geography object and to find the position on the geography For example: Declare @g1 geography =geography::STGeomFromText('LINESTRING(7.068419558716859…

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,498 questions
asked 2023-01-30T13:03:24.1+00:00
Lior Atzmon 0 Reputation points
edited an answer 2023-01-31T15:03:40.0933333+00:00
Viorel 82,646 Reputation points
2 answers

To eliminate duplications on some fields

Dear All, I have a table as shown below. You can see some duplications. My question is how to eliminate the duplications. The same question was asked on https://learn.microsoft.com/en-us/answers/questions/1163799/how-to-eliminate-duplication. Now the…

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,498 questions
asked 2023-01-28T07:54:11.37+00:00
Anonymous
commented 2023-01-31T14:56:29.1066667+00:00
Anonymous
3 answers

SSRS report - Export hidden columns to Excel

Is it possible to export a report into Excel with some columns being hidden but not completely removed? Thanks

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,102 questions
asked 2023-01-27T14:55:58.4833333+00:00
Zolotoy 171 Reputation points
commented 2023-01-31T14:09:27.0566667+00:00
Zolotoy 171 Reputation points
4 answers

Problems during installation of the reporting role in Configuration Manager

Greetings I'm having a problem installing the reporting role SCCM installed on server A SQL and Report service install in Server B But when I start configuring the role, it doesn't show me the name of my reporting role database I read several articles…

Microsoft Configuration Manager
Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
332 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
627 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,173 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,102 questions
asked 2023-01-30T15:42:16.4266667+00:00
Aleksandr Terekhov 21 Reputation points
commented 2023-01-31T13:57:55.1233333+00:00
Aleksandr Terekhov 21 Reputation points
4 answers

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,498 questions
asked 2023-01-26T13:10:53.7766667+00:00
db042190 1,416 Reputation points
answered 2023-01-31T13:47:52.47+00:00
db042190 1,416 Reputation points
0 answers

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,498 questions
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant 1 Reputation point
1 answer

Is it possible to implement the custom security to the SSRS 2019?

Please share the code, if we can implement the custom security to the SSRS 2019

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,102 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
1,193 questions
asked 2023-01-31T11:53:34.3966667+00:00
Chitravelu Sivanandam 0 Reputation points
answered 2023-01-31T12:09:19.37+00:00
Olaf Helper 25,721 Reputation points
1 answer

SQL Total_pages space is very high than the used_pages

Hi , For an Archival process we have swithced out a partition to a new table . but this table Totalpages used space is very high compare to the usedpages. what could be the reason for alocated_memory space is too high ?

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,498 questions
asked 2023-01-31T10:33:00.3766667+00:00
Racheal 186 Reputation points
commented 2023-01-31T11:03:49.14+00:00
Racheal 186 Reputation points