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 Greg Low - Australia for this product (signing in could show even more results)
Showing 1 - 10 of 54 Previous 123 Next

2
0
Sign in
to vote
From Connection: SQL Server
If a stored procedure uses the IIF function, the Native Compilation Advisor in SSMS complains they have used a CASE statement. This is confusing to users. The error should perhaps say "CASE or IIF".
Created on 8/12/2016 (updated 2 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3042394  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I have a stored procedure that removes the temporal nature of a table so that I can update the history directly. I cannot catalog a stored procedure that is intended for use only when the temporal na…
Created on 3/21/2016 (updated 23 weeks ago) | 0 validations | 1 workaround | 0 comments | feedback id: 2500716  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
In the code attached, you can see that THROW is flagged as incorrect. The syntax however is valid and works fine. Note: This was tested on RC1 not CTP3 but that option is not available in the dropd…
Created on 3/21/2016 (updated 23 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2500146  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When you use the option to drop a database in SSMS, and select the option to close existing connections, if you script the command instead of executing it, the closing of existing connections is not s…
Created on 3/15/2016 (updated 24 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 2476476  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
When SQL Server Management Studio is used to generate SQL scripts, and the option is chosen to script statistics and histograms, if a table with a filtered index is being scripted, a WHERE clause is a…
Created on 8/19/2015 (updated 44 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1689631  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
When the New Login dialog is used to create a new SQL Server Login in SSMS, if the new user is not a db_owner but is given access to a database in some other role, an error is returned.
Created on 7/14/2015 (updated 5 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 1547066  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
SQL Server Management Studio has an option to drop a database. That option includes a checkbox for disconnecting existing users before dropping. When scripting is chosen instead of execution, that opt…
Created on 7/6/2015 (updated 44 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1515182  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
When SQL Server Management Studio is used to create a script of a database snapshot, the resultant script contains invalid options.
Created on 7/6/2015 (updated 44 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1515168  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
When I run a query in SQL Server 2016 CTP2.1, and use a FOR JSON clause, and the SSMS output is to text, and the output is wider than the maximum line size, the data gets partially truncated, not just…
Created on 7/2/2015 (updated 52 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1497316  | 
Active
11
0
Sign in
to vote
From Connection: SQL Server
The current_value column in sys.sequences returns either the last obligated value or, for situations where the sequence hasn't been used, the next value to be obligated. But there is no way to determi…
Created on 6/22/2015 (updated 11 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 1461552  | 
Resolved
as Fixed Help for as Fixed
Showing 1 - 10 of 54 Previous 123 Next