Comments
Sort by recent activity
Hi,
bad formatting (FOR XML PATH): SELECT @MissingProducts = STUFF(
(SELECT N', '
+ CAST(Id AS VARCHAR(30))
FROM @ProductsWithPrices p
WHERE NOT EXISTS ( SELECT
*
FROM
dbo.Product pp
WHERE
pp.Article = p.Id )
FOR XML PATH('') ,
TYPE).value('text()[1]',
'nvarchar(max)'), 1,
2, N'');
/ comments
Hi,
bad formatting (FOR XML PATH):SELECT @MissingProducts = STUFF(
(SELECT N', '
+ CAST(Id AS VARCHAR(30))
...
It's a bit different. In the uservoice it is stated "after the rest of my code is formatted". In this case UNION ALL section is wrongly formatted. It might be related. / comments
It's a bit different. In the uservoice it is stated "after the rest of my code is formatted". In this case UNION ALL section is wrongly formatted. It might be related.
There is no point to email. It is the same line repeated a lot of times:
2015-07-22 07:46 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 06:33 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 05:51 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 05:25 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
Do not look to time. Mainly it differs milliseconds and in my case it generates about 30 records in 1 second.
And the query causing that (most probably) is:
SELECT
SCHEMA_NAME(s.schema_id) AS [Schema],
s.name AS [Name],
s.object_id AS [ID],
N'' AS [BaseDatabase],
N'' AS [BaseObject],
N'' AS [BaseSchema],
N'' AS [BaseServer],
CASE OBJECTPROPERTYEX(s.object_id,'BaseType')
WHEN N'U' THEN 1
WHEN N'V' THEN 2
WHEN N'P' THEN 3
WHEN N'FN' THEN 4
WHEN N'TF' THEN 5
WHEN N'IF' THEN 6
WHEN N'X' THEN 7
WHEN N'RF' THEN 8
WHEN N'PC' THEN 9
WHEN N'FS' THEN 10
WHEN N'FT' THEN 11
WHEN N'AF' THEN 12 ELSE 0 END
AS [BaseType],
s.base_object_name AS [BaseObjectName]
FROM
sys.synonyms AS s
ORDER BY
[Schema] ASC,[Name] ASC
so, everytime I am using synonym intellisense generates a lot of errors. I am not talking about the situation when I am trying to access object I do not have access to, it is just scanning all synonyms and for some of them I do not have permissions. / comments
There is no point to email. It is the same line repeated a lot of times:
2015-07-22 07:46 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name prov...
Hi,
if "Load suggestions for synonyms/Load referenced databases" are enabled and user does not have permissions for some underlied objects then it is flooding error messages to the log for every synonym that user does not have permissions for. / comments
Hi,
if "Load suggestions for synonyms/Load referenced databases" are enabled and user does not have permissions for some underlied objects then it is flooding error messages to the log for every sy...
Tab coloring is not working on SSDT. Is it a bug or VS does not support such features? / comments
Tab coloring is not working on SSDT. Is it a bug or VS does not support such features?
Hi Aaron. Semicolon before SEND is exactly what I meant.
Aaron Law wrote:
Hi sdks,
I think this is the behavior we'd expect to see here. We don't place semicolons after the BEGIN keyword as semicolons are meant for terminating statements so we felt it was a bit strange to terminate a BEGIN…END block at the BEGIN. This is also the style Microsoft use in their examples e.g the example here.
While SEND ON CONVERSATION does require the previous statement to be terminated with a semicolon (which we would insert for you) I don't think it requires one after the BEGIN?
Thanks,
Aaron.
/ comments
Hi Aaron. Semicolon before SEND is exactly what I meant.
Aaron Law wrote:
Hi sdks,
I think this is the behavior we'd expect to see here. We don't place semicolons after the BEGIN keyword as semic...
another bug. Automatic semicolon insert does not insert it before SEND ON CONVERSATION. Example: IF ( 1 = 1 )
BEGIN
SEND ON CONVERSATION @conversation_handle MESSAGE TYPE @ResultMessageTypeName ('test');
END;
Expected result:
IF ( 1 = 1 )
BEGIN;
SEND ON CONVERSATION @conversation_handle MESSAGE TYPE @ResultMessageTypeName ('test');
END;
/ comments
another bug. Automatic semicolon insert does not insert it before SEND ON CONVERSATION. Example:IF ( 1 = 1 )
BEGIN
SEND ON CONVERSATION @conversation_han...
Small bug in formatting:
Open multistatement query that does not fit to 1 screen. Go to the top query and select it from the bottom to the top. Press format query. The selected query jumps to the top of the screen. I think that the query is supposed to stay on the same window position. / comments
Small bug in formatting:
Open multistatement query that does not fit to 1 screen. Go to the top query and select it from the bottom to the top. Press format query. The selected query jumps to the t...