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 412 Previous 123 Next

1
0
Sign in
to vote
From Connection: SQL Server
I prefer to set the default database for my admin user to tempdb to avoid littering master by mistake. However, this makes Watch Live Data difficult to use. For instance, I select the system_heath_ses…
Created on 4/3/2015 (updated 3 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1222582  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
The attachment has the full definition for the tables as well as data to demonstrate the issues. We have three queries. First A1 and A2, where A1 is this query with the hint commented and A2 has the …
Created on 2/21/2015 (updated 8 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 1141527  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
The functions suser_name, suser_sname, suser_sid, user_id, database_principal_id, is_rolemember and is_srvrolemember all permits an unprivilged user to retrieve information he is not supposed to have …
Created on 1/17/2015 (updated 9 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 1090900  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I wanted to create an endpoint for Service Broker programmatically, and if the chosen port was in use, I wanted to try the next one and so own. I wrote some standard error-handling code with TRY-CATCH…
Created on 12/11/2014 (updated 14 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1052540  | 
Closed
as By Design Help for as By Design
1
0
Sign in
to vote
From Connection: SQL Server
The topic for CASE and COALESCE says about simple CASE expression: "Evaluates input_expression, and then in the order specified, evaluates input_expression = when_expression for each WHEN clause." …
Created on 11/28/2014 (updated 21 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1042044  | 
Active
4
0
Sign in
to vote
From Connection: SQL Server
This concerns a query that is business-critical in our application. We have a table with transactions, and then there is a temp table with new transactions. A transaction is identified by position key…
Created on 9/20/2014 (updated 12 weeks ago) | 2 validations | 0 workarounds | 1 comment | feedback id: 977383  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
In the topic http://msdn.microsoft.com/en-us/library/ms187654.aspx#SSMSProcedure, the header "To copy data from one table to another" has these two steps: 2. In Object Explorer, right-click the Views…
Created on 7/29/2014 (updated 37 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 932275  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The topic for ALTER ROLE says: "Requires ALTER ANY ROLE permission on the database, or ALTER permission on the role, or membership in the db_securityadmin." However, what I can find, you need to be me…
Created on 6/3/2014 (updated 45 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 888121  | 
Active
35
0
Sign in
to vote
From Connection: SQL Server
In the downloadable version of BOL 2014 that was made available the other day, the T-SQL and XQuery References are missing. (There may be more things missing, but a BOL without the T-SQL Reference is …
Created on 4/22/2014 (updated 25 weeks ago) | 11 validations | 0 workarounds | 6 comments | feedback id: 859047  | 
Closed
as Fixed Help for as Fixed
23
1
Sign in
to vote
From Connection: SQL Server
It seems that there is a change in SSMS 2014. Rather than displaying the raw line number reported from SQL Server, SSMS appears to add the offset of the line in the query window. This may be helpful i…
Created on 4/20/2014 (updated 4 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 857794  | 
Active
Showing 1 - 10 of 412 Previous 123 Next