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. SSMS 17 Tools > Options > Environment > Fonts and Colors missing Display items

    In a generic SSMS 17.2 install on a Windows 7 64-bit workstation, if I open Tools > Options > Environment > Fonts and Colors, I only get 3 items in the 'Display items:' list: Plain Text, Selected Text, and Inactive Selected Text. I have no options to change anything else. In my SSMS 2016 install, I have over 200 items in the 'Display items:' pick list. Comparison screenshot here: https://imgur.com/a/XiGMm

    I have tried resetting all settings to default in the Import and Export Settings Wizard. No change.

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

    We’ll send you updates on this idea

    19 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. Visual Studio 2017 SSDT adds hardcoded master.dacpac include

    Visual Studio 2017 seems to add a hardcoded path to the master.dacpac if I include it in a project of mine. Older versions of the SSDT used the $(DacPacRootPath) variable to get the master.dacpac.

    This is really annoying as it breaks the builds on our build server where the master.dacpac is installed in a different folder than on my development machine.

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

    We’ll send you updates on this idea

    12 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. SQL Management Studio Copy Database Wizard Broken

    Copy Database Wizard is not working for local copy operation. v17.5 There are previous bug reports when trying to copy a SQL201x -> SQL2017 DB using management studio 17.x . However, it appears you cannot copy a SQL2017-SQL2017 DB as well using the same wizard using the SMO option when copying without taking the DB offline. ERR: Property HasMemoryOptimizedObjects is not available for Database '[test]'

    File attached

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. SSMS 17.3 Font and Color setting limit changes to 4 areas

    After upgrading to ver. 17.3 of SSMS 2017, I am unable to enlarge the default font size used for grids or the object explorer (Environment Font). After running a search I several posts in the SQL Server Forum, but after trying the fix mosts sided, which was uninstalling 17.3, then install 17.2 and do the upgrade to 17.3. This was ineffective for me and others.

    Under "Show settings for:" instead of listing all the options that should be listed, I see only the following. This is obviously a bug. Has anyone found a solution that fixes this problem?

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

    We’ll send you updates on this idea

    5 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. new TRANSLATE function syntax not recognized by SSMS 17.3

    The new TRANSLATE function is not recognized as valid syntax by SSMS 17.3 intellisense, though it executes just fine against SQL Server 17 instances. The TRANSLATE syntax is underlined in red with the warning "'TRANSLATE' is not a recognized built-in function name"

    Tested against SQL Server 17 RTM.

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

    We’ll send you updates on this idea

    completed  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. SSMS v17 - Object must implement IConvertible. (mscorlib)

    When a query is selected with the mouse/keyboard, and then "Analyze Query in Database Engine Tuning Advisor" option in the context menu is selected the following error appears.

    "The argument type 'server type = Sql, server name = KSHQ-DB, timeout = 30, database = KSH_Cloudcare, protocol = NotSpecified, workstation = , integrated security = True' cannot be converted into parameter type 'Microsoft.SqlServer.Management.Common.SqlConnectionInfo'. (mscorlib)
    Object must implement IConvertible. (mscorlib)"

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Replication for SQL Server on Linux

    We currently run our application using on-premise SQL servers defined as subscribers.
    There is a plan to add client from Linux to run with one of the subscribers.
    If SQL Server 2017 on Linux had a replication we would install instantly.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSMS Install with SQL Server 2016 causes Device Manager conflict on VS location sensor driver

    If you take (as an example) a clean machine, with no VS or SQL Server yet, install SQL Server 2016 (say community but doesn't matter), Device Manager is fine, no conflicts (no VS location sensor driver yet)...Then you install SSMS (production/GA version 16.5.3), you get a Device Manager conflict (yellow exclamation mark/can't load driver error) on a new sensor entry called "Microsoft Visual Studio Location Simulator Sensor".

    8 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 →
  9. Problem when filtering jobs with the Job Activity Monitor on SQL Server 2014

    I'm getting an error every time that want to filter the Executing jobs and set the View refresh settings to n seconds (5 seconds in my case). The filter works fine while there are jobs executing but once all the jobs finish their execution then the Job Activity Monitor window throws the following exception:

    Index was out of range. Must be non-negative and less than the size of the collection.
    Parameter name: index (System.Windows.Forms)


    Program Location:

    at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
    at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
    at Microsoft.SqlServer.Management.UI.ActivityMonitor.ActivityMonitorUserControl.WorkerEntryPoint(Object o)
    After that exception the Job Activity Monitor…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSMS Intellisense shows useless parameter names for functions like REPLACE, SUBSTRING

    For functions like REPLACE, SUBSTRING, etc., the Intellisence shows the parameters as Expreession1, Expression2, etc. instead of useful parameter names like Expression, Pattern, Replacement. g (max. 5000 Zeichen)

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

    We’ll send you updates on this idea

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

    Hello

    In both SSMS 17.9.1 as well as SSMS 18 Preview 6, both REPLACE and SUBSTRING functions show meaningful hints.
    For REPLACE we show – expression_to_be_searched , search_expression, replacement_expression .. etc.
    For SUBSTRING, we show expression, starting_positionm length etc.

    If you are using older versions of SSMS, please update to the latest version as we are currently not supporting any versions older than 17.9.1.

    thanks,
    Dinakar

  11. SSMS 2016 does not remember added SQL Snippets folder

    You can add your own snippets in SSMS bij using the Code Snippet Manager.
    In the Code Snippet Manager window you have the possibility to add a folder containing customer snippets by using the "Add..." button.
    This works fine as long as you're not closing SSMS. After restarting SSMS you have to add the folder again because it is no longer available in the snippets.

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

    We’ll send you updates on this idea

    23 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Make Scalar UDF with no data access running parallelly

    There are different scalar-value UDFs:
    - (1) Interpreted T-SQL UDF,
    - (2) Natively Complied T-SQL UDF and
    - (3a) CLR UDF with DataAccessKind.None, which is default option.
    - (3b) CLR UDF with DataAccessKind.Read.

    For CLR UDF, if its USERDATAACCESS = 0, then it�s not a parallel plan blocker.
    For other type of UDF, even we use WITH SCHEMABINDING option, and USERDATAACCESS = 0, it�s still a parallel plan blocker.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSMS 2016 "Help -> View Help" always opens online, regardless of selected preference

    Similar to the previously fixed bug when using the "F1" key to open help. It would be nice if the menu item worked as well.

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

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. PLEASE CLOSE: SSMS Disk Usage reports showing #Error

    SSMS 16.5 is showing '#Error' in lots of places in the built in reports such as Disk Usage, Disk Usage by Table, Backup and Restore Events. This is SSMS 16.5 on Windows 10 Pro. This is repeatable on both my local instance (SQL 2016 Developer) and on remote SQL 2014 SP2 CU2 instances.

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Dec 13 2016 1:00AM=-=>

    Please close. The problem has gone away again. It must have just got into a confused state.

    <=-=Dec 27 2016 1:26PM=-=>

    I was able to reproduce this a single time, which happened to be the first time I opened SSMS 16.5.1 (13.0.16100) on a new Windows 10 installation. The next time I opened SSMS, disk usage reports worked correctly.

    <=-=Jun 29 2017 10:56PM=-=>

    I’m also unable to repro this issue using SSMS 17.1. I’m closing it, as per David’s comment.

    Thanks,
    -Matteo

  15. SSMS install location

    SSMS should not be "magically apple installed" to wherever it pleases. it should ask me where the #$@% I want it to live. How the hell do you drop such a simple and basic feature? Rationalize all you want about how nobody needs it, or it has a small footprint so it's ok, or ... or ... - but it's stupid.

    Simple stuff MS, stop turning into Apple and find your way again... atm you're lost on every simple thing and customers like my enormous company are starting to fall away... (We dropped dozens of sql server installs this year)

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. 'System.OutOfMemoryException' thrown by even small selects randomly now

    I recently upgraded to SQL Management Studio version: 13.0.15700.28. The upgrade was successful from the previous version but now the application will regularly give a 'An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown' exception. This would be normal if it was for large datasets, but it is occuring doing 'Select top 10 * From (object)'. It occurs generally after a few hours of use and not right away when opening it. However I use to leave SSMS open for days with multiple sessions and this never happened till the current upgrade. I am…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 32

    <=-=Aug 23 2016 8:28AM=-=>

    I am seeing this as well. I installed the update on 2 machines, one Windows 10 Surface Pro 4,16G RAM, and one Windows 7 SP 1, 8G RAM. When I look at the Task Manager (which may not be accurate), it shows that I’m only using 8 of 16G total on the machine and SSMS is only using 164Mb Both systems have been exhibiting since within an hour after I upgraded. The message is coming up on really small queries. The last one, I declared a table variable with one column in it and inserted 11 rows and it gave the out of memory. Clearly, this cannot cause out of memory. I do have multiple tabs open, but not too many. Currently, 3 sql tabs and 2 XMLA tabs. 2 SQL Servers and 2 SSAS Servers open in Object Explorer. Really not…

  17. Intellisense for REPLACE function is useless

    Please have a more helpful Intellisense description for the REPLACE function...

    You need to come up with something better than REPLACE(expression nvarchar(1), expression nvarchar(1), expression nvarchar(1)) RETURNS nvarchar(1)

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. SQL Server 2016 - Merge statement fails when running db in Simple recovery model.

    My ETL process is failing when I try and load data into my fact table using a SQL merge statement. We are using SSIS which calls a SQL task containing a SQL merge statement. The exact same setup and ETL process works in SQL 2012 Standard but not SQL 2016 Developer.

    Full error text: DESCRIPTION: SQL Server Assertion: File: <pageref.cpp>, line=955 Failed Assertion = 'ISOFF (BUFMINLOGGED, mbuf->bstat) || pageModifyType != PageModifyTypeContents || GetPagePtr ()->IsTextPage ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for…

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

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 20

    <=-=Jan 12 2017 1:22AM=-=>

    In version 13.0.4001.0, the problem persists.

    <=-=Jan 22 2017 12:45PM=-=>

    I believe this has been resolved in SQL 2016 SP1 CU1 specifically KB3205964. :)

    <=-=Mar 14 2017 2:03PM=-=>

    We have this issue on SQL Server 2016 Standard Edition with CU1 (13.0.4411.0.). Applying the workaround (set DB to FULL recovery) works � the SSIS packages run without issue.

    KB3205964 states that the bug was fixed and applied to SQL 2016 Developer, Enterprise and Enterprise Core editions. We are on Standard edition so this looks to be a variation.

    The affected SQL Server was an in-place upgrade from SQL Server 2014 Standard to SQL Server 2016 Standard as follows:
    - Original build was SQL Server 2014 (SP2-CU2-GDR) (KB3194718) – 12.0.5532.0 (X64)
    - Performed in-place upgrade to SQL Server 2016 with SP1 (13.1.4001.0)
    - Applied CU1 for SQL Server 2016 SP1 (13.0.4411.0)

    Current build of…

  19. SSMS Query Shortcuts' Import/Export do not work

    When in SSMS you create a Query Shortcuts (Alt-T + O -> Environment -> Keyboard -> Query Shortcuts )
    You can't save it with other settings and restore it on another PC or the same PC.
    That bug goes from as early as SQL 2008. Persist in all editions, in all windows systems and on both 32/64 platforms.

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

    We’ll send you updates on this idea

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

    For SSMS 18.X These settings are saved along with many other SSMS settings in APPDATA\Microsoft\SQL Server Management Studio\18.0\UserSettings.xml If you would like to bring these settings over to another machine you can either copy this xml file over to a new machine or since this file is user-readable you can copy just the QueryShortcuts section and paste it in the corresponding location in the UserSettings.xml on the target machine. If this file does not exist it is automatically generated after the first run of SSMS.

    Hope this helps
    - Erica

  20. Allow users to disable phone-home feedback in SQL 2016 Developer, Express, and Evaluation Editions

    By default, SQL Server 2016 phones home with telemetry data as described in https://support.microsoft.com/en-us/kb/3153756. Let users disable that telemetry in Developer, Express, and Evaluation Editions.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 325

    <=-=Jun 2 2016 10:19AM=-=>

    From https://www.microsoft.com/EN-US/privacystatement/SQLServer/Default.aspx, “It is possible that personally identifiable information may be captured in memory or in the data collected from open files, but Microsoft does not use it to identify you.”
    My developers must write and use interfaces to bank cores. Because of https://support.microsoft.com/en-us/kb/3153756, my developers will potentially be sending MS the bank accounts, names, addresses, social security numbers, birth dates, and various passwords for millions of US citizens. This is unacceptable.

    <=-=Jun 2 2016 11:26AM=-=>

    I was going to install it on my report server but I can’t if this isn’t fixed because even the potential of leaked data is serious to my clients. In fact, I already keep a SQL express version separate for my internal reporting from my non-express SQL Server engine to minimize exposure. That means I’ll need to stick with 2014 which is too bad as I…

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base