![]() (u.type in ('U', 'S', 'G', 'C', 'K' ,'E', I killl that session, my original query in the other window starts running right away. LEFT OUTER JOIN sys.certificates AS cert ON cert.sid = u.sid LEFT OUTER JOIN sys.database_permissions AS dp ON dp.grantee_principal_id = u.principal_id and dp.type = OUTER JOIN sys.asymmetric_keys AS ak ON ak.sid = u.sid WHEN N'S' = u.type AND SUSER_SNAME(u.sid) is null AND u.authentication_type != 2 THEN 3 Intel(R) Core(TM) i7-6820HQ CPU 2.70GHz (8 x 2700)ĬAST(CASE WHEN u.principal_id < 5 OR u.principal_id = 16382 OR u.principal_id = 16383 THEN 1 ELSE 0 END AS bit) AS ,ĬASE WHEN N'U' = u.type THEN 0 WHEN N'G' = u.type THEN 1 WHEN N'S' = u.type THEN 2 WHEN N'C' = u.type THEN 3 WHEN N'K' = u.type THEN 4 WHEN N'E' = u.type THEN 5 WHEN N'X' = u.type THEN 6 END AS ,ĬAST(CASE dp.state WHEN N'G' THEN 1 WHEN 'W' THEN 1 ELSE 0 END AS bit) AS , OS version: Darwin 圆4 18.7.0 System Info Item I have to quit Azure Data Studio, reconnect to the SQL Server and then run the query and it works.Īzure Data Studio version: Azure Data Studio 1.11.0 ( 460c739, T17:14:33.682Z) Sometime when running queries it just sits there saying executing query and doesn't finish. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |