SQL Server
Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.
-
Report Builder Windows Authentication does not work over the proxy server that requires authentication
ReportBuilder fails to connect to the RS server through the proxy server that requires authentication.
0 votesUpvotes: 3
<=-=Jun 12 2007 12:26PM=-=>We are considering addressing this in a future release.
-
sp_executesql in combination with alter database set recovery fails
sp_executesql and/or alter database fails when trying to change recovery model of a database. The command should be translated to "ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE", which runs perfectly.
It would be nice to have this fixed, as the code i to be used within a loop.
0 votesUpvotes: 0
<=-=Feb 5 2008 2:55PM=-=>Thank you for your suggestion.
We will look into this for a future release. In the meantime, if you have need to issue this command repetetively, I suggest that you create a script tiwh the desired syntax. -
locktimeout causes abort transaction when using output
create table a (i int)
insert into a values (1)thread 1 run
begin transaction xxx
go
declare @id bigint
select top 1 @id = i from a WITH (READPAST)
update a with (nowait) set i = i where i = @idsee below for reproduce steps for what to run in thread 2
0 votesUpvotes: 1
<=-=Jan 17 2008 12:32PM=-=>Hello
Thank you for reporting this issue. We are investigating why the transaction is aborted when using the OUTPUT clause in the UPDATE statement for this particular scenario. We will get back to you when we have more information.
— SQL Server team
-
SQL Server Management Studio bug in Import Data Wizard with DB2 driver
The SQL Server version I am using is:
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)I was trying to use the Database "import data" task in Studio Manager. After specifying the IBM OLE DB Provider for DB2 and entering the appropriate property information, I received the following message:
SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=43968
The version of DB2 Connect I am using is DB2 Connect Personal Edition 64 Bit V8.2 fix pack 9.…
0 votesUpvotes: 0
<=-=Dec 13 2007 9:58AM=-=>Thank you for your submission. We have reviewed the problem but we were not able to include a correction in the Katmai release. I have place this issue in the next phase so that it may be considerable for the next release.
-
cube content security
I set up security for the cube writing the proper text in the "Allow reading of cube content" textspace, in BIDS.
I'd like that, for all the measures different from �Mea1�, the �01� �02� members and even the aggregated cells of the dim-hier [Dim Mesi].[Dim Mesi] would be accessible to the users, in the same way as it happens if you enable security directly on a dimension from the Dimension Data Tab.This works for the Measure "Costi2" which has not any calculations applied through the cube script. But this doesn't work for the Measure "costi1" to whom I applied…
0 votesUpvotes: 0
<=-=Jul 25 2008 1:37PM=-=>Vania.
Without getting int exact detail I beleive the behavior you are seeing is “ByDesign”.
Try posting your question on Analysis Services MSDN forum. (http://forums.microsoft.com/msdn/showforum.aspx?forumid=83&siteid=1)Edward Melomed
-
SQL Agent : Log File Viewer : server vs. client times
You fixed the duration column I complained about in Connect item #124841 (thank you!).
Now I am seeing another artifact of this issue, where the GUI can't decide whether to show server time or client time.
This is still in the log file viewer, in the Date column. In the following screen shot, the server is set to UTC, and my client machine is eastern time. The job started a few minutes ago, but step 1 completed 4 hours before the job started!
http://www.aaronbertrand.com/voodoo/SSMSagentGMT.gif
Not only is this disconcerting because of the difference in hours, it also makes…
0 votesUpvotes: 4
<=-=Jun 6 2007 11:29AM=-=>Aaron,
Thanks for the report – we’ll be looking at this for Katmai.
-Richard Waymire
<=-=Mar 11 2008 2:16PM=-=>Aaron,
We ran out of time to fix this in SQL Server 2008, I’m moving the bug to next major release.
-Richard Waymire
<=-=Jun 26 2009 2:07PM=-=>Hi, we plan to address this issue in SQL11.
Thanks,
Gil
<=-=Jul 14 2009 10:29PM=-=>Wouldn’t it be possible to use something like “Closed (Postponed)” instead of “Closed (Won’t Fix)”? When you say that something won’t be fixed, it looks like it will be ignored forever.
Thanks.
<=-=Jul 16 2009 8:38AM=-=>Stephen -
In response to: ’Wouldn’t it be possible to use something like “Closed (Postponed)” instead of “Closed (Won’t Fix)”? When you say that something won’t be fixed, it looks like it will be ignored forever.’
This bug isn’t even closed – we do hope to fix…
-
SQLBPA 2.0 - Need to be able to specify port for instance
The Feb CTP of SQLBPA 2.0 allows me to specify a computer name to run the BPA against. I am running SQLBPA from my client desktop (W2K SP4) to servers (W2K3 and W2K3x64) on the network. It is able to connect and show all the SQL 2005 components and instances. However, when I select an instance it is unable to connect to perform the analysis. When running SSMS from the same desktop, I have to specify the port in order to connect to the instance - servername\instance,port. So, I suspect that is the same problem here. We need to be…
0 votesUpvotes: 1
<=-=Mar 30 2007 2:07PM=-=>I tried a little more patience and the scan for Analysis Services does finally return – but took nearly 40 minutes to run the “Collecting command data for host [servername]” step. Likewise, the scan for Integration Service took a similar lengthy time. Is this the expected performance? We have hundreds of servers\instances on which we are going to want to execute this tool…unless performance makes it impractical.
<=-=Mar 30 2007 2:08PM=-=>
Thanks,
Nancy Hidy WilsonOops – that should have read “Collecting common data for host [servername]” in the previous post.
NHW
<=-=Jul 9 2007 9:53AM=-=>I haven’t tried analysis services but when I try to connect to a non-standard port for the database engine it comes back right away with the message about services running / correct credentials etc. Which is not right since the services are running and I am using the…
-
SSMS unable to list databases if logged in as limited user
If user has limited right, SSMS unable to list databases, even if user have access to some of them
0 votesUpvotes: 1
<=-=Dec 3 2008 10:09AM=-=>Thanks for your feedback. This issue has been addressed in a duplicate defect. Thanks!
Mingwu Zhang
-
SQL 2008 does not support Windows 2008 and W2K8 R2 Multi-site cluster
SQL 2008 does not support Windows 2008 and Windows 2008 R2 Multi-site (multi-subnet) cluster. I tried to install SQL 2008 onto both Win2k8 and Win 2K8 R2 multi-site cluster but it fails to install properly on either platform. I had opened up a premier support call for this and was told the SQL 2008 does not support the new W2K8 Multi-Site cluster
0 votesUpvotes: 4
<=-=Jun 1 2009 1:17AM=-=>Thanks for your feedback. We’re looking at the support for SQL cluster across different subnets for SQL11 release.
Jason
<=-=Jun 3 2010 8:30PM=-=>Closing the loop.
SQL Server 2008 and SQL Server 2008 R2 don’t support deploying SQL Server failover cluster over multiple subnets. We are investigating if this can be enabled in next SQL release.
-
Detaching job from schedule delete schedule
In SSMS 2008, I get the following error and schedule is deleted when I unselected job from schedule ("Jobs referencing a Schedule" window) :
Cannot access properties or methods for the Microsoft.SqlServer.Management.Smo.Agent.JobSchedule 'CollectorScheduleEvery6h', because it has been dropped. (Microsoft.SqlServer.Smo)When I remove schedule from job ("Job Properties" window), schedule is deleted.
In SSMS 2005 schedule isn't deleted.0 votesUpvotes: 1
<=-=Jan 12 2009 3:07PM=-=>Hi, we are looking into this.
Thanks,
Gil
<=-=Dec 3 2010 3:38PM=-=>We are working on fixing this issue in next release of SQL Server
Thanks
<=-=Mar 7 2011 10:42AM=-=>
Sethu Srinivasan[MSFT]
SQL Server Agent Team
http://blogs.msdn.com/seths
http://blogs.msdn.com/sqlagentVerified that this will be fixed in Denali.
Robann Mateja
Microsoft -
XML DML delete causes problems with xsi nil
After running delete XML DML query xsi:nil="true" is appended to some nodes (not related to query). This does not happen when running 'insert' or 'replace'.
This is quite serious issue for me - I am using xsi:nil to distinguish null from empty string.
0 votesUpvotes: 1
<=-=Jan 2 2009 3:35PM=-=>Hi Marcin
Thanks for reporting this problem. This is a known issue with the way that we internally keep track of xsi:nil values… the fix is not easy and so far not many people have stumbled across it in real-world scenarios. However, with your report we are taking another look at fixing it… if you need a fix quickly, I recommend that you file a support case with CSS. Feel free to point them to this bug for more information.
Best regards
<=-=May 5 2009 5:41PM=-=>
MichaelHi Marcin
We are working on fixing this now for an upcoming release. However, since it will break existing behaviour, I would like you to provide us some feedback on how fixing it will impact your current workarounds. Could you please get back to me at mrys at microsoft dot com?
Thanks
<=-=Jun 16 2009…
Michael -
SP3 Installation and readme unavailable on website
Able to download the SP3 install executable but unable to access the installation and readme file. It shows up as no longer available. It is an embedded link on the main sp download page
0 votesUpvotes: 0
-
ipoint.exe causeses Blue Screen when edit table in SQL 2008 Management Studio
Edit Table causes blue screen in SQL 2008 Management Studio when ipoint.exe is running.
0 votesUpvotes: 1
<=-=Feb 13 2009 10:38AM=-=>Dear customer,
Thank you for reporting this problem. To help us reproduce this problem, please revert back with the mouse type and the IntelliPoint driver version number. Currently we are unable to reproduce this issue with IntelliPoint driver 6.2 installed on the system where SSMS 2008 Designer was launched.
Thanks,
<=-=May 27 2009 8:31AM=-=>
-KarthikIntellipoint driver 6.31.230.0. Also installed and running is the Synaptics ThinkPad UltraNav Pointing Device driver version 11.1.21.2. Computer is a Thinkpad T61. Same issue as reported here. Edit Top 200 Rows = BSOD
<=-=Jun 3 2011 12:13PM=-=>Hi,
Thanks for writing in to Microsoft.
There’s another report of a similar issue with IntelliPoint. Given this, I am resolving this one as a duplicate. We will track the issue using the other bug.
Thank you for your valuable feedback.
Prachi -
XML format file causes bulk insert of wrong data into NOT NULL column
BULK INSERT into a table with a NOT NULL column behaves very badly when an XML format file is used and there are missing or all-whitespace data values in the source file. No error is raised and incorrect data values are inserted into the table. (Specifically, when there is missing, whitespace, or otherwise invalid data, the NOT NULL column repeatedly receives the last non-null value of the column.
If a non-XML format file is used, the behavior is not bad.
This bug is similar to Connect item 405579, however the problem is not as localized as that bug report suggest.…
0 votesUpvotes: 1
<=-=Jan 27 2009 8:44PM=-=>Note: Please add one space character at the beginning of the line
|D.D.D
in junk.txt to get the results shown.
<=-=Jan 28 2009 2:54PM=-=>We are looking into addressing this as part of hotfix.
-
Error scriping procedure when there are nested comments before CREATE PROCEDURE
If you try to script a stored procedure where CREATE PROCEDURE is preceded by a comment
that contains nested / /, you get an error message, "Syntax error in TextHeader of StoredProcedure ".I saw that this was reported in
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=178866
as well, but it was said to have been fixed in SQL 2008, but this does not seem to be
the case.0 votesUpvotes: 3
<=-=Feb 26 2009 4:28AM=-=>Hi,
Thanks for reporting the issue.
The issue was fixed but the fix got reverted due to performance issues before RTM.
We will fix this in next release.Regards,
<=-=Jun 27 2011 4:35AM=-=>
AlokHi Erland,
We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.
You could use many other symbols (quotes, paranthesis, etc.) to demarcate a portion of the comment you want to have nested. For example, you could do:
/* My comment including “nested comment” and blah /
OR
/ My comment including (nested comment) and blah /
OR
/ My comment including… -
ACCESS_VIOLATION crash when using FOR BROWSE on a synonym for a remote object
Retrieving a browse mode cursor through use of the FOR BROWSE clause in a SELECT statement (or executing a SELECT when SET NO_BROWSETABLE ON is in effect) does not work for synonyms to remote objects. When executing such a query, SQL Server produces a crash dump.
One notable user of such queries is 2005 BIDS. Using a synonym as part of a stored procedure or view in the designer results in the situation that you will be able to preview the data (when BROWSE is not used) but no columns will be created for components as
metadata retrieval fails.Reproduced…
0 votesUpvotes: 1
<=-=Feb 23 2009 11:15AM=-=>Hi,
Thanks for reporting the problem. We are investigating the issue and get back to you when we reach a resolution.—
<=-=Mar 24 2010 11:58AM=-=>
Umachandar, SQL Programmability TeamHi,
Thanks again for reporting the issue. This bug has been resolved as duplicate of another one in our system. We are looking at fixing it for the upcoming public cumulative update for SQL Server 2008.—
<=-=Mar 24 2010 1:05PM=-=>
Umachandar, SQL Programmability TeamResolved as duplicate
—
<=-=Jun 8 2011 1:34PM=-=>
Umachandara similar stack is shown at : http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/af2d10db-bc56-43e7-b812-f660ba0052a8/
-
SSMS Shows incorrect restore chain
If you restore to an earlier state and continue your regular backup schedule without performing a full backup after the restore, SSMS shows an incorrect restore chain.
When I run the attached script to recreate the steps followed by the SSMS query I can see that the DatabaseBackupLsn is different. The last differential backup (performed after the Restore) points to the LSN belonging to the earlier backup.
SSMS should either show the correct Full backup (with the same LSN in the column CheckpointLsn) or not show Differential backups that do not map with the CheckpointLsn of the Full backup.
As…
0 votesUpvotes: 0
<=-=May 24 2009 10:58PM=-=>This issue is fixed. Thanks for reporting the same. Please apply katmai CU5.
Regards
Vinod -
Materialized Reference Dimension cannot be updated through Dimension ProcessUpdate
If you have a dimensions linked to a measure group through a materialized reference link and want to refresh it, the ProcessUpdate on the intermediate dimension will not update the materialized reference. Materialized references are refreshed only when the measure group is processed. Non materialized ones works just fine while materialized ones simply show bad data (old, not refreshed) if you leverage the process update on the dimensions.
This is clear, due to the fact that the relationship is resolved through JOIN made inside the measure group processing and not during dimension processing for materialized relationships, still I think it…0 votesUpvotes: 2
<=-=Feb 27 2009 11:52AM=-=>Hi Alberto — Thank you for your feedback. We will consider your request in a future version. If you think this issue needs to be addressed immediately, please work with your Customer Support contact to resolve the issue.
-
SqlClient.SqlConnection.Close method does not release server-side resources
SqlClient.SqlConnection.Close method does not release server-side resources. When a Connection is closed, it is returned to the pool but ADO.NET does not close and does not reset the Connection until the connection is reopened. This means that any resources allocated to the connection are left in use on the server (the server state) is maintained until the next reuse or the connection times out (4-8 minutes later). This reduces performance because of resources not being freed by applications that can no longer access the server-side objects.
0 votesUpvotes: 2
<=-=Mar 6 2009 1:19PM=-=>Hello,
I just wanted to let you know this issue has been closed accidentally. I reactivated it and we will evaluate it again.
The confusion comes from the fact that the bug has been filed against SQL Server Engine, while it seems to belong to ADO.NET. Please let me know if I�m missing something here?
Thanks,
<=-=Mar 8 2009 4:33PM=-=>
Krzysztof Kozielczyk (Microsoft)Hello Bill
This bug describes the same issue that is described in another connect bug being tracked at http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=383517. Thus we have resolved this bug as a duplicate. Please reactivate if we mis-interpreted this issue and they are not the same issue.
Thanks
-
New Query Editor Window in SSMS connected to one server, where as in tool tip text its shows connected to another server
In SSMS when there is query window connected to a server (say server A) and when a new query window is opened, by default it opens with existing connection (server A). Now when we change the connection of this query to another server (say server B). It is still connected to Server A, which can be verified by running command select @@Servername.
However tool tip on top left corner of the query editor window shows it is connected to Server B, which it is not not connected to.
This could me a major issue, because the user may assume that…
0 votesUpvotes: 1
<=-=Jun 22 2009 4:06AM=-=>Hi Basant,
Thank for reporting the problem via MS Connect. We are aware of this issue and are looking at fixing this in the near term. I will keep you posted on the updates.
Thanks,
<=-=May 11 2010 10:56PM=-=>
-KarthikHi Basant,
This issue has been fixed in SQL Server 2008 SP1 CU5.
Thanks,
Prashant.
(prashant.choudhari@microsoft.com)
- Don't see your idea?