Flat file connection manager Row Delimiter property does not work Provide function to retrieve the entire call stack SSIS FTP Task always fails on delete remote files Schema not reported in the ERROR_PROCEDURE function SQL Reports should support stylesheets Prompting for modified windows when closing SSMS should be optional ALTER TABLE syntax for changing column order Default Hierarchy for Dimension Changes to underlying data is not available when the refresh button is clicked in report designer Change all connections Improved error message when you try to put too large a value in a column Poor execution plan with CTE Show Execution Plan for User Defined Functions (UDF) Support row constructors for conditional expressions Ability to disable or workaround deferred name resolution CREATE OR REPLACE NATURAL JOIN and USING clause in joins SQL Server 2005: sp_helpindex Add a Trim function Provide a hint to force intermediate materialization of CTEs or derived tables Int32 overflow behavior SQL Engine - BULK EXPORT command Create an empty raw file with required metadata Storing IEEE 754 Floats in SQL Server 2005 (NaN, +/- Infinity) Copying packages results in duplicate package GUIDs and enclosed task GUIDs Rebuilding a Partitioned Index Truncate Table when FK are disable Online Partition Rebuilds Where the hell is LIMIT like in MySQL? Add style or stylesheet or template to Reporting Services reports Allow literals and read only table data to be represented as enums OVER clause enhancement request - ORDER BY for aggregates OVER clause enhancement request - LAG and LEAD functions OVER clause enhancement request - ROWS and RANGE window sub-clauses OVER clause enhancement request - DISTINCT clause for aggregate functions OVER clause enhancement request - FIRST_VALUE, LAST_VALUE functions Deprecation of sysprocesses - DMVs doesnt fully replace all columns Add new substring function where third parameter is end and not length Add a built-in table of numbers PATINDEX Missing ESCAPE Clause Add optional checks for more robust development Regex functionality in pattern matching Clearing dm_db_missing_index_* Add server-side compilation ability to SQL CLR Add Global variables to SSRS for Browser DateTime and TimeZone Cannot have nested INSERT ... EXEC HASHBYTES function should support large data types The Scalar Expression function would speed performance while keeping the benefits of functions. add SQL beautifier/formatter SSIS cluster aware Import excel data with OPENROWSET on production server Add language and optimizer support for ISO <distinct predicate> SSMS : Table Designer uses deprecated objects Surface Area Configuration utility should request elevation on Vista ALTER COLUMN IDENTITY Disappearing Values in Set Values tab of SQL Agent Job Maintenance New Server Role Suggestion dbreader Job Owner Reverts to Previous Owner when Scheduled Maintenance Plan is Edited Add FINALLY clause for TRY-CATCH block Change UNIQUE constraint to allow multiple NULL values Add support for ANSI standard row value constructors Relax restriction that table parameters must be readonly when SPs call each other. INSTEAD OF DDL Triggers and DMF Spatial library assembly should support SilverLight deployment and dependencies Allow Common Table Expressions in all query expressions Expand synonym to other entities (database, linked server) SSIS Aggregate Transform Should Allow MIN/MAX On Strings SQL Server incorrectly accepts prefixes in column list of INSERT statements Flat File Parser cannot import files with embedded text qualifiers Management Studio: Error highlighting: method calls (ToString) Change Tracking : Provide DATETIME column MSFT-MSO: Support ALTER TYPE SSIS Expression Date Functions Incomplete - Missing New Data Type Support SQLISPackage100 Event ID cannot be found. Performance data collection Collation error behaviour option 1) Preview in report designer. Statistics are saved on table level and not on partition level Default Schema for Windows Group SCOPE_IDENTITY() sometimes returns incorrect value MSFT BICOE CSAT : sp_helpIndex results should include the Filter expression of Filter Indices SSMS should not have ARITHABORT set by default Data Collector: Remove Data Collector to Remove Associated Objects Word breaking timed out for the full-text query string Katmai Reporting Services 2008 Tablix control Repeat Column Headers does not work SSMSs SQL Server Template doesnt refresh automatically SSIS: Package Parts Please fix the String or binary data would be truncated message to give the column name IntellliSense backward compatibility Display Only SQL Server Objects That You Have Access To keyboard shortcut Alt+F1 (sp_help) doesnt work for tables belonging to non-default schemas SSMS : Activity Monitor has no feedback that it is doing stuff DBCC DBINFO Bug - Msg 407, Level 16, State 1, Line 1 Wrongly Busy Cursor Icon Invoke-SQLCmd Add parameters through the use of hashtables Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view SQL 2012: report model accept parameterised inputs (reporting services) Sample Policy has incorrect properties in the condition False Network Binding Order warning during Setup Support Rules check of cluster installation SQL Express RC0 installs SQL Agent Service for no apparent reason T-SQL: use scalar functions as stored procedure parameters SSMS : parser thinks INT(4) is ok Add a is_valid_convert function Support syntax for typed literal values Running a custom report in SSMS fails Reporting Visual Studio: ShowGrid is not working Characters and linebrakes are disappering in a Job with powershell that holds an \ SQLServer Exception with SPs that start with Sys, contain TVP, and accessed via ADO.NET Invoke-sqlcmd PowerShell cmdlet fails when array passed via -Variable Have a separate collation for metadata in a database Hovering mouse over execution plans query line is CPU killer SSIS Lookup Transformation Query fails if temp table is utilized in underlying stored procedure SSMS RTM Table Limit SSIS: Missing If Control Flow Container temp table and table variable visibility through debug Add support for CSS and branding in report builder Add Templates for Report Builder 2.0 SQL Server 2008 Installation Error on WinXP SP2 : Access is denied DOC : CDC topic sys.fn_cdc_map_time_to_lsn references wrong function name Missing Index report is incomplete SSIS100 BI Studio: Hangs While Editing Package SSIS 2005 - WMI Connection Manager does not accept calculations for the server name property BIDS display of connectors/containers in SSIS Control Flow lacks depth control SSIS : Allow for validation to be stopped on package loading Synonym in local view to remote table causes schema version error In Sqlcmd scripts setvar should have a lower precedence than command line variable assignments SSRS 2008 - Bizarre Bug with Excel rendering MSSQLOLAPSERVICE start request failed SQL Server Extended Events Page/Split Event Additions Invoke-SqlCmd should have ability to capture verbose output Localize report parameter prompts in Reporting Services reports Add sys.indexes create_date and modify_date fields SSRS 2005 Does Not Completely Uninstall Recycle Bin for Microsoft SQL Server full justification in reporting services 2008 needed XQuery: SQL type datetime is not supported in XQuery (sql:variable and sql:column functions) Merging / Linking datasets on report level (SSRS 2008) Please remove auto shrink from maintenance plans Keep together property not working in SSRS 2008 SQL Server doesnt have an ANSI INTERVAL data type SQL Server Agent add Configfiles from previous jobstep RSClientPrint font rendering wrong when printing Filtered index not used and key lookup with no output No way to see contents of table valued variable in debugger Update statistics, top 100 percent and Sort warnings Provide more granular rights for subscription creation, only allow user to choose shared scehdules Allow backup of database in standby mode Index ID 255, Fatal Error Msg 602 Date Format always reverts to US date format when Scripting Database Objects SQL Server 2008 Periodically Does Not Accept Connections NOT save rdl.data file with report Update Statistics at the partition level MAXDOP option in DBCC CHECKDB SSRS 2008 Font Type Support MAX(RowNumber) in CTE table doesnt return the correct value NEWSEQUENTIALID bug in management studio Persian Hijri Shamsi Datetime Change Default Recovery Model Scripting a DROP of a column DEFAULT is incorrect when table is in a user-defined schema New-PSDrive with SQL Authentication internally is using Integrated Authentication SSRS 2008 3D bar chart data labels SSIS Term Extraction Transformation Custom Dictionary Cannot use Analysis Services Connection Manager from Data Source Full powershell shell Intellisense in SQLCMD Mode SSIS Flat File Connection Manager: Cannot set precision for Decimal columns Cannot copy >100,000 rows of text from SSMS editor or results window to clipboard Query causes A severe error occurred on the current command message, and sporadically causes the server to shut down. Enable code outlining regardless of what SQL version of SSMS is connected to Report Builder Improvements Provide Support for Import and Export Settings in SQL Server 2008 R2 VS 2008 IDE hangs on SSIS package ot task validation when connection is not available Allow Sub Folders in SSRS Projects Stroing the checkpoints in SQL server instead of File server Partition processing slow due to object dependancy checking using transitive closure Fuzzy lookup triggers SQLDUMPER, even with very small dataset with Run64BitRuntime set to false xml.exist() bug SSIS- date format metadata DCR: Gemini - Table and Views import filter Invoke-SQLCmd should be able to capture multiple results in container object Internal Error, invalid pane configuration. Creating Filestream enabled database crashes computer SSMS 2008 Object Explorer Details for Functions SELECT statement fails with Expression evaluation caused an overflow SSIS VS2010 project type SQL Server 2008/R2 - SQLPS mini-Shell Upgrade to v2.0 The login form on SSMS 2008 R2 does not fill-up the last used login and password to connect to a database engine. SSMS Connect to Server, connect with different Windows Authentication Copy-Paste does not working properly in SQL Server Management Studio Error after creating Policies on SQL Server 2008 Build 10.0.2531.0 SP1 SSRS 2008 image rendered too small i PDF when used as a marker in a line chart A Better Collision-Free Hash Function for Comparing Rows of Data Insufficient memory to continue the execution of the program - SSAS Cube Browsing [SSAS] Visual indicator for when Cube Designer may be presenting wrong info Storage Name (File Group or Partition Scheme Name) Missing on Generating Non Clustered Index Create Script from SQL Server 2008 Management Studio SSRS Report Templates Service Pack 4 for SQL Server 2005 SSIS projects in BIDS, adding an existing package shouldnt create a copy Access database preview within OLE DB Source Editor fails if table name contains a space. Provide a graphical interface to the SQL Server Agent job scheduler and history An INSERT EXEC statement cannot be nested Access Violation occurred reading address FFFFFFFFFFFFFFFF while ALTER INDEX Make more functions SARGable Report Builder 3.0 wont connect to SharePoint site collection other than the first one TOP3DCR: Integration of IMBI storage into mainline Analysis Services product TOP3DCR: Gemini use less memory TOP3DCR: Improved joining capabilities in Gemini TOP3DCR: Some kind of classification interface for slicers in Power Pivot Error 3964 on CREATE INDEX on temporary table under SNAPSHOT ISOLATION LEVEL QUALIFY - Request for a New Filtering Clause Support local disk location for TempDB in failover cluster installation Allow backup/restore Snapshot databases Reporting Services should support include files via Code Inclusions PowerPivot Trace event classes 72, 82 and 83 not recognized by Profiler Find in Current Project in SSMS opens many many files Cannot uninstall sql server 2005 express toolkit Reason Geometry is InValid Creating custom server-level roles Merge Replication SQL Server 2008->2005 fails SET (LOCK_ESCALATION = TABLE) could not be propagated to the subscriber PowerPivot relationhip type detection SQL Server should not raise illogical errors Upgraded SSIS packages still showing as candidates next time Project/Solution is opened Introduce Setting to Force DBCC CHECKDB to run Multi Threaded when MAXDOP = 1 Project Creation Failed in SSMS 2008. Works in SSMS 2005. Profiler date format SQL Server 2008 SP1 CU6 Periodically Does Not Accept Connections Report Builder Models do not support Outer joins ( v2 and v3) Supported RDL Object Model (RDLOM) Rendering difference between SSRS 2005 and 2008 version for Print Layout (or PDF) When expressions are not trimmed. Normal view (HTML) renders as expected. Inconsistent handling of 0 length binary fields when converting to / from xml sp_rename fails to rename a column when CDC is DISABLED Change Default Database Location online Failure in SQL Server 2008 Management Studio Express installation Analysis Services 2008 ragged hierarchy in Reporting Services 2008 doesnt work FISERV TAP - Checking it RDL Source Sets Output Folder to Read Only SSIS: Rename Inputs on UNION ALL component Possible bug: Cube processing fails with high numbered unicode characters at the end [SSIS] View SSIS log provider output alongside profiler trace output Report Builder 3 Forms Auth Logon Obscured SQL Server 2005 OLE DB Provider Update Error (Linked Server) sp_estimate_data_compression_savings fails when table has index over timestamp column SQL Server Upgrade Advisor: Column aliases in ORDER BY clause cannot be prefixed by table alias xml type does not accept all Character Escape Sequences Invalid DEFAULT constraint causes an access violation Linked Server Aggregate Query - Multi-part identifier could not be bound The data refresh job failed because it has been inactive for more than 3600 seconds (unable to send notification email) Triggered Insert into Transactionally Replicated Table Fails to Distribute SQL Profiler reads free disk space incorrectly Why not doing SQL Merge Replication (checksum) validation against a snapshot of the article in tempdb, avoinding locks? invoke-sqlcmd -querytimeout 0 still times out SSMS : IntelliSense still has some gaping holes WPF/CSS skins for Reporting Services Toolbars Internal error: An unexpected exception occurred. Many to many relationship and user hierarchy that goes deeper than the granularity of the measure group SSMS open file with active connection OR prompt Connect to Database Engine? SSMS : Completely locked up after right-clicking a table Binary and Compressed XML transport is supported in Standard edition SSMS : Can no longer create or edit job steps Set default recovery model for databases to Simple Starting jobs in powershell using SMO requires CategoryID SSIS: Add Raw File Data Source To Import/Export Wizard Copy & Paste - SSIS components into a container -> broken layout SSMS : Change Connection dialog should offer registered servers SQL 2008 Developer failed install on Win 7 x64 (.NET Requirement Failed) Rebuilding system databases for SQL Server 2008 R2 SSMS Registered Servers Windows Exception Messagebox Implementing a Perfect Sphere SRID for astronomical coordinates on sky Modifying Stored Procedure in Object Explorer after search. Dependent Object Viewer Throws Exception. Indexes on expressions DBCC CHECKTABLE Should Support Checking Integrity for Individual Partitions The object explorer does not refresh SSMS does not add stored procedure parameter ManagementStudio->CopyDatabase->UseDetachAttach (no checkboxes) Visual Studio 2010 and BIDS not available. ReportingServicesService.EXE at 100% CPU utilization SQL server Management Studio - Change SA password and Disconnect will throw an exception SSMS: Modify should do so in place Cannot use DELETE key in SSMS and Object Explorer Wrong pagination in Report Manager List of Databases on SQL Server Manager SQL Server 2008 R2 Cumulative Updates wont install with DotNet Framework 4.0.30319 With SSRS 2008 R2, Microsoft.Reporting.WinForms.ServerReport.Render Method returns no stream identifiers for Image format. GUI table data insertion update tools are needed for this product DACPAC fn_sysdac_get_username() returns NULL value for NOT NULL created_by column on sysdac_instances_internal table Sql Server Management Studio 2008 - tables with specific names are not included sp_helpindex to show included columns Attempt to edit Named Query in DSV yields an Object reference not set to an instance of an object error Nice to Have: The ability to restore from database snapshot from Management studio Restore dialog. Can not use linked server between an on-premise SQL 2008 R2 and SQL Azure Not installed Power Shell reported oddly in Setup Still SQL Server 2008 entries found in the Start menu after installing SQL Server Denali CTP0 on a clean server (no update) SSMS : IntelliSense for DDL Triggers is incomplete Cant move database using Copy Database Wizard