SQL Server
Microsoft SQL Server 2017 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 2017 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.
More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.
-
change what out-of-line DataSourceView impacts
During SSAS processing, when you specify an out-of-line DataSourceView tag inside a Process tag, it should only impact that one Process command, not any other Process commands inside that batch. Currently, it does impact all Process commands in the batch. This is very unfortunate because if you're doing ProcessUpdate on all dimensions except for one, it would be nice to be able to specify an out-of-line DataSourceView for just the one dimension you're doing a ProcessAdd on. For more info, see: http://www.artisconsulting.com/Blogs/tabid/94/EntryID/2/Default.aspx
Also, if you specify an out-of-line DataSourceView, you have to specify an out-of-line DataSource or you get an…
0 votesUpvotes: 2
<=-=Mar 21 2008 1:40PM=-=>Thank you for the recommendation. Unfortunately, while it was considered, we were not able to get this into SQL Server 2005. We will be considering this for our next release.
The Analysis Services Team
<=-=Mar 21 2008 1:40PM=-=>Thank you for the recommendation. Unfortunately, while it was considered, we were not able to get this into SQL Server 2005. We will be considering this for our next release.
The Analysis Services Team
<=-=Mar 21 2008 1:44PM=-=>Sorry Furmangg,
Made a mistake in the previous post. This will not make it into SQL Server 2008 but will be considered for the next release. Did not want to mislead you so re-posted.
The Analysis Services Team
-
User!UserID and data-driven subscriptions
I had this discussion with some SSRS team members during the BI conference and there was some difficulty in grasping the business case behind this request. I hope to explain that.
We want to be able to design reports to tell the backend datasource who the user is so that the appropriately secured rows can be returned. For a report based on a SQL stored proc, this is usually accomplished by passing the User!UserID (i.e. domain\username) in as a parameter. (Call this Scheme A.) For a report based on an MDX query, this is usually done in one of two…
0 votesUpvotes: 6
<=-=Aug 30 2007 6:16AM=-=>Segments of our business have the same requirement. Example: Salesman “A” could select a detail report, but we need to pass his ID to backend to return only his accounts/regions/etc. Sales Manager “X” may control 50% of Salesman “A” accounts, and Sales Manager “Y” has other 50%. Sales Director doesn’t want “X” or “Y” to see each other’s data, but run same ‘district’ report.
In the past, our business has eliminated BI vendors because they could not satisfy this x-layered security model in live reports.
<=-=Oct 25 2007 5:14PM=-=>This is a good suggestion. While it will not make the 2008 release, we will consider it for a future relase of the product.
-
triggering schedules based upon external event
Allowing an SSRS subscription/schedule to be triggered not based upon a time, but upon an external event. Give us a stored proc to run to trigger a named event. Also give us a SOAP method to trigger that event.
Also, give us a better way to all users to create subscriptions themselves, but to allow IT to have some control over the time of day when they are allowed to create subscriptions. For instance, it would be nice to be able to define a policy that says, "Users cannot create a subscription schedule that will fire between the hours of…
0 votesUpvotes: 0
<=-=Jun 1 2007 8:13AM=-=>Quick addition: In terms of limiting what time ranges are valid for users to use for personal subscription schedules, it would be nice if there were a way to limit them to only build subscriptions triggered by an external event. Most users will want their subscriptions to be kicked off as soon as the ETL is complete, so if the administrators could define limits on which types of scheduling (time based vs. external event based), that would be nice.
<=-=Jun 1 2007 12:38PM=-=>Another quick addition: It would be nice to be able to combine calendar logic and external event logic. I would like to be able to define a schedule that says “run on Mondays” but have that schedule not kick off until I fire the “ETL Completed” external event.
<=-=Oct 25 2007 5:11PM=-=>These are all great suggestions. As we are…
-
Exists function which uses a member property as a parameter
Currently, the Exists function can only take in an attribute hierarchy, not a member property. It would be nice if you could use the Exists function to quickly get a list of members with a certain member property.
0 votesUpvotes: 0
<=-=Feb 27 2008 4:22PM=-=>Hi and thanks for the suggestion! We aren’t able to get this into SQL Server 2008, but we’re considering it for the next release.
The Analysis Services Team.
-
Updates to Index Defragmentation Best Practices White Paper with SQL Server 2005 content
I would like to propose for a newer version of Index Defragmentation best practicies for SQL Server 2005 version, in similar this was availabel in SQL Server 2000 - http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx link.
0 votesUpvotes: 17
<=-=Jun 21 2007 8:24AM=-=>I think sooner you get such documentation is better in order to follow the best practices in this regard.
<=-=Dec 4 2007 5:04PM=-=>Thanks for your feedback. We are looking into what white papers to write for Katmai. We will consider this as one of the areas
<=-=Jan 4 2008 4:14AM=-=>Thanks, that will help lot of DBAs out there who are struggling to judge on the best practices basis.
<=-=Sep 25 2008 10:52AM=-=>I certainly would like this info. Although SQL 2008 is due out soon, it will be at least a year before we upgrade our servers, probably 2. Updating the best practices 2005 article would be very helpful NOW.
<=-=Dec 12 2008 2:48AM=-=>Great to know that, how about the status on that aspect?
<=-=Mar 13 2009 11:31AM=-=>we are working on an udpated doc to be releaase as a…
-
Dynamic SubReports (parameterize the subreport property)
It would be nice to have the ability to have the subreport selection on the "containing" report be parameterized. Currently, it cannot be set dynamically and has to be set to one and only one report.
0 votesUpvotes: 5
<=-=Jun 12 2007 8:41AM=-=>Agree whole heartedly
<=-=Jun 26 2007 4:19PM=-=>Thank you for requesting this functionality. We will consider this for a future release.
-
Finer grain control over ALTER TABLE permission
ALTER TABLE has a far sweeping effect to allow all table alterations to be made by the user it is granted to. I find myself in situations where I want to allow a user (typically an application administrator or a non-user account used for processing) to create/alter/drop indices (or foreign keys sometimes) on a table, but I don't want to grant the user full access to modify the structure of the table itself. The reason for this is sometimes a user is capable of manipulating indices (which typically don't cause an application to fail) vs. manipulating columns in a table…
0 votesUpvotes: 1
<=-=Mar 31 2008 3:01PM=-=>Hi,
Thank you for the suggestion. This is something that we will definitely consider for a future release of SQL Server.
Thanks,
<=-=Feb 11 2013 2:22PM=-=>
Il-Sung.Hi, Thank you for the suggestion. This is something that we will definitely consider for a future release of SQL Server. Thanks, Il-Sung.
-
Web Report Viewer parameters access.
Hello.
We have a request to make Web Report Viewer refresh report with each post-back.
It's default behavior includes doing a lot of post-backs, when the parameter values are being selected, but only when the "View Report" button is click the report gets refreshed.
The report viewer doesn't expose this functionality, and even more - the selected parameters values cannot be retrieved from the ReportViewer object, because the ServerReport.GetParameters() function gets the updated selected value only after the "view report" button was clicked. The only possible way, I've discovered to do it is to get from the page values of…0 votesUpvotes: 0
<=-=Oct 25 2007 5:09PM=-=>Thanks for the suggestion. We’ll consider for an upcoming release.
<=-=Mar 10 2009 4:48PM=-=>Thank you for your feedback. The feature that you have requested is being consider for the future release of the Report Viewer. This particular defect is resolved as duplicate because there is an existing work item for this issue.
Thank you.
Stella Chan
Lead Program Manager
SQL Server Reporting Services -
Option to create logion SID from existing database
I just wish to reopen 269442. It is clear that the closer has not carefully considered the options. Closed - Not Reproducible is just silly. It's a very common problem which, while it is possible to work around, deserves easier syntax.
0 votesUpvotes: 4
<=-=Jul 9 2007 4:57PM=-=>This is something we will consider for the next release of SQL
Thx
-
HASHBYTES function should support large data types
The hashbytes function (http://msdn2.microsoft.com/en-us/library/ms174415.aspx) supports only up to 8kB of data (varbinary(8000 )). E.g. this does not work:
print hashbytes('SHA1',replicate(cast(N'test' as nvarchar(max)), 16000))I want to use it to compare strings faster by using it with a table similar to the following:
CREATE TABLE [dbo].[HashbytesTest](
[ID] [bigint] IDENTITY(0,1) NOT NULL,
[NVarCharMaxText] [nvarchar](max) NOT NULL,
[TextSHA1Hash] AS (hashbytes('SHA1',[NVarCharMaxText])) PERSISTED,
[TextDatalength] AS (datalength([NVarCharMaxText])) PERSISTED,
CONSTRAINT [PK_HashbytesTest] PRIMARY KEY CLUSTERED
([ID] ASC))INSERT INTO [HashbytesTest] ([NVarCharMaxText]) VALUES (replicate(cast(N'Text' as nvarchar(max)), 5000))
Fails with:
Msg 8152, Level 16, State 10, Line 1
String or binary data would be truncated.
The statement has…0 votesUpvotes: 48
<=-=May 30 2007 4:34PM=-=>Hi,
Thanks for your feedback. We are triaging all the possible enhancements to the future releases of SQL Server. We will look into the feasibility of supporting Large data types in Hashbytes function, in a future release of SQL Server. Thanks again for your suggestions. These will help us make SQL Server a better product.— srini
<=-=May 6 2008 4:57PM=-=>
Program Manager, Relational EngineCould someone please fix the documentation???
http://msdn.microsoft.com/en-us/library/ms174415.aspx
Which currently states that the output is limited to 8000 bytes! This is wrong.
<=-=Mar 27 2009 2:40PM=-=>None of the supported hash algorithms produces an output that exceeds varbinary(8000). So what’s wrong with the docs?
<=-=Aug 11 2009 11:53AM=-=>Same error message with SQL Server 2008 R2 August CTP
<=-=Jan 13 2014 9:01AM=-=>The same error almost 7 years later, in SQL 2012 (11.0.3393). Microsoft come on, fix it!
<=-=Feb 19… -
If database files not available, trying to connect displays wrong error message
If the database files (*.MDF and *.LDF) are not available, trying to connect yields the wrong error message
0 votesUpvotes: 0
<=-=Jan 9 2006 2:28PM=-=>Need exact error message to help troubleshoot
<=-=Jan 14 2006 2:53PM=-=>Creating databases on network share is not a good idea anyway…
<=-=Apr 28 2006 2:52PM=-=>We cannot reproduce the messages that were mentioned in this report.
Here are samples of messages that we encountered while attempting to reproduce this issue:
Msg 5120, Level 16, State 101, Server *, Line 1
Unable to open the physical file “d:\test\test.mdf”. Operating system error 5: " 5(Access is denied.)". File activation failure. The physical file name “d:\test\test.ldf” may be incorrect.
Msg 4064, Level 11, State 1, Server *, Line 1
Cannot open user default database. Login failed.If you are still encountering this issue, please reactivate this error report and provide the following additional information:
- error messages that you received - a description of the steps that can be used to reproduce this issueThanks
-
September CTP - COM Error when creating or modifying any data connection on Windows Server 2003 SP1
After rebuilding a Windows 2003 Server SP1 machine from scratch and installing September CTP, any attempt to modify an existing connection or create a new connection to a SQL Server database results in the following error:
THIS ERROR IS CRITICAL TO THE POINT THAT NO WORK CAN BE DONE ON THE MACHINE. IT WORKED FINE WITH THE JUNE CTP.
TITLE: Microsoft Visual Studio
------------------------------Retrieving the COM class factory for component with CLSID {C8B522D0-5CF3-11CE-ADE5-00AA0044773D} failed due to the following error: 8007007f.
------------------------------
BUTTONS:OK
------------------------------0 votesUpvotes: 1
<=-=Oct 11 2005 12:36PM=-=>I was not able to reproduce this on latest build, but if it is still happening please try to uninstall/reinstall or to manually re-register oledb32.dll.
Sergei Ivanov
Integration Services Development Team -
0 votes
Upvotes: 1
<=-=Jul 11 2005 3:15PM=-=>I just tried to copy two stored procedures from a 2000 to 2005 and from 2005 and 2000 and it all worked fine:
1. You may have an old version (if this is the case, hopefully once you get a new drop it will be fixed) or,
2. you not have set CopySchema property to true (if this is the case, try setting it and see if it works. If it does great, if it doesn’t then probably you need a new drop) -
Install Microsoft SQL Server 2005 CTP directory missing entries
If one first installs only the SQL Server 2005 database component off the CD and then
installs desktop components, the start/all programs/Microsoft SQL Server 2005 CTP/ directory is missing the new entries.What happens is that you install the secondary components sucessfully, but the entries for the secondary componets are missing from the start/all programs/Microsoft SQL Server 2005 CTP/ directory.
A full install works correctly.
0 votesUpvotes: 0
<=-=Sep 28 2005 6:04PM=-=>Thanks for the feedback. Can you please clarify your repro steps? You first install the SQL Database. How did you go about adding the “desktop tools” after that? Also, which specific components do you mean when you say “desktop tools”? Do you mean Managament Studio? Thanks, Mike
-
SQL Server 2005 Express Exdition dos not uninstall everthing
I have installed MS SQL Server 2005 Express edition. When I uninstall MS SQL Server 2005 some programs do not get removed from the Add or Remove Programs.
The programs that do not get uninstalled:
1) MS SQL Server 2005
2) MS SQL Server Native Client
3) MS SQL Server Server Setup Support Files(English)
4) MS SQL Server VSS Writer0 votesUpvotes: 1
<=-=Feb 7 2006 9:48AM=-=>Thanks for the feedback. Please include your log files. Did you have ANY other SQL 2005 instances or components on the machine. The fact that the MS SQL Server 2005 entry remained in Add or Remove Programs indicates that another instance is still on the machine. Also, please close and reopen Add or Remove Programs to ensure it gets refreshed. We have seen on numerous occassions that items don’t get removed from Add or Remove Programs until it is refreshed. Please double-check and reactivate this bug when you have more info. Thank-you, Mike
-
sp_reset_connection need to clear CONTEXT_INFO
sp_reset_connection does not clear CONTEXT_INFO
It is possible with connection pooling enabled to read the CONTEXT_INFO of a previous session. This is especially true when a web-server is making hundreds of connections of behalf of web-users.
0 votesUpvotes: 4
<=-=Aug 22 2006 12:44PM=-=>Saying “won’t fix” without saying why doesn’t help. This is clearly a security bug that needs to be fixed.
<=-=Sep 26 2006 11:05AM=-=>Hi
Thanks for the feedback. We’re considering addressing this in an upcoming Service Pack of SQL 2005 and future releases of SQL Server.- Christian Kleinerman
<=-=Oct 13 2006 5:17PM=-=>Hi Jack!
Thank you for filing bug 126925
(http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?Feedb
ackID=126925).I actually couldn’t repro it, so I’m having several questions.
1. What is exactly version number of your SQL Server?
2. What client API of what version are you using to connect to it
at the client?
3. I need a clarification on your repro sequence (between /* Load
the saved context info / and /But hope that the connection pooling gives you the same connection*/comments). Do you assume somewhere in the middle the connection is reset? Or you… -
SQL Server Express 2005 fails to install
I had successfully installed the 2005 express versions of VC++, VC# and Web Developer, and SQL Express (downloaded as .img files). This was working, as I tried out the security options in asp.net 2.0, which uses at database.
I then uninstalled SQL Server 200 Express and tried to reinstall it. If fails, with no error message.
I tried uninstalling all the express 2005, and running through the cleanup process at http://blogs.msdn.com/astebner/archive/2005/04/16/408856.aspx.
I deleted all files under Program Files\Microsoft SQL Server, and tried again, with the same error.
I attach log files.0 votesUpvotes: 1
<=-=Jun 5 2006 3:08PM=-=>Thanks for your feedback. Looks like there is a sql instance already installed with the same instance name as what you are trying to install. You can either install with a different instance name, uninstall the instance thorough Add Remove Programs or at a last resort, file the manual uninstall steps at: http://support.microsoft.com/kb/909967/en-us
If this does not resolve your issue, please let us know.
<=-=Jun 5 2006 3:32PM=-=>Microsoft comments: Thanks for your feedback. Looks like there is a sql instance already installed with the same instance name as what you are trying to install. You can either install with a different instance name, uninstall the instance thorough Add Remove Programs or at a last resort, file the manual uninstall steps at: http://support.microsoft.com/kb/909967/en-us
If this does not resolve your issue, please let us know.
<=-=Jun 13 2006 1:37PM=-=>I tried following the manual removal…
-
If a newer version of XMLParser is installed, SQL server installation fails
Even if a newer version of XMLParser6 is installed on mechine, SQL server setup tries to installs its bundled version of XMLParser6 which fails.
0 votesUpvotes: 1
<=-=Sep 26 2005 9:00AM=-=>Hammad, Thanks for reporting the problem with MSXML6. We think we’ve fixed this in a later build, but to be sure we fully understand the problem you’re hitting, please reactivate and attach the log files from: Program Files\Microsoft SQL Server\90\Setup Bootstrap\log\files\*. You can zip the files before attaching them.
-
Schemas is not included in Alter Trigger statement
When I try to Alter Trigger, in SQL Server Management Studio, with popup menu action 'Modify' or 'Script Trigger as' - 'Alter To' new query Schemas name is not included in Alter Trigger statement:
ALTER TRIGGER [trg_Something]
ON [Schema].[Table_name]
AFTER DELETE
ASWhen I want to realy alter triger, by pressing 'Execute' button, I get an error message thet triger does not exist. So I have to add monualy Schema name in Alter trigger statement:
ALTER TRIGGER [Schema].[trg_Something]
ON [Schema].[Table_name]
AFTER DELETE
ASAfter that everything is working fine.
0 votesUpvotes: 4
<=-=Jan 20 2006 11:16AM=-=>Hi Tancev,
<=-=Jan 21 2006 2:38PM=-=>
Thank you for your feedback. We will consider your request as part of work to de done with Generate Script Wizard for a future release.
Thanks,
Ramesh SinghExcuse me, but what to you mean with future release? Surely you don’t mean that you don’t plan to fix this in a service pack? This is not a feature request, but a plain embarrassing bug.
<=-=Mar 27 2006 8:20AM=-=>Quick update. We are accepting this bug for the next round of fixes for SP2.
<=-=Apr 18 2006 4:44PM=-=>This defect no longer happens in SP1 binaries.
-
while installing SQL server 2005 express, windows installer cannot be accessed
Windows installer cannot be accessed, error 1601,
0 votesUpvotes: 1
<=-=May 19 2006 9:56AM=-=>Thank you for your feedback. For us to investigate this issue, can you supply us with the log files located at programfiles\Microsoft SQL Server\90\Setup Bootstrap\LOG.
Thank You,
Peter Saddow
- Don't see your idea?