I tried to drop a user's membership in a database role using the "Database User" properties dialog box in SSMS, SQL Server Management Studio, SQL Server 2008 R2. I unchecked the role from which I wan…
Created on 6/29/2012 (updated 4 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 751786
|
|
|
Resolved
as Won't Fix
|
|
I connected to a SQL Server instance where I was NOT sysadmin, and I was NOT dbo in the database. I right-clicked the database node in Object Explorer and chose Properites.
***In SSMS 2012 against…
Created on 5/3/2012 (updated 32 weeks ago) | 0 validations | 1 workaround | 2 comments | feedback id: 740442
|
|
|
Closed
as Fixed
|
|
I am interested in the "Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2"
There is a download for "X86 Package(SSBEAS.msi)" on the "Microsoft® SQL Server® 2008 R2 Feat…
Created on 3/21/2012 (updated 59 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 732492
|
|
We accidentally provided a misspelled service name to a BEGIN DIALOG statement located in a BEGIN TRY block. Msg 208, Level 16,... was raised. Execution of the stored procedure did not resume in the…
Created on 3/9/2012 (updated 65 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 730128
|
|
|
Closed
as By Design
|
|
SQL 2012 Database Diagram Not Printing Correctly
When printing ddatabase diagrams, several of the tables contain large grey squares instead of the column names and types. This occurs printing to sev…
Created on 1/12/2012 (updated 18 weeks ago) | 2 validations | 1 workaround | 4 comments | feedback id: 718327
|
|
|
Closed
as Won't Fix
|
|
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/298eafca-e01f-4707-8c29-c75546fcd6b0.htm
I looked at this topic when I was wondering how triggers fire when there is a MERGE statement. …
Created on 12/9/2011 (updated 21 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 712889
|
|
|
Closed
as Fixed
|
|
I wrote a query against a SQL Server 2008 SP1 instance. It is a query with a CTE (common table expression), and the CTE query has a “ROW_NUMBER () OVER (PARTITION BY... ORDER BY...) expression in the…
Created on 10/14/2011 (updated 86 weeks ago) | 0 validations | 0 workarounds | 9 comments | feedback id: 694948
|
|
|
Closed
as By Design
|
|
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/eb737149-7c92-4552-946b-91085d8b1b01.htm
This topic does not identify that the HASHED & MUST_CHANGE options are mutually exclusive.
Msg 3…
Created on 9/14/2011 (updated 48 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 688403
|
|
|
Closed
as Not Reproducible
|
|
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/fafc0dba-f8a8-4aad-9b7f-908e34b74d88.htm
In the Arguments section for the COALESCE topic, there is this information:
expression
Is a…
Created on 8/18/2011 (updated 69 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 684714
|
|
|
Closed
as Won't Fix
|
|
In the BOL description for the distribution.dbo.MSarticles system table for replication, the column descriptions for source_owner and destination_owner are obsolete. I created multiple schemas all …
Created on 7/22/2011 (updated 80 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 680456
|
|
|
Closed
as Fixed
|
|