Activity overview
Latest activity by shadowbob
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case difference. Perhaps SQL Prompt already ignores case? Maybe someone can confirm this. (You know it'd be super cool if the underscore could be removed during the comparison...) / comments
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case diffe...
[Feature Request] Case insensitive JOIN candidates
As the subject suggests, can we get an option to list JOIN candidates using case-insensitive comparison? I need the names to match (not just the data types), but sometimes the case differs a bit fr...
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've ever used: Windows XP, Windows Vista, Windows Server 2003, Windows Server 2008; in a variety of configurations, networks, and environments. I don't know what you mean by "size" of the database. The physical size ranges from 1-30 GB, while the schema could be considered "large" by some. / comments
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've eve...
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and see if anything doesn't work as expected.
I also experience the same frustration as jerryhung above regarding Toolbelt updates. The online Upgrade Center stopped working for me months ago, so I either have to email support (and wait a few days to hear back), or download a Toolbelt trial and get the contact from your sales department. That online Upgrade Center needs to get working again. / comments
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and se...
SQL Server 2008
Now that SQL Server 2008 has been released, can you give us a general idea of your timeline for releasing your products with official support for the release version of SQL Server 2008? I'll hold o...
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks! / comments
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks!
Prompt 3.9.1.104: no suggestions on TRUNCATE TABLE
After typing TRUNCATE TABLE, the Prompt suggestions don't include ANY tables. They do include variables, functions, data types, and keywords -- none of which can be truncated. Not so helpful.
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons? / comments
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons?
Compare between 2008 and 2005 servers?
This might be a dumb question. When SQL Server 2008 comes out, we'll find ourselves in a mixed environment, with some servers running 2008 and some running 2005. Assuming I don't use any 2008-speci...
Registering databases progress bar
I've been using Compare since version 5, and I've always noticed this behavior. The "Registering Databases" progress bar always goes up to 100% on the first database, then jumps down to 50% and hea...