Comments
Sort by recent activity
Aaron,
Happy to help. Cool you guys found it. No, on the progress - I am hooking to an offsite database over a VPN. It use to take it a couple of seconds to process it. There's definitely no flash.
Nick / comments
Aaron,
Happy to help. Cool you guys found it. No, on the progress - I am hooking to an offsite database over a VPN. It use to take it a couple of seconds to process it. There's definitely no fl...
Aaron,
That fixed the not working part on startup. I still have no progress window.
Nick / comments
Aaron,
That fixed the not working part on startup. I still have no progress window.
Nick
Actually it looks like the automatic refresh AFTER I have manually done a refresh suggestions seems to work.
Really miss the pop up 'working' window. / comments
Actually it looks like the automatic refresh AFTER I have manually done a refresh suggestions seems to work.
Really miss the pop up 'working' window.
Thank God this was driving me nuts. / comments
Thank God this was driving me nuts.
Filed a support request - this problem really needs to get fixed. Been going on way too long.
A duplicate definition was found for the trigger [dbo].[trg_users_IDU]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact our support. / comments
Filed a support request - this problem really needs to get fixed. Been going on way too long.
A duplicate definition was found for the trigger [dbo].[trg_users_IDU]. Ensure that case sensitivity o...
It's adding two copies of the same trigger into the create code. One with the source table wrapped in [], one without. I am basically stuck and nothing I have read here lets me get by it.
BTW, I am using no migration scripts. / comments
It's adding two copies of the same trigger into the create code. One with the source table wrapped in [], one without. I am basically stuck and nothing I have read here lets me get by it.
BTW, I...
I've crashed four times today (sql search sent the log) - I wonder if this is related. Worst it's been - had just happened once a day or so.
The funny thing is that I haven't used it all today, so it's gotta be a background task tanking.
I LOVE sql search but for some reason this latest patch is unstable on my
system.
I work with a lot of systems over a VPN that isn't the best in the world. I would really like it to NEVER index them unless I ask it too.
Even better - an option to simply make indexing manual. I don't use it that often (but boy am I glad I have it when I need it) I would be fine with waiting for an indexing to get done before I search. / comments
I've crashed four times today (sql search sent the log) - I wonder if this is related. Worst it's been - had just happened once a day or so.
The funny thing is that I haven't used it all today, so...
Ok it is VERY likely a CTE problem. I can open and close one stored procedure with three CTE's in it and make the lag come and go. / comments
Ok it is VERY likely a CTE problem. I can open and close one stored procedure with three CTE's in it and make the lag come and go.
I concur - I am seeing massive lag/slowdown in my query windows. If I drop out of SQL Prompt AND Visual Studio and go back in, it goes away for a while but something is seriously wrong. I'm sitting here right now watching the processes in the task manager - as soon as I give the query window focus, SMSS jumps to the top sucking up 100% of one of my cores.
As other people have stated, it makes it unusable. I would also agree that it seems to be the worst when a complicated script is loaded - I am looking at one now with CTE's in it.
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.1.7600 / comments
I concur - I am seeing massive lag/slowdown in my query windows. If I drop out of SQL Prompt AND Visual Studio and go back in, it goes away for a while but something is seriously wrong. I'm sitt...