Comments
Sort by recent activity
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...
So this will be part of the Developer Bundle. If we already own the Developer Bundle, will there be an upgrade cost to get this? / comments
So this will be part of the Developer Bundle. If we already own the Developer Bundle, will there be an upgrade cost to get this?
David Atkinson wrote:
If you have the SQL Toolbelt or the SQL Developer Bundle, and provided you took the support and ugprades option, you'll get SQL Source Control at no extra cost.
If you don't have support and upgrades, I believe that there is a way to 'upgrade' to this option. Or you could of course purchase it separately. Please email sales@red-gate.com for more details.
David
Excellent! / comments
David Atkinson wrote:
If you have the SQL Toolbelt or the SQL Developer Bundle, and provided you took the support and ugprades option, you'll get SQL Source Control at no extra cost.
If you don'...
David,
This blog is news to me. Thank you - that makes a huge difference. I had heard rumors they were going to basically eliminate VSS and make TFS more available but I had been unable to find direct references to this.
Apparently I failed to search very well.
As far as Subversion, after I posted that I went hunting and apparently there is a plugin for Delphi - so I guess I need to start looking at Subversion.
Thanks for the link - that answers a lot of questions. VSS certainly isn't a top notch product and it sounds like I might finally be able to dump it.
Regards,
Nick H / comments
David,
This blog is news to me. Thank you - that makes a huge difference. I had heard rumors they were going to basically eliminate VSS and make TFS more available but I had been unable to find d...
David,
Actually..wow..TFS 2010 doesn't support keyword expansion OR sharing. But then I'm reading on Subversion and getting the locking that VSS has seems to be a bit of hack.
It's never easy.
Nick / comments
David,
Actually..wow..TFS 2010 doesn't support keyword expansion OR sharing. But then I'm reading on Subversion and getting the locking that VSS has seems to be a bit of hack.
It's never easy.
Nick
OK guys I got a serious issue with disabling hardware acceleration on my Nvidia graphic cards to get SQL Prompt to work.
That's not an acceptable solution.
I'm running the latest drivers with 7000 & 8000 series cards. The pauses and delays are immediate. I'm talking clicking into the window and nothing happens for a few seconds.
And the delays are intermitent. I've noticed that it will work just fine and then suddenly in the middle of populating the drop down it will pause. I just opened up a database immediately after a reboot and the delay was present.
I find it highly unlike the issue is with my Nvida cards, especially when people are reporting the issue on laptops.
This is a serious problem and is approaching the 'uninstall sql prompt' and go back to SQL prompt 3 level...again.
Is there a reason why we have to email to get the workaround and is this different from the disable HW acceleration?
Best Regards,
Nick Hustak / comments
OK guys I got a serious issue with disabling hardware acceleration on my Nvidia graphic cards to get SQL Prompt to work.
That's not an acceptable solution.
I'm running the latest drivers with 7000 ...