Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by AaronBertrand for this product (signing in could show even more results)
Showing 1 - 10 of 386 Previous 123 Next

6
0
Sign in
to vote
From Connection: SQL Server
If your database has any encrypted objects, extracting a data-tier application using SSMS will fail. There doesn't seem to be any way of excluding specific schemas from modules like you can for tabl…
Created on 7/25/2016 (updated 8 weeks ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 2974229  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
In most cases when SQL Server prevents you from applying one setting because it conflicts with another, it also prevents applying those settings in the opposite order. This is not the case with INS…
Created on 5/31/2016 (updated 16 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2769923  | 
Resolved
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
If you create a temporal table in a system database (like I did today by accident), Object Explorer cannot expand the table. Trying to do so yields: >> Failed to retrieve data for this request. (…
Created on 4/4/2016 (updated 4 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2551649  | 
Resolved
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
When I create an index inline, I can create a unique index, a filtered index, or a unique filtered index, but my index can't have any include columns. Surely this is an oversight? -- works: CREATE TA…
Created on 12/1/2015 (updated 12 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2079552  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
Many of the early data leakage holes with DDM have been fixed, but one remains: when the user is a dbo in a different database. Consider a scenario where a SQL Server instance hosts an HR database and…
Created on 10/26/2015 (updated 8 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1948721  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
If I try to script something for an older version of SQL Server (say SQL Server 2008), which might require different syntax (such as CREATE SERVER ROLE and/or adding a member to a server role), I get …
Created on 10/5/2015 (updated 46 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1870405  | 
Closed
as Fixed Help for as Fixed
4
0
Sign in
to vote
From Connection: SQL Server
In SSMS CTP 2.2, if you connect to a SQL Server 2016 instance and try to add the objects required to support Database Diagrams, you get an error message: > Database cannot be null, the empty string, …
Created on 7/24/2015 (updated 44 weeks ago) | 2 validations | 0 workarounds | 5 comments | feedback id: 1586848  | 
Closed
as Fixed Help for as Fixed
48
0
Sign in
to vote
From Connection: SQL Server
If I try to create a login with a password that obviously doesn't meet the local password policy: CREATE LOGIN x WITH PASSWORD = N'y', CHECK_POLICY = ON; I get the error you would expect: Msg 15118…
Created on 4/15/2015 (updated 3 weeks ago) | 4 validations | 0 workarounds | 0 comments | feedback id: 1250342  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Consider the following script: CREATE TABLE dbo.x ( i INT IDENTITY(1,1) PRIMARY KEY, c1 BIT NOT NULL DEFAULT 1, c2 VARCHAR(MAX) ); GO CREATE NONCLUSTERED INDEX idx1 ON dbo.x(c1) INCLUDE (c2…
Created on 8/20/2014 (updated 96 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 951192  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The documentation for sys.dm_exec_query_profiles: http://msdn.microsoft.com/en-us/library/dn223301(v=sql.120).aspx Includes the column "lob_scan_count" - however my co-worker Brooke Philpott discove…
Created on 3/12/2014 (updated 101 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 832951  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 386 Previous 123 Next