Please, could you provide the full version (2000,2005,2008,2008 R2,2012) and edition ( Express,Web,Standard,Entreprise,...) of your SQL Server ? These informations could be useful as every new version is bringing new features.Moreover, some features ...

An important question : what are the editions of your both operating system ( Windows Server or Windows Vista, 7, 8 ) ? If one of the computer is a Home edition , you must use the SQL Server authentification. If the computers are belonging to a Workgrou...

The most precise information about the 10 GB maximum size for SQL Server Express 2008 R2 and later can be found here : http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx I thi...

The 10 GB limit for the data is applying for the .mdf and .ndf files , but i recognize that the people using the Express Editions are creating .ndf files very rarely ( as usually the Express databases are rarely spanned on several disks to simulate part...

Have you looked at problems of structures of tables which were good for SQL Server 2000 and depreciated ( or even recommanded to be replaced ) for SQL Server 2008 R2? The same problems can appear for stored procedures which are optimized for SQL Server ...

What was the edition of your SQL Server 2005 ( and 2008 )? If Express Edition, the presence of SQL Server Management Edition Express is enough to break the install of any latter edition of SQL Server ( 2008, 2008 R2...).In theory, the install should be...

What was the edition of your SQL Server 2005 ( and 2008 )? If Express Edition, the presence of SQL Server Management Edition Express is enough to break the install of any latter edition of SQL Server ( 2008, 2008 R2...).In theory, the install should be bl...