Search
SQL Server Home
DownloadsFeedbackSurveys
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 391 Previous 123 Next

1
0
Sign in
 to vote
Error in dm_sql_referenced_entities is not caught in SQL 2012 (regression) - by Erland Sommarskog
From Connection: SQL Server
The response to the bug report https://connect.microsoft.com/SQLServer/feedback/details/331830/dropping-column-causes-dm-sql-referenced-entities-to-error suggests workaround based on TRY-CATCH. This …
Created on 5/5/2013 (updated 2 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 786389  | 
Active
2
0
Sign in
 to vote
Syntax graph for DECLARE @local_variable is messed up - by Erland Sommarskog
From Connection: SQL Server
As pointed out in http://social.Msdn.microsoft.com/Forums/en-US/transactsql/thread/17883138-143d-435e-ac21-ada414891429#17883138-143d-435e-ac21-ada414891429 the syntax graph for DECLARE @local_variab…
Created on 4/27/2013 (updated 3 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 785720  | 
Closed
3
0
Sign in
 to vote
Access violation with synonym in CTE - by Erland Sommarskog
From Connection: SQL Server
This scenario is taken from http://social.Msdn.microsoft.com/Forums/en-US/transactsql/thread/ed99d33e-ad46-4bee-8173-ee7f62ed6840#ed99d33e-ad46-4bee-8173-ee7f62ed6840 You have a view, which in a CTE …
Created on 4/24/2013 (updated 1 week ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 785518  | 
Active
1
0
Sign in
 to vote
CATCH handler causes "severe error occurred" in SqlClient when error comes from CLR PROCEDURE with ExecuteAndSend - by Erland Sommarskog
From Connection: SQL Server
You have a CLR procedure that uses ExecuteAndSend to execute a batch. You call this CLR procedure from a T-SQL procedure. The call to the CLR procedure is in with TRY-CATCH in T-SQL. The batch you c…
Created on 3/15/2013 (updated 4 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 781468  | 
Closed
2
0
Sign in
 to vote
Dependency is not recorded for stored procedure called from INSERT @tv EXEC() - by Erland Sommarskog
From Connection: SQL Server
If you have "INSERT @tablevar EXEC sp_name", the dependency is not recorded in sys.sql_dependencies. (It is recorded in sys.sql_expression_dependencies.) Furthermore, if the stored procedure does not …
Created on 3/15/2013 (updated 4 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 781461  | 
Resolved
as Won't Fix Help for as Won't Fix
1
0
Sign in
 to vote
Unfortunate text in the topic on table variables - by Erland Sommarskog
From Connection: SQL Server
http://msdn.microsoft.com/en-us/library/ms175010%28v=sql.110%29.aspx it says under "Best practices": Do not use table variables to store large amounts of data (more than 100 rows). Plan choices may n…
Created on 3/15/2013 (updated 9 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 781455  | 
Active
2
1
Sign in
 to vote
Topics for selective XML indexes fail to refer to sp_db_selective_xml_index - by Erland Sommarskog
From Connection: SQL Server
In order to be able to create selective XML indexes, you need to enable your database with sp_db_selective_xml_index. The stored procedure as such is documented in Books Online, but the main topics fo…
Created on 2/11/2013 (updated 4 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 778997  | 
Closed
1
0
Sign in
 to vote
Errors that abort batch but not transactions cannot be caught when the CLR is on the call stack - by Erland Sommarskog
From Connection: SQL Server
You have some T-SQL code that calls a CLR stored procedure which in its turn invokes some T-SQL code. This T-SQL causes an error that aborts the batch, without rolling back the transaction (if there i…
Created on 2/10/2013 (updated 4 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 778911  | 
Active
2
0
Sign in
 to vote
Inaccurate information about deprecation of NOLOCK and READUNCOMMITTED with UPDATE and DELETE - by Erland Sommarskog
From Connection: SQL Server
The topic of Deprecated Database Engine Features says "Specifying NOLOCK or READUNCOMMITTED in the FROM clause of an UPDATE or DELETE statement." The topic of Table Hints says about these two hints: …
Created on 2/9/2013 (updated 14 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 778878  | 
Resolved
as Won't Fix Help for as Won't Fix
2
0
Sign in
 to vote
Incorrect syntax in examples for selective XML indexes - by Erland Sommarskog
From Connection: SQL Server
In the topic for CREATE SELECTIVE XML index and related topic there are syntax errors in the FOR clause in the examples (comma missing on two lines).
Created on 2/8/2013 (updated 8 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 778831  | 
Resolved
as Fixed Help for as Fixed
Showing 1 - 10 of 391 Previous 123 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement