Activity overview
Latest activity by Mr.DiGi
Awesome, thanks for fixes.
OT: Is there any way to log/debug Qualify object names call? It just hang for our db (almost since beginning).
No error in "....\AppData\Local\Red Gate\SQL Prompt 6\sqlpromptlog-yyyymmdd-hhmmss.log" / comments
Awesome, thanks for fixes.
OT: Is there any way to log/debug Qualify object names call? It just hang for our db (almost since beginning).
No error in "....\AppData\Local\Red Gate\SQL Prompt 6\sqlpr...
More (minor) bugs - User defined table type related:
- Select in Object Explorer is not working for table type
- column names from table type are not listed (maybe this didn't work with previous version too)
- we have custom table type with "Value INT" column. After using column "Value" in join all database object/names disappears from SQL Prompt (only snippets are listed).
demo: CREATE TYPE [dbo].[IntTable] AS TABLE
(
[ID] [int] IDENTITY(1,1) NOT NULL,
[Value] [int] NULL
)
GO
DECLARE
@x dbo.IntTable
SELECT
1
FROM
@x AS X
INNER JOIN sys.objects AS O ON O.object_id = X.Value
INNER JOIN <no hint here>
Just changing "O.object_id = X.Value" to (invalid) "O.object_id = X.ValueZZZ" brings SQL Prompt back.
Edit: Or we can use O.object_id = X.[Value] - maybe because XML type .value, .nodes hacks? / comments
More (minor) bugs - User defined table type related:
- Select in Object Explorer is not working for table type
- column names from table type are not listed (maybe this didn't work with previous ve...
No problem, thanks for quick fix. / comments
No problem, thanks for quick fix.
Microsoft SQL Server Management Studio 11.0.3401.0
SQL Prompt Pro 6.3.0.102
SQL Search 1.1.9.57
SSMS Tools Pack 2.7.2.0
Instant crash after typing number after GO. In SSMS you can specify how many times should SSMS repeat statement. PRINT 'You will see this message 10 times'
GO 10
This works fine with SQL Prompt 6.2.
Edit: Yay, just paste example in SSMS and... / comments
Microsoft SQL Server Management Studio 11.0.3401.0
SQL Prompt Pro 6.3.0.102
SQL Search 1.1.9.57
SSMS Tools Pack 2.7.2.0
Instant crash after typing number after GO. In SSMS you can specify how many ...