SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,029 questions
2 answers
Licensing SQL Server 2019 on VMWARE
Hi Everyone, Our company has SQL Server 2014 and 2016 and will acquire licenses for SQL Server 2019. Our environment is in VMWARE, and as I understand it, one license is required for each V-Core that the server is using. So if my server…
asked 2021-03-29T11:18:59.473+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(54.400000000000006, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Edgar Toia Neto
1
Reputation point
answered 2021-03-30T02:31:25.363+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(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
How to specify today's date for a parameter when running a proc
I am trying to a DDS where the subscription is triggered and send a a report in an email when there is data for the current date. But I am not sure how to specify the current date when specifying the script to execute the stored procedure in the DDS…
asked 2021-03-29T14:32:08.263+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(256, 31%, 34%)' 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)
meddojeddo
1
Reputation point
answered 2021-03-30T02:13:02.847+00:00
Joyzhao-MSFT
15,566
Reputation points
1 answer
How to change the rendering of SSRS reports when imported to PowerPoint?
When an SSRS report is imported to PowerPoint, it splits 1 page report into 2 slides ( splits the last column into 2 slides) Is there a way to change the rendering of SSRS report in PowerPoint manually? I am new to SSRS. Any help is greatly…
asked 2021-03-26T23:56:37.62+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(172.8, 57.99999999999999%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
sravya shivapuram
211
Reputation points
commented 2021-03-30T01:55:26.92+00:00
Joyzhao-MSFT
15,566
Reputation points
1 answer
How to get Part Id that have part level 0 and not have map from ?
How to get Part Id that have part level 0 and not have map from ? I work on SQL server 2012 I face issue I can't get Parts that have map to and not have map from for part level 0 so Firstly I get parts that have part level 0 then…
asked 2021-03-27T02:20:18.643+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(262.40000000000003, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
commented 2021-03-30T01:50:22.967+00:00
MelissaMa-MSFT
24,176
Reputation points
2 answers
Error messages when I perform an UPDATE, INSERT, or DELETE on a remote table by using the OpenQuery function. 7320, Level 16, State 2 Cannot execute the query against OLE DB provider "IBMOLEDB.IBMDBCL1" for linked server
Error messages when I perform an UPDATE, INSERT, or DELETE Transact-SQL statement on a remote table by using the OpenQuery function: 7320, Level 16, State 2 Cannot execute the query against OLE DB provider "IBMOLEDB.IBMDBCL1" for linked server.…
asked 2021-03-23T20:22:46.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(35.2, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Richel Bek
1
Reputation point
commented 2021-03-30T01:31:56.877+00:00
CarrinWu-MSFT
6,866
Reputation points
3 answers
One of the answers was accepted by the question author.
Store SQL server database or table on Google drive or SharePoint?
I'm using SQL server and want to create a new database to house some really big data. a few million rows of data and it's way too big to put in a flat file or load into Excel because I have to update it all the time and it just takes 20 to 30 minutes 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(150.4, 86%, 24%)' 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)
3 answers
One of the answers was accepted by the question author.
Can I use SSMS 2016 Express to upgrade SQL Server 2012 Express
I have a SQL Server 2012 Express database in a C# WinForms application and would like to upgrade it to SQL Server 2016 Express. I also have both SSMS 2012 Express and SSMS 2016 Express i.e.(Microsoft SQL Server Management Studio-18.8) Can I use SSMS…
asked 2021-03-25T20:02:47.707+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, 1%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Richard Arnold
181
Reputation points
commented 2021-03-29T21:42:17.203+00:00
Richard Arnold
181
Reputation points
2 answers
One of the answers was accepted by the question author.
How would i delete a record from a table which is the child of another table.
I'm getting the following error when attempting to delete data from a table: Here is the coachSchedule table which is where I'm attempting to delete data from: This is the table that its conflicting with: Is there way that i…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,862 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,029 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,457 questions
asked 2021-03-28T21:48:05.977+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, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aaron soggi
246
Reputation points
commented 2021-03-29T21:35:59.78+00:00
Erland Sommarskog
102.9K
Reputation points
2 answers
One of the answers was accepted by the question author.
Integrating CU into SQL Server Express 2016 Installation
Is it possible to integrate Cumulative Updates into the SQL Server Express 2016 installation? We are currently patching the product with Config Manager, but would like to get the installation that runs through OS deployment patched during the…
asked 2021-03-29T17:14:31.013+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, 64%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Nate Lindberg
96
Reputation points
accepted 2021-03-29T19:32:39.817+00:00
Nate Lindberg
96
Reputation points
2 answers
One of the answers was accepted by the question author.
Cast a varchar field with mixed time format to time (0)
Hi I have a [time] field- varchar datatype and it has got values in mixed formats as below 14:24:00 07:00.0 10:00:56.7730000 54:80.0 (exclude wrong format) I am trying to cast the field as time (0) but it is causing conversion error. Can…
asked 2021-03-24T11:10:38.2+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(35.2, 64%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
jennifer zen
341
Reputation points
commented 2021-03-29T13:57:30.07+00:00
jennifer zen
341
Reputation points
2 answers
Could not load file or assembly 'Microsoft.ReportViewer.Common' version=15.0.0.0 winforms powershell
Hi, I'm trying to run a Reportviwer RDLC report, rendering data from a SQL Server DB to Excel from Powershell 5.1. When I run the PS script report with Reportviewer runtime 2015 v14 or runtime 2017 v15 I get this error: "Could not load file or…
asked 2021-03-27T22:34:14.713+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, 44%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOS%3C/text%3E%3C/svg%3E)
OLIVIER STEINBERG
1
Reputation point
answered 2021-03-29T10:38:19.41+00:00
OLIVIER STEINBERG
1
Reputation point
3 answers
One of the answers was accepted by the question author.
SQL JOIN related query
Hi, Looking for your help on the SQL JOIN, basically we want to List down the first_names with total number of posts and total number of likes in a single table of below tables in the screenshot? I've tried couple of joins and methods but unable to come…
asked 2021-03-27T22:43:46.213+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(195.2, 70%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
MOHIT JAIN
21
Reputation points
commented 2021-03-29T09:46:52.84+00:00
MOHIT JAIN
21
Reputation points
1 answer
SSRS 2014 reports generation failed after Oracle 19.9 client upgrade - Error - ora-06550: line 1, column 7: pls-00306: wrong number or types of arguments in call.
Hi, We were using the SSRS 2014 version on Windows Server 2012 R2 standard and Oracle 11.2 client. Everything was working fine, now we have upgraded the Oracle client to the latest 19.9 version and now all the reports that uses the Oracle data source…
asked 2021-03-26T16:56:25.623+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(275.2, 40%, 36%)' 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)
Chandra
1
Reputation point
answered 2021-03-29T09:29:27.23+00:00
Joyzhao-MSFT
15,566
Reputation points
1 answer
SSRS Customize From field
Hello everybody! I have configured SSRS and mail settings to send letter for subscriptions. So SSRS successfully sending letters now and everything fine there. But users want to customize the From field. Is it possible to set any another one…
asked 2021-03-26T15:02:34.883+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(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Andrey Kucherovsky
96
Reputation points
answered 2021-03-29T09:03:01.66+00:00
Joyzhao-MSFT
15,566
Reputation points
0 answers
SQL - Spatial data. STGeomFromText Error The Polygon input is not valid because the start and end points of the ring number 1 are not the same.
Hi We are using Spatial Functions in SQL to plot data against Polygons. I have this table CREATE TABLE [staging].[SpatialTable] ( id int IDENTITY (1,1), geoType Varchar(255), geoName Varchar(255), GeogCol1 geography, …
asked 2021-03-26T14:17:39.883+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(204.8, 27%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Debbie Edwards
521
Reputation points
commented 2021-03-29T09:01:49.013+00:00
MelissaMa-MSFT
24,176
Reputation points
1 answer
Certification
Hello, Please which exam corresponds to Windows Server 2019 and SQL Server 2019 training. Thank you
asked 2021-03-25T16:06:20.147+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(83.2, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
YETIANRI EMMANUEL OUSMANE SORI
241
Reputation points
commented 2021-03-29T08:34:05.867+00:00
CathyJi-MSFT
21,106
Reputation points Microsoft Vendor
2 answers
How would I be able to view my sql database on another PC?
I'm currently doing a college project which i will need to submit online. My teacher would need to be able to view all of the tables within my SQl server project when downloading it onto his work pc. Does anyone know what i would need to change in…
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,029 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,457 questions
asked 2021-03-27T13:21:47.553+00:00
Aaron soggi
246
Reputation points
commented 2021-03-29T08:23:02.697+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Microsoft Attunity driver 5.0 - latest supported SQL Server
Hello, Is SQL Server 2019 compatible with Attunity 5.0 driver?
asked 2021-03-29T07:22:54.987+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(304, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Robas
21
Reputation points
commented 2021-03-29T08:22:03.077+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(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server connection string
I am unable to connect SQL Server database from my Julia Language code web server; I suspect I am not able to figure out proper connection string. I have 2 SQL Server ODBC drivers installed on this windows machine, "SQL Server" and…
asked 2021-03-26T16:01:21.643+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(3.2, 85%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Ladislav Kováč
21
Reputation points
accepted 2021-03-29T08:05:51.377+00:00
Ladislav Kováč
21
Reputation points
1 answer
GPU based database provider for Entity Framework Core 5 and beyond.
For a wicked fast database, is there any plans for a Entity Framework Core 5 ~ 6 provider to any of the in memory GPU databases that are out or that are coming out? I have seen an example of Rapids Dask on a NVidia A6000 and it seems like a much better…
asked 2021-03-28T13:38:46.413+00:00
SuperDave
1
Reputation point
answered 2021-03-29T07:02:58.09+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(19.2, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zhang-MSFT
9,621
Reputation points