New answers tagged

1

Is there a really good reason you do want to use a shared root directory? From my experience on SQL 2000 and 2005 it sometimes wasn't the best option. Having them separate would make it less likely that a change/patch in one might accidentally affect the other or edge cases where NTFS permissions/corruption or something aggravates another issue causing ...


1

On default.. SQLExpress will try to install to "Program Files/SQL Server Express" while the standard will try to install to "Program Files/SQL Server". Both version of programs have more than 80% common files that can be easily overwritten if you install them on the same folder. Your OCD will be replaced by a major headache when you realized that you ...


1

Why not make the Express root be C:\Program Files\Microsoft SQL Server\Express so that it's both separate, and in the same C:\Program Files\Microsoft SQL Server\ root as the rest?


0

It seems to me that you're falling into an XY Problem. You want to see the data from lots of different databases, and have the mindset that you should only connect to a single database. That line of thinking logically lead you to the conclusion that you need to bring all the information into one central database. IMO your real problem is needing to see the ...


-2

@Mihai, As Daniel Hutmacher already said,Express Edition is limited in database size. As per sqlmag BOL http://sqlmag.com/sql-server-2012/sql-server-2012-express-editions, if you are using SQL Server Express with Advanced Services. It is limited to 4GB and can access only the local instance. Even in dba.stackexchange the Shanky How many users are supported ...



Top 50 recent answers are included