Activity overview
Latest activity by JTShyman
Thanks for the explanation. I thought I was going crazy.
Looking forward to the GA release. / comments
Thanks for the explanation. I thought I was going crazy.
Looking forward to the GA release.
Reading Object Text
Lately, Ive started having a problem with SQL Prompt V3, latest Beta build, on SQL 2005 SSMS.
On almost every server I connect to now it takes 10-15 minutes for SQL Prompt to get past "Reading Obje...
I frequenty have to run a command against all of the databases on a given server so I created the following snippet "alldb" DECLARE @DB sysname DECLARE @... NVARCHAR(4000) SET @DB='' WHILE @DB IS NOT NULL BEGIN SELECT @DB=MIN(NAME) FROM master..sysdatabases WHERE NAME NOT IN ('master','model','tempdb','msdb','northwind','pubs')
AND NAME > @DB SELECT @SQL=N' ' + @DB + ' ' PRINT @... EXEC sp_executesql @... END
I then just edit the SELECT clause to do what I need it to. / comments
I frequenty have to run a command against all of the databases on a given server so I created the following snippet "alldb"DECLARE @DB sysnameDECLARE @... NVARCHAR(4000)SET @DB=''WHILE @DB IS NOT N...
Maybe a hot-key to turn off the automatic suggestions? Like ctrl-space will always bring up a list maybe another combination can turn it to "manual" instead of on a delay for when typing comments. / comments
Maybe a hot-key to turn off the automatic suggestions? Like ctrl-space will always bring up a list maybe another combination can turn it to "manual" instead of on a delay for when typing comments.
Bart,
You're right. Some of the "extended stored procedures" are really just code like system stored procedures, or call system stored procedures using T-SQL (see xp_execresultset) or, perhaps, system .dlls (like xp_fixeddrives)
I understand why it can't easily be done; thanks for the explanation. I appreciate your looking into it. / comments
Bart,
You're right. Some of the "extended stored procedures" are really just code like system stored procedures, or call system stored procedures using T-SQL (see xp_execresultset) or, perhaps, sys...
Adding Intelligence to Intellisense
First let me say that v3 is a VAST improvement over v2 in many ways. I love the metadata caching. I work over a VPN most of the time and waiting for v2 to load metadata each time I typed a USE stat...
Thanks, Bart!
The same issue does occur with SQL 2005 databases. / comments
Thanks, Bart!
The same issue does occur with SQL 2005 databases.
I'm using SQL 2000 databases and am using both SQL 2000 QA and SQL 2005 SSMS to access them. I haven't tried this on a SQL 2005 database. I can later today and will post the result. / comments
I'm using SQL 2000 databases and am using both SQL 2000 QA and SQL 2005 SSMS to access them. I haven't tried this on a SQL 2005 database. I can later today and will post the result.
Extended Stored Procedures
Am I missing a setting in SQLPrompt or does it not show extended stored procedures in the candidate list?
For example, in the MASTER database there is a procedure called xp_fixeddrives
typing:
EXEC...