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 Erland Sommarskog for this product (signing in could show even more results)
Showing 1 - 10 of 448 Previous 123 Next

2
0
Sign in
to vote
From Connection: SQL Server
You run a query with parallelism where all threads wait with EXECSYNC on one thread which performs all the work. If you look in sys.dm_os_waiting_tasks, you find that there is no official blocking_ses…
Created on 7/16/2016 (updated 6 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2938118  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
When attempting to print the Text or Messages tab in SSMS 2016 (the June release), this fails with "Value cannot be null. Parameter name moniker". This happens for more than one printer destination. M…
Created on 7/1/2016 (updated 7 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2882795  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
You connect in Object Explorer to an instance running SQL 2016 Express. You open the database node. You select a database with the intent to back it up. Right-click, Tasks - but there is no Backup opt…
Created on 6/29/2016 (updated 8 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2874434  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
There are some inaccuracies in the topic for DBCC CHECKIDENT. As for the table name, it says "names must comply with the rules for identifiers.", but what I have found is that this is accepted: 1) A …
Created on 6/28/2016 (updated 8 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2870424  | 
Active
4
0
Sign in
to vote
From Connection: SQL Server
Consider this scenario: 1) You have two tables with similar schema. 2) They both have an IDENTITY column. 3) They both have a clustered index where the IDENTITY column is not the leading column. …
Created on 6/24/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2852983  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I have these settings: * Results to text. * Disåpay status messages in a separate tab is *not* set. * Display results in a separate tab *is* set. * Switch to results tab after the query executes. …
Created on 6/17/2016 (updated 10 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2827973  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
If I attempt to export a table in SQL 2008 or earlier with BCP from SQL Server 2016, this fail with the error message: Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find sto…
Created on 6/2/2016 (updated 8 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2777154  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
If you look at the syntax graph at https://msdn.microsoft.com/en-us/library/dn765133.aspx there are only options to add, drop or alter policies, but there is no indication how to change the state of t…
Created on 4/17/2016 (updated 18 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2601762  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
This may or may not be the same underlying problem as in https://connect.microsoft.com/SQLServer/feedback/details/2511115, but I am reporting this separately. When running the SMO method in Copy …
Created on 3/24/2016 (updated 22 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2511148  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
You have a database which includes a user created WITHOUT LOGIN (I have not tested this with a user connected to a login.) The user has been granted permission to a table. You use Tasks->Generate Scri…
Created on 3/24/2016 (updated 22 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2511115  | 
Active
Showing 1 - 10 of 448 Previous 123 Next