Re: 1 server 2 SQL apps

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Citizen (citizen_NOSPAM_at_hotmail.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 16:24:56 +0200

On Tue, 29 Jun 2004 17:25:54 +0530, "Hari" <hari_prasad_k@hotmail.com>
wrote:

>Hi,
>
>Does it make sense in this situation to use MSDE 2000 SP3, or will we
>regret this soon ?
>
>MSDE has a limitation of 2 GB per database as well as you will not get the
>clients lke query analyzer, Enterprise manager.
>
>Best option for you might be , Install a default installation of SQL server
>standard edition and create 2 databases.
>1 database each for application.

Thanks. I was thinking about 2 instances of MS SQL Server because of
security and more important avalability.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I need to restart the SQL service?
    ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL SERVER 2008 Express + SP1
    ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
    (microsoft.public.sqlserver.setup)
  • Re: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)