Activity overview
Latest activity by Joakim Mårlöv
>Are you positive that the server isn't really a SQL 2005 running a database in SQL Server 2000 (80) compatibility mode?
Yes sir 8) .
Unless one of my colleagues have done rogue installations secretely at night... performing dark rites... laying out pentagrams of TP cable, sacrificing Microsoft Mice and old Pentiums while invoking the archangel Linux etc...
No, I am positive, no SQL 2005 on any of our production servers yet, and they all show this symptom.
Joakim / comments
>Are you positive that the server isn't really a SQL 2005 running a database in SQL Server 2000 (80) compatibility mode?
Yes sir 8) .
Unless one of my colleagues have done rogue installations secr...
Thanks Brian,
and as you might have noticed in my reply to your answer regarding the bug - this is between two SQL server 2000 servers...
Joakim / comments
Thanks Brian,
and as you might have noticed in my reply to your answer regarding the bug - this is between two SQL server 2000 servers...
Joakim
Thanks Brian,
but it actually is a comparison between two SQL Server 2000 servers.
Joakim / comments
Thanks Brian,
but it actually is a comparison between two SQL Server 2000 servers.
Joakim
FEATURE REQUEST - pattern filter for objects
In our current project, we autogenerate literally thousands of stored procedures, and the generation is driven by end user behavior during runtime. This means that when we compare one database with...
FEATURE REQUEST - disable comp.of 'STATISTICS_NORECOMPUTE'
We've a lot of indexes where the STATISTICS_NORECOMPUTE flag differs between databases, and this difference is of no interest to us so it would be very beneficial to have the option to eliminate th...
BUG - 'STATISTICS_NORECOMPUTE' is not a recognized option
SQL Compare happily generates the following SQL (SQL server 2000) with wrong syntax:
ALTER TABLE [dbo].[TaskHeuristicRun] ADD CONSTRAINT [PK_TaskHeuristicRun] PRIMARY KEY CLUSTERED ([taskHeuristic...