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

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 4 weeks ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 977383  | 
Active
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 10 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 19 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 888121  | 
Active
34
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 6 weeks ago) | 11 validations | 0 workarounds | 5 comments | feedback id: 859047  | 
Closed
as Fixed Help for as Fixed
21
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 5 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 857794  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The topics for BEGIN/SAVE/ROLLBACK TRANSACTION say that you can use transaction names and that they conform to the rules for identifiers. They also say that only the first 32 characters considered. Wh…
Created on 4/18/2014 (updated 1 week ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 856681  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
The topic for COMMIT TRANSACTION has this syntax diagram: COMMIT { TRAN | TRANSACTION } [ transaction_name | @tran_name_variable ] ] [ WITH ( DELAYED_DURABILITY = { OFF | ON } ) ] [ ; ] If you look …
Created on 4/18/2014 (updated 1 week ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 856675  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
The topic for SAVE TRANSACTION says: When part of a transaction is rolled back to a savepoint, resources continue to be held until the completion of the transaction or a rollback of the complete tran…
Created on 4/13/2014 (updated 1 week ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 852418  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
My copy of BOL 2008 says this in the permission section for ALTER USER: -------------------------------- To change the name of a user requires ALTER ANY USER on the database. To change the default sc…
Created on 2/15/2014 (updated 1 week ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 817554  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
When you create a natively compiled stored procedure you must specify the language; there is no default. This is somewhat irritating, because most of the time you don't care (and you should not care).…
Created on 2/2/2014 (updated 1 week ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 816418  | 
Closed
as Duplicate Help for as Duplicate
Showing 1 - 10 of 407 Previous 123 Next