Comments
Sort by recent activity
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.
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...
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.
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...