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.

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.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. KJTAP � MIP: Re-installation of PowerPivot Add-in doesn�t enable the add-in.

    Excel crushed when I was working on a Gemini model. After the crush PowerPivot add-in disappeared. I re-installed PowerPivot add-in by uninstalling the existing add-in from Control Panel and installing PowerPivot from the drop location. Still PowerPivot add-in wasn�t available in Excel. I had to manually enable it.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jan 7 2010 2:36PM=-=>

    Thank you for providing this feedback. We are currently investigating the reported functionality and will provide updates as we have them.

    Thank you for assistance,
    The Analysis Services Team

    <=-=Apr 1 2013 9:55AM=-=>

    Hello,

    This issue is resolved when you use the Excel 2013 version of PowerPivot. Closing it as fixed.

    Regards,
    The Analysis services team

  2. Multi-Select Issues - connecting to Analysis Services 2008 using Excel 2007

    We are creating reports on in Excel 2007 pivot tables connecting to Analysis Services 2008.

    If we create report with one attribute from dimension at Row Level and another attribute from same dimension is at report filter level
    when I try to do multi selecting and unselect some members on both the attributes, Excel throws up following error

    Internal error: An unexpected exception occurred

    When I try to execute MDX query generated by Excel it shows up same error.

    Same process doesn�t show any error in SQL management studio.
    Query generated by SSMS and Excel are different.

    Also same process…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 4

    <=-=Jan 8 2010 3:51PM=-=>

    Thank you for providing this feedback. We are currently investigating the reported functionality and will provide updates as we have them.

    Thank you for assistance,
    The Analysis Services Team

    <=-=Sep 28 2011 9:37AM=-=>

    It turns out that this bug got filed in our system twice. We are resolving one of the bugs as a duplicate of the other. The other copy of this bug will remain active and the plan is to address it in the release (or in an update) that follows Denali.

    Thanks,
    Howie Dickerman
    Analysis Services Product Team

  3. TempDB Log file showing free available space in negative.

    One of the SQL Server(Microsoft SQL Server 2008 (SP1)) went out of space. The tempdb is showing one strange behavior.

    When I tried to shrink the files, I saw the available free space in negative numbers as highlighted. Even the free space percentage is too weird.
    The screenshot is posted on dbtalk@microsoft.com.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 11

    <=-=Sep 24 2010 1:11AM=-=>

    running SQL Server 2005. The server ran out of space because tempdb grew unproportioanlly large. Recovered space but now tempdp is showing available free space in negative. Both for data and log file. If we restart the server, it would adjust but after data loads it goes back to negative.

    <=-=Aug 11 2011 2:14AM=-=>

    Hi

    Greetings from the SQL Server Manageability team.

    Thanks for writing in to Microsoft. We greatly value your feedback.

    We tried reproducing the problem that you are facing, but not able to observe the issue that you describe. If you can consistently repro this, please get back to us, with detailed configuration and repro steps.

    Thanks again for providing feedback and making SQL Server the greatest Database server.

    Regards,
    Sai.

    <=-=Jul 6 2012 12:52PM=-=>

    I am having the same issue on Server 2003 with SQL Server 2005 SP3. Same situation…

  4. DATETIME parameters getting DATETIME2 values from .NET

    When creating a new stored procedure on SQL 2008 and using the older DATETIME datatype something is converting the value into a DATETIME2 style value when it tries to put it into the DATETIME datatype.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 6

    <=-=Dec 11 2009 11:09AM=-=>

    People have been talking about this problem here http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/6d455ce9-d699-46b0-9b1f-04cc8a3279ea for a bit now, but no one could actually confirm that it was submitted to the PG for resolution.

    <=-=Dec 14 2009 12:10PM=-=>

    Hi,

    This is a problem with RPC trace, which results in displaying extra zeros in SQL Server Profiler because we always print 7 fractional digit for the type DBTYPE_DBTIMESTAMP regardless of whether this comes from datetime, smalldatetime, datetime2, or datetimeoffset.

    Rest assured, the stored procedure taking a datetime parameter, and being sent a .NET DateTime is actually not using a datetime2 type despite what SQL Server Profiler shows. The stored procedure is receiving a datetime. No conversion is happening on the server in this case. This is only a tracing problem.

    Thank you for reporting that issue, we had discovered and fixed it a few month ago, and the next major…

  5. Report manager: Access to drop down menu actions.

    When logged in as a user with Browser only rights I found that users where still presented with all of the same options on the report and folder dropdown menus as an administrative user. Users should only see the actions which they have rights for.

    We do create custom roles for users to provide them with specific elevated rights within their folders but it creates confusion for them when they see actions they have rights to as well as actions they are not granted access to.

    This also creates a longer process when auditing security as we must test each…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Dec 14 2009 5:23PM=-=>

    Thnk you for filing this bug Deborah.

    After further investigation, in SSRS 2008 R2 we have decided to continue assessing the permissions after or once the user has clicked on the item in drop down context menu. We do plan to consider assessing them before and hide drop down context menu items a user does not have access to accordingly in the next major release.

    HTH
    Prash

  6. Corrupt index after doing CREATE INDEX WITH(ONLINE=ON)

    We have witnessed a strange case of index corruption after trying to create an index ONLINE the last time. The problem manifested itself in that we couldn't do an UPDATE to a few data sets after creating the index ONLINE. We could do SELECT, so we have noticed that the non-updatable rows must have been created (inserted) exactly while the index creation was underway (we have seen it because this is a "purchase" table which has a timestamp for each data set).

    The error manifested itself trough a strange ERROR message (which point at low level problems) every time we…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Dec 17 2009 6:06AM=-=>

    Andras, is the index compressed? Row or page?

    <=-=Dec 17 2009 6:57AM=-=>

    No, no compression at all (nowhere in our db).

    <=-=Jan 11 2010 6:42AM=-=>

    What are the odds to get some response on this issue?

    <=-=Jan 20 2010 1:13PM=-=>

    Andras: Sorry for the delay in the response. I have requested developer to comment on this. I assume that you rebuilt the index. I would like to know if (a) you built it ONLINE and if yes, are you still seeing the issue (b) if you built it OFFLINE, I assume the problem will not come as this is the sceanrio that has worked for you.

    thanks
    Sunil

    <=-=Jan 21 2010 2:13AM=-=>

    Well, the correction of the problem was really – as you assumed – by recreating the same indexes with normal OFFLINE. And then, the problems went away.

    But even while…

  7. An error the file path for ITOps.xlsx is not found prompts on PowerPivot Dashboard

    After I install PowerPivot for SharePoint and go to PowerPivot Dashboard, I get an error box saying the file path for ITOps.xlsx is not found. It may be a localization problem.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jan 8 2010 4:25PM=-=>

    Thank you for providing this feedback. We investigated the reported functionality and determined that it was a known CTP3 bug which has been fixed for the final release.

    Thank you for assistance,
    The Analysis Services Team

  8. Internal error: An unexpected exception occurred. (Microsoft SQL Server 2008 Analysis Services)

    Error gets introduced when running existing SSRS reports after updating the cube to include additional sets (for working with relative dates). Existing reports do not use these sets but get effected by their inclusion in the cube.

    CREATE DYNAMIC SET CURRENTCUBE.[TodaySet]
    AS filter([D Date].[Year Month Date].[Simple Date].Members,

    [D Date].[Year Month Date].CurrentMember.Properties(&quot;Date As Int&quot;) 
    
    = Format(Now(), &quot;yyyyMMdd&quot;));

    CREATE DYNAMIC SET CURRENTCUBE.[Last6MonthSet]
    AS {[YearMonthDateTodaySet].Item(0).Parent.lag(7) : [YearMonthDateTodaySet].Item(0).Parent.lag(1) } ;
    CREATE DYNAMIC SET CURRENTCUBE.[LastMonthSet]
    AS {[YearMonthDateTodaySet].Item(0).Parent.lag(1)} ;
    CREATE DYNAMIC SET CURRENTCUBE.[YearMonthDateTodaySet]
    AS exists([D Date].[Year Month Date].[Simple Date].Members, [TodaySet]).ITEM(0).ITEM(0) ;

    The following error appears when executing the dataset from the report designer:

    ===================================

    Internal error:…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 8

    <=-=Jan 8 2010 3:52PM=-=>

    Thank you for providing this feedback. We are currently investigating the reported functionality and will provide updates as we have them.

    Thank you for assistance,
    The Analysis Services Team

    <=-=Feb 4 2010 9:28AM=-=>

    Hi guys, I am having the same error, but when I want to execute any type of Drillthrough operation from the Pivot table (Visual Studio or SMMS).

    I run into the following post: http://support.microsoft.com/default.aspx/kb/957819. I have tried that approach but with no luck.

    I am running SQL 2008, SP1.

    Please any suggestion?

    Regards,

    Ben

    <=-=Feb 4 2010 9:37AM=-=>

    Hi guys,

    I solved part of the problem. I had to erase a named set. After that Drillthrough worked ok.

    Regards,

    Ben

    <=-=Apr 18 2010 2:45PM=-=>

    Hi,

    I have exactly this problem. I have a cube with approx 30 DYNAMIC SETS based on Time. When users want to filter on Time…

  9. View Dependencies fails with Transact-SQL Error 515

    "View Dependencies" operation performed against a table in in SQL Server Management Studio fails with Transact-SQL Error 515.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 22

    <=-=Jan 5 2010 11:55PM=-=>

    Hi Rdoherty,

    Thanks for reporting this issue, we are able to reproduce this issue internally when table has a filtered index on it. Please let us know if that is the case where you are hitting it too. If not, please provide clearer steps to reproduce the issue. We will try to fix this issue in our next release.

    Thanks,
    Sravanthi

    <=-=Apr 8 2010 7:16AM=-=>

    In my case, I can verify the use of a filtered index but this problem doesn’t only occur when I try to do dependencies on the object with the index. Any object with dependencies with that object is also unable to enumerate it’s dependencies because of this error.

    <=-=Apr 21 2010 3:12PM=-=>

    In this code, below, there is no provision for referencing class 7 but in my database I have 7 but your case statement does not handle this.…

  10. The query processor ran out of internal resources and could not produce a query plan with WHERE in and several thousand values

    The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. (SQL-42000)

    SELECT DISTINCT value FROM sometable WHERE id IN (several thousands of values)

    Hardly complex.
    For SQL 2005 http://support.microsoft.com/default.aspx/kb/946020

    However this does not appear to be fixed for SQL 2008

    A workaround is to build a C# CLR Tabular function…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 34

    <=-=Dec 23 2009 4:50PM=-=>

    Thank-you for taking the time to post this issue. Whilst we will not make a change to SQL 2008 to increase the limit of elements in an IN list, we are working to improve such limits generally in a future release. Please be aware however that with such queries, better performance is likely to be achieved by inserting the constant values into a temp table and performing a join with the underlying permanent table.

    Sincerely,
    Campbell Fraser
    SQL Development

    <=-=Dec 27 2009 11:32PM=-=>

    Inserting into a temp table is impractical when dynamically generating statements based on previously queried results sets where the WHERE data used orginally can not longer be used, such as after an UPDATE. Or when the process is the result of a dynamic process in a external application. In the case where I ran across this a the values being…

  11. datetimeoffset breaks sys.extended_properties

    On SQL Server 2008, adding an extended property w/ type DATETIMEOFFSET via spaddextendedproperty breaks sys.extendedproperties.

    Extended properties are still visible through SSMS -> Table -> Properties -> Extended Properties.

    Reproduced on the following systems:

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Dec 30 2009 2:53PM=-=>

    Hi Peter,

    Good catch. This bug is now assigned over to the Dev for further investigation and fix.

    Thanks,

    Jim Hogg

    <=-=Mar 23 2010 2:50AM=-=>

    Hi Peter,

    We investigated this particluar issue and the fix for this will be part of our future releases. There is a similar bug that we are tracking for this issue – http://connect.microsoft.com/SQLServer/feedback/details/379631/ssms-partition-functions-with-datetimeoffset-cause-error-crash . Given this, I am going to resolve your issue as duplicate of the other issue.

    Thanks for catching this issue and reporting to us.

    Thanks,
    - Vikrant Arora

  12. SP1 CTP Cube Designer freezes when trying to access the Calculations, Perspectives and Tranlation Design Tabs

    Clicking on these tabs results in the BIDS indicating it's loading the definitions you want to see for these tabs, but never returns.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Mar 24 2006 11:40AM=-=>

    Dave, in our initial attempts we were unable to repro this in house. We are going to continue investigating. To help us, could you please check the versions of these binaries: programFiles\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ msmdgsrv.dll and programFiles\System\Ole DB\msmdlocal.dll.?

    <=-=Mar 24 2006 12:44PM=-=>

    We have been unable to reproduce this in house. Without such repro, I’m afraid we cannot investigate the issue any further. More information might help us, such as the version of the binaries mentioned before, how much RAM you have, a history of SQL installations on this machine, whether you made changes to the AdventureWorks DW sample, etc. Thank you for your help!

  13. Using "+" instead of aggregate

    Results are inaccurate when using "+" to define calculated members inside cubes.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Apr 19 2006 11:32AM=-=>

    Dear customer: I couldn’t repro your problem by repeating the repro steps on a simple cube. Could you please provide the AS project or the AS database? You can send it to hfeng@microsoft.com. Thanks. Hanying Feng

    <=-=May 1 2006 5:40PM=-=>

    Dear Customer, I can not reproduce your problem by following the repro steps. Please provide more info. Thanks

  14. [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.

    Using the Visual Studio product to modify/test dts package that run daily on SQL Server 2000, I receive the following error:
    [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.


    1. what component?

    2. the only file name referred to is a file that is validated(correctly) in a later step

    The point being that this is an initialize global variables step.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Feb 23 2006 11:56AM=-=>

    Not able to repro this issue.
    I try to repro using:
    1) Migrated the DTS package to SSIS. Migratd, edit and execute correclty.
    2) By using the Exec2000packageTask in BIDS able to edit and execute the DTS2000ActiveX package
    Did you migrate the DTS 2000 ActiveX package?
    Are you edit the ActiveX task in BIDS using the Exec2000PackageTask
    Thanks

  15. arithmetic overflow while in the Tasks Summary Report

    arithmetic overflow while in the Tasks Summary Report.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Feb 1 2006 4:28PM=-=>

    Hi Brian,
    Thank you for your feedback. Would it be possible for your to send the dump for this crash? Please attach to this feedback/bug.
    Thanks,
    Ramesh Singh

    <=-=May 2 2006 3:00PM=-=>

    The repro steps provided do not repro the issue on SQL Server 2005 SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

    <=-=May 30 2006 12:04AM=-=>

    This bug is not reproducable on Sql server 2005-RTM and Sql server 2005-SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

  16. Severe performance degradation accessing AS2K cubes with ANONYMOUS USER and Yukon OLAP provider

    When our product, ProClarity 6.1, accesses AS2K cubes using ANONYMOUS USER access and the Yukon OLAP provider, creating a connection takes approximately 15 minutes. If I use the AS2K OLAP provider instead, connection takes less than 5 seconds. During the establishment of the connection, our product identifies a collection of unique member names that it can use as query scoped members in an MDX query. To do this we construct a potention member unique name. We then perform a MDSCHEMA_MEMBERS lookup with a restriction set to our potential name. The purpose of the lookup is to confirm that the member…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Jan 27 2006 4:44PM=-=>

    Please try including “ConnectTo=8.0” in the connection string, and let us know if it fixes the problem?
    Thank you

    <=-=Feb 10 2006 4:58PM=-=>

    I tried setting ConnectTo=8.0 The setting had no effect. A connection still required 15 plus minutes.

    <=-=Apr 24 2006 2:36PM=-=>

    “Dear gbraach, We have been unable to repro this issue. Could you please provide additional information or repro steps?”

    <=-=May 1 2006 4:41PM=-=>

    I reproduced this problem using SQL2K5 SP1

    <=-=May 18 2006 5:24PM=-=>

    Thank you for reporting this issue. Our investigation shows that there is no difference in the schema retrieval time (Proclarity connection) between Yukon provider and Shiloh provider connecting to AS 2000. This means, we are not able to repro the following: “If I use the AS2K OLAP provider instead, connection takes less than 5 seconds”. The reason of the performance degradation might be in the way Proclarity…

  17. MDX - NON EMPTY clause combined with Crossjoin() function removing calculated members from axis when they actually resolve to a n

    When the non-empty clause is added to an axis that has a dimension (other than the measures dimension) that has calculated members and is crossjoined with another dimension, the calculated members are excluded from the result set.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Microsoft SQL Server Management Studio Express raises errors on inline comments.

    Microsoft SQL Server Management Studio Express raises errors on inline comments on lines like:

    CREATE PROCEDURE SampleStoredProcedure
    P1 int, -- Param 1
    P2 int -- Param 2

    AS
    ...

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=May 27 2006 1:25PM=-=>

    This code worked for me:

    CREATE PROCEDURE SampleStoredProcedure
    @P1 int, — Param 1
    @P2 int — Param 2

    AS

    SELECT P1 = @P1, P2 = @P2
    go
    EXEC SampleStoredProcedure 47, 11
    go
    DROP PROCEDURE SampleStoredProcedure

    Could you supplement the bug report with a complete repro that demonstrates the problem?

    <=-=May 30 2006 2:44PM=-=>

    Hi Andy,
    Thank you for your feedback. We are unable to reproduce this in build 09.00.2047 – the SSMSE RTM build that we shipped with SP1.
    Thanks,
    Ramesh Singh

  19. SSIS Data Mining Query Task: Prediction Join "erased"

    After a given user creates a Data Mining Query Task in SSIS and saves the package or project, when another user opens the package or project, the contents of the "Query" tab in the Data Mining Query Task (the prediction join) is erased.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Jun 27 2008 7:03PM=-=>

    Hello Paul.

    Thank you a lot for reporting the problem to us.

    Unfortunately it is too late for the current release of Analysis Services to take any action on this matter.
    We are going to take a look at this in the next release.

    Thanks.
    The Analysis Services Team.

  20. Management Studio DMX Query crash

    When trying to execute an DMX Query within Management Studio 2008 RC0, I get an error is produced:

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Jul 25 2008 12:33PM=-=>

    Lachender.

    Thank you for reporting this problem to us.
    Unfortunately it is very hard to say just based on the information in this case on what is happening with the SQL Management studio. Or whether the problem is with Analysis Services.
    To troubleshot some more we suggest you try and run SQL Server Profiler against Analysis Server.
    See if you get any server errors as responce to your query.

    The Analysis Services Team.

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base