Revoking the permission, VIEW ANY DATABASE, from the Public server role causes SSMS to show only tempdb and master, even if a login has access to one or more databases.
For what it is worth, the quer…
Created on 12/14/2012 (updated 19 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 774373
|
|
The FileTables page found here: http://msdn.microsoft.com/en-us/library/ff929144.aspx references a file_id (GUID) as the unique identifier for each file. This is not true - it is called "stream_id."
…
Created on 12/6/2012 (updated 17 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 773704
|
|
|
Closed
as Fixed
|
|
The BOL page for SQL 2012 - "Back Up the Service Master Key" has incorrect example code.
http://msdn.microsoft.com/en-us/library/aa337561(v=sql.110).aspx
The example code backs up a database master …
Created on 10/5/2012 (updated 31 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 766349
|
|
|
Closed
as Fixed
|
|
The BOL page for "Generating Dump Files for Package Execution" has incorrect data in it for SSIS 2012.
http://msdn.microsoft.com/en-us/library/hh231095.aspx
In the "Debug Dump File Format" section…
Created on 7/25/2012 (updated 41 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 755470
|
|
|
Closed
as Fixed
|
|
The SSIS Server Maintenance Job calls two procedures, one of them being internal.cleanup_server_retention_window. This procedure deletes from internal.operations, and the resulting cascade deletes cl…
Created on 7/18/2012 (updated 17 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 754384
|
|
|
Closed
as Fixed
|
|
On a large SSISDB catalog (over 30GB for data file size, over 12GB for operation logs), when the SSIS Server Maintenance job runs, any concurrent SSIS packages running will be blocked from writing the…
Created on 7/16/2012 (updated 8 weeks ago) | 4 validations | 1 workaround | 6 comments | feedback id: 753934
|
|
When viewing the SQL Server Logs in SSMS for non-SQL 2012 instances, the order is shown oldest first, while viewing SQL 2012 instances shows newest first.
The behavior for SSMS in the past has always…
Created on 3/7/2012 (updated 24 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 729543
|
|
|
Closed
as Duplicate
|
|
Trying to import an Excel 2010 file into the DQS client does not work.
Created on 3/3/2012 (updated 53 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 728377
|
|
|
Closed
as Won't Fix
|
|
Trying to replace a term-based relationship value with an empty string, the "Apply Changes" button is not enabled. However, changing to a different tab will allow me to save the changes, as will clic…
Created on 3/2/2012 (updated 53 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 728334
|
|
|
Closed
as Won't Fix
|
|
Working with the US - State domain shipped with SQL Server, if I change "Md." to a type of "Correct," the "Correct to" value gets removed, and I am unable to edit that column. The only way to edit th…
Created on 3/1/2012 (updated 57 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 727762
|
|
|
Closed
as By Design
|
|