SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,692 questions
0 answers
Syntax to PRINT the row counts using Dynamic SQL?
Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…
asked 2024-04-24T18:57:32.9433333+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(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,766
Reputation points
asked 2024-04-24T18:57:32.9433333+00:00
techresearch7777777
1,766
Reputation points
1 answer
Not able to select pricing tier
I am trying to crate an OpenAI service but when I click create and in the info it shows nothing in the pricing tier, the field is empty. i waited for long but its not working
asked 2024-04-24T16:59:53.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(48, 63%, 14%)' 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)
Master
0
Reputation points
edited an answer 2024-04-24T17:12:06.2133333+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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
10,040
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Can I drop or disable the default NT Service Accounts from SSMS Logins?
The following accounts are automatically created upon SQL Server installation: NT SERVICE\SQLWriter NT SERVICE\Winmgmt NT SERVICE\MSSQLSERVER NT SERVICE\SQLSERVERAGENT If I am using a seperate domain account to use as SQL…
asked 2022-08-22T08:30:51.323+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(44.800000000000004, 23%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michelle Lopez Santos
41
Reputation points
commented 2024-04-24T15:31:16.3133333+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(313.6, 48%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Longstreet, James [USA]
1
Reputation point
2 answers
One of the answers was accepted by the question author.
VS 2022 ReportViewer Error: "The report cannot be displayed. The report viewer could not find a report definition."
Please help me with this problem I'm having. I'll start by explaining my problem: I need to load reports, and for that I'm using the native reports of VS 2022. Here's what I've done so far: I created my .xsd file called DataSetInformes.xsd I added my…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,826 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.
12,692 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.
10,231 questions
asked 2024-04-23T16:21:18.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(134.4, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roberto Carlos Melgar Dorado
20
Reputation points
accepted 2024-04-24T14:52:18.47+00:00
Roberto Carlos Melgar Dorado
20
Reputation points
1 answer
SSRS report - image has phantom borders
I am showing an image in a table row. Image border is turned off, but it still shows some: Any idea why? Thanks
asked 2021-05-17T12:58:45.17+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(297.6, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zolotoy
221
Reputation points
commented 2024-04-24T14:41:17.0366667+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(124.80000000000001, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Sanger
0
Reputation points
0 answers
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
asked 2024-04-24T14:37:25.1533333+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(16, 4%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tina Douglass
1
Reputation point
asked 2024-04-24T14:37:25.1533333+00:00
Tina Douglass
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Ubuntu 22.04 - The install the ODBC driver error
Here is the result of the trying to build docker image with installing the ODBC driver: RUN apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql18: 0.361 Hit:1 http://ports.ubuntu.com/ubuntu-ports jammy InRelease 0.440 Hit:2…
asked 2024-04-24T12:22:25.1866667+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, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Efim Gerasimov
0
Reputation points
commented 2024-04-24T13:53:52.8433333+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(118.4, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vaibhav Patil
20
Reputation points
0 answers
SQL SERVER IMPORT AND EXPORT WIZARD
I clicked on the next button to import my data from excel and it brings me this error message; TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not…
asked 2024-04-24T13:50:36.61+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(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mariam Wasiu
0
Reputation points
edited the question 2024-04-24T13:52:15.74+00:00
Mariam Wasiu
0
Reputation points
0 answers
Unable to import excel workbook into MSSQ.
I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message here, i checked…
![](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(262.40000000000003, 19%, 35%)' 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
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
![](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(262.40000000000003, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
1 answer
How to use SSL Wildcard Certificate in SSRS 2016
I am trying to use an SSL wildcard certificate in SSRS but so far I have no luck. I am able to access http://ServerName:80/ReportServer but not https://myReports.mycompany.com/ReportServer. The error I am getting is that the page cannot be displayed. Do…
asked 2020-08-18T01:18:30.25+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(60.8, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Eigh
1
Reputation point
commented 2024-04-24T13:39:32.6833333+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(307.2, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
★Yevhen Nedashkivskyi - ALLSTARSIT
0
Reputation points
1 answer
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…
asked 2024-04-24T08:07:29.2066667+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(9.6, 38%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sharuk
0
Reputation points
answered 2024-04-24T13:17:47.2733333+00:00
Amira Bedhiafi
15,056
Reputation points
2 answers
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
asked 2024-04-19T14:09:09.57+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(128, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
0
Reputation points
edited a comment 2024-04-24T12:45:52.3933333+00:00
Mariam Wasiu
0
Reputation points
0 answers
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
asked 2024-04-24T12:17:54.3266667+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(124.80000000000001, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sakib rahman
0
Reputation points
asked 2024-04-24T12:17:54.3266667+00:00
sakib rahman
0
Reputation points
0 answers
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to individual rows is controlled based on the role assigned…
asked 2024-04-24T11:39:39.74+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, 16%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lộc Nguyễn
0
Reputation points
commented 2024-04-24T11:57:04.43+00:00
Lộc Nguyễn
0
Reputation points
0 answers
Ubuntu Jammy ODBC DRIVER update error
How do i resolve this error: sudo apt update Get:4 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease Err:4 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease Clearsigned file isn't valid, got 'NOSPLIT' (does the network…
asked 2024-04-24T11:48:25.9633333+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(288, 57.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Dean Marques
0
Reputation points
asked 2024-04-24T11:48:25.9633333+00:00
Dean Marques
0
Reputation points
0 answers
How to validate textbox with empty field in wpf forms
Hi Team I have these two fields i want to validate, does anyone knows how to achieve this in wpf on the forms? The bottom seal and TopSeal fields, if empty it must prompt a window dialog message.
asked 2024-04-24T11:21:49.9533333+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(185.6, 69%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gcobani Mkontwana
0
Reputation points
asked 2024-04-24T11:21:49.9533333+00:00
Gcobani Mkontwana
0
Reputation points
0 answers
Logic app to on-premise SQL server connectivity using service principle (Azure AAD)
Hi Team, Our Agenda is to connect On-premise SQL server using Logic app with SQL server connector. We successfully setup Azure AAD with On-premise SQL. Also, using SSMS we are successfully able to make connection to on-premise SQL using service…
asked 2024-04-23T10:59:34.03+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(96, 42%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yashwant Kumar Sahu
16
Reputation points
commented 2024-04-24T11:06:27.5566667+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(57.599999999999994, 18%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Pragyan Tripathy
0
Reputation points
4 answers
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
asked 2024-04-23T12:11:55.2666667+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(156.8, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Betselot Getahun
0
Reputation points
answered 2024-04-24T10:16:39.1466667+00:00
MikeyQiao-MSFT
485
Reputation points Microsoft Vendor
1 answer
EvntAgnt event error 3007
Hi Support, Our SQL server have an error 3007 on the EvntAgnt: Error opening event Error opening event log file State. Log will not be processed. Return code from OpenEventLog is 87. Any idea?
asked 2024-04-08T04:22:41.3733333+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(22.400000000000002, 43%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chong
841
Reputation points
edited a comment 2024-04-24T09:32:50.5466667+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(288, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LucyChen-MSFT
870
Reputation points Microsoft Vendor