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

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 day ago) | 0 validations | 0 workarounds | 0 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 1 day ago) | 0 validations | 0 workarounds | 0 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 4 days ago) | 0 validations | 0 workarounds | 2 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 8 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 8 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 10 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 816417  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Consider the batch in the repro. In the repro there is an AFTER INSERT and an INSTEAD OF UPDATE trigger on the same table. The AFTER TRIGGER performs an UPDATE on the base table. This does not fire th…
Created on 12/23/2013 (updated 14 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 812240  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The topic of SQL Server Collations, http://technet.microsoft.com/en-us/library/ms180175.aspx, lists a number of collations that are said to be SQL Server Collations. The lists includes also a number o…
Created on 12/11/2013 (updated 17 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 811340  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I installed the 32-bit version of SQL 2014 CTP2 on a machine that already had a default instance with 64-bit SQL 2014 CTP2. When I ran the Setup Wizard, I think I noted that the FILESTREAM options wer…
Created on 10/29/2013 (updated 23 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 806934  | 
Resolved
as By Design Help for as By Design
1
0
Sign in
to vote
From Connection: SQL Server
In the topic for CREATE DATABASE it says under "WITH <option>": "The following options are allowable only when CONTAINMENT has been set to PARTIAL. If CONTAINMENT is set to NONE, errors will occur." …
Created on 7/23/2013 (updated 38 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 794801  | 
Active
Showing 1 - 10 of 402 Previous 123 Next