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

1
0
Sign in
to vote
From Connection: SQL Server
If you look at the syntax graph at https://msdn.microsoft.com/en-us/library/dn765133.aspx there are only options to add, drop or alter policies, but there is no indication how to change the state of t…
Created on 4/17/2016 (updated 5 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2601762  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
This may or may not be the same underlying problem as in https://connect.microsoft.com/SQLServer/feedback/details/2511115, but I am reporting this separately. When running the SMO method in Copy …
Created on 3/24/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2511148  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
You have a database which includes a user created WITHOUT LOGIN (I have not tested this with a user connected to a login.) The user has been granted permission to a table. You use Tasks->Generate Scri…
Created on 3/24/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2511115  | 
Active
6
0
Sign in
to vote
From Connection: SQL Server
The attached screen shot features the query plan for the same query from SSMS 2016 on top and SSMS 2012 below. The arrows in the plan from SSMS 2016 are longer, which means that I less information at …
Created on 3/23/2016 (updated 8 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 2507503  | 
Resolved
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
If you try to enable replication on a database with a surrogate-aware collation, this fails, because sp_replicationdboption attempts to create a table or other object which uses a deprecated data type…
Created on 3/23/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2507412  | 
Active
4
0
Sign in
to vote
From Connection: SQL Server
The words MOD and RAISEERROR (note two E, the real McCoy has only one) lights up with the colour for built-in functions in SSMS, but there are no such functions in T-SQL. On the other hand, try_ca…
Created on 3/18/2016 (updated 9 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 2487690  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The topic https://msdn.microsoft.com/en-us/library/cc627401.aspx says list these values: 0 The object is not signed. 1 The object is signed. NULL The object is not valid. However, I have…
Created on 3/6/2016 (updated 11 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2442327  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
A float value may have the value -0E0. abs on this value should return 0E0, but this does not happen when you use abs in a natively compiled stored procedure.
Created on 2/27/2016 (updated 11 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 2413424  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
It appears that when you use BREAK in a natively compiled function, this is not honoured, as the function spins forever. When I try to use BREAK in a natively compiled procedure, I am told GOTO is not…
Created on 2/27/2016 (updated 13 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2413368  | 
Resolved
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
Credit goes to Pradip Tripathy for finding this issue. You encrypt a LOB column in SSMS using the wizard. For instance, the column Employee.Notes in Northwind Later your reconnect. On the Options …
Created on 2/27/2016 (updated 13 weeks ago) | 0 validations | 1 workaround | 0 comments | feedback id: 2413024  | 
Active
Showing 1 - 10 of 441 Previous 123 Next