Where is the correct place to report a bug in SQL Server?

Asked 23/8, 2010 at 15:36 Answered 20/1, 2022 at 17:50

Solved sql-server-2008 bug-reporting

I have found a fairly insignificant bug in SQL Server 2008.

I would like to report this to Microsoft, however, when I went to https://support.microsoft.com/ I realized that I may need to spend $300 CAD to report it.

Is there a place where I can report this bug without it costing me any money?

Below is a sample of the bug:

Works:

USE [msdb]  
(SELECT * FROM msdbms)

Fails with "Incorrect syntax near the keyword 'order'."

USE [msdb]  
(SELECT * FROM msdbms ORDER BY dbms)

Also, if I am incorrect and this isn't a bug can it be explained why not?

EDIT
I've added this to Microsoft Connect

Parallelism answered 23/8, 2010 at 15:36 Comment(1)

FYI unrelated to this specific issue but I tried to submit feedback regarding another bug on that site without any success using my various Microsoft accounts - kept going to "Please Wait...", error messages etc. I gave up and now regard that site as totally useless from a usability standpoint in that regard – Algiers 28/5, 2017 at 14:26

you can report bugs at the sql server connect site https://connect.microsoft.com/SQLServer

however, here are 2 workarounds because you really don't need the parenthesis

USE [msdb]  
SELECT * FROM msdbms ORDER BY dbms

USE [msdb]  
select * from 
(SELECT * FROM msdbms) x
ORDER BY dbms

Wohlen answered 23/8, 2010 at 15:38 Comment(4)

yeah, I've realized that which is why I think it's insignificant, but I'd like to report it because it doesn't work as I think it should. – Parallelism 23/8, 2010 at 16:38

@Nathan - Or bizarrely this also works (SELECT * FROM msdbms) ORDER BY dbms – Seidule 30/8, 2010 at 21:15

ms connect was retired – Citrine 27/3, 2018 at 16:29

Effective January 2018 the correct location is now: https://feedback.azure.com/forums/908035-sql-server for reporting bugs in SQL Server. – Folia 17/7, 2018 at 18:4

Now that Connect is being retired thanks to GDPR, they've migrated all Connect content (supposedly!) to UserVoice under the Azure feedback forums. Bugs/issues/product-feedback should be directed there.

Interestingly enough, they say "If you have a technical issue, please open a post on StackOverflow or MSDN." Not sure what they mean by "technical issue" and whether or not it's a synonym for "bug". But, given that Connect was used for filing bugs while it was alive, it stands to reason that this new location, wherein they've migrated 4000 bug reports from Connect, would continue to be the correct place for such... but I'm no MVP or "insider" or whatnot, so hopefully someone closer to the source can verify this.

Encroachment answered 1/2, 2018 at 15:13 Comment(2)

I had an SSMS bug that I almost decided not to report because the site was listed as an azure forum, not a SQL Server forum. Good way to be sure you don't get necessary feedback on your products. – Canebrake 18/4, 2018 at 18:47

+1 This answer should become the new accepted one to avoid people missing the newer post and getting frustrated. Not all reports are equal. You can determine the correct forum for the request SQL Server help and feedback - SQL Server | Microsoft Docs – Epifaniaepifano 24/2, 2019 at 0:38

you can report bugs at the sql server connect site https://connect.microsoft.com/SQLServer

however, here are 2 workarounds because you really don't need the parenthesis

USE [msdb]  
SELECT * FROM msdbms ORDER BY dbms

USE [msdb]  
select * from 
(SELECT * FROM msdbms) x
ORDER BY dbms

Wohlen answered 23/8, 2010 at 15:38 Comment(4)

yeah, I've realized that which is why I think it's insignificant, but I'd like to report it because it doesn't work as I think it should. – Parallelism 23/8, 2010 at 16:38

@Nathan - Or bizarrely this also works (SELECT * FROM msdbms) ORDER BY dbms – Seidule 30/8, 2010 at 21:15

ms connect was retired – Citrine 27/3, 2018 at 16:29

Effective January 2018 the correct location is now: https://feedback.azure.com/forums/908035-sql-server for reporting bugs in SQL Server. – Folia 17/7, 2018 at 18:4

Connect is the usual site.

Another parentheses related issue.

Seidule answered 23/8, 2010 at 15:40 Comment(0)

It looks like UserVoice (as others suggested) has been retired also! The new place to report bugs seems to be https://learn.microsoft.com/en-us/answers/index.html

Harris answered 2/6, 2021 at 13:57 Comment(0)

The funnier or smellier bug/feature would be to get a wrongly sorted list by running the following:

USE [msdb]  
select * from (SELECT top 100 percent * FROM msdbms order by 1 desc) t

Because, apparently, by design, sorting with top 100 percent doesn't work. And the funny part is that you are allowed to specify order by even though you're not gaining anything by it.

It's more of a 'view' comment and it's not really a bug. But it's interesting to mention.

Malpractice answered 1/9, 2010 at 8:55 Comment(2)

This is because ORDER BY has 2 different purposes in SQL Server. One is to order results for the client. The other is used in combination with the proprietary TOP keyword. To say TOP according to what. – Seidule 1/9, 2010 at 14:14

Yeah, I can see that, but while you're outputing the result of sorting and taking a part of it, why not output it in that particular order? Seems like defying the purpose and obscuring the concept. But, yeah, that's the way the cookie crumbles. :) – Malpractice 1/9, 2010 at 20:57

I noticed bug in sql in my work place. I studied IT in management. Problem is Pointer of mouse in rectangle If pointer is held there <•••> after this sign something is different. I noticed this difference depending on this

using finger on touchschreen
using mouse to click on screen

Babylonian answered 20/1, 2022 at 17:50 Comment(0)

Recommended topics

Hot tags