Home Dashboard Directory Help
Search
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 406 Previous 123 Next

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 2 days ago) | 0 validations | 0 workarounds | 0 comments | 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 7 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 888121  | 
Active
33
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 2 days ago) | 9 validations | 0 workarounds | 3 comments | feedback id: 859047  | 
Active
21
0
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 7 weeks ago) | 0 validations | 0 workarounds | 1 comment | 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 11 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 856681  | 
Active
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 11 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 856675  | 
Active
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 5 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 852418  | 
Active
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 22 weeks 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 23 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 816418  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
If you attempt to use datepart(weekday) in a natively compiled stored procedure, there is an access violation and the connection is terminated.
Created on 2/2/2014 (updated 25 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 816417  | 
Active
Showing 1 - 10 of 406 Previous 123 Next