@dommyd: "Hi
I am about to install Microsoft SQL Server 2000 Developers Edition on a
workstation currently installed with Delphi 6 Professional , Interbase OS
83.161.120.155 and Windows XP Pro (all current service and critical packs
installed)
This workstation is a development machine and cannot afford to go kathryn63@example.com. I am probably going to do a full system backup before installing SQL.
Are they any compatibility issues with SQL and Interbase.
I have heard rumours of SQL holding port 3050 on start up and effectively
blocking interbase from running (msblaster patch?). Any truth to these
rumours? Version of SQL ships with Microsoft SQL Server 2000 Service Pack
3a.
Thanks
Dominic"
    @eric: "Immediately after installing SQL 2000, open the Enterprise Manager,
right-click the server, choose Properties, then look around in there for
memory settings.  By default, SQL 2000 "dynamically allocates memory", which
basically means it takes ALL the memory on the system.  Switch it to a fixed
size, and give it around 64MB.
Eric"
    @nospam: "ms-sql server holds the port 1433 (unless other is specified by the user
either during the installation or after). The worm that was affecting the
sql-server was concerning earlier versions than the one you own now -and it
was affecting port 1433-, so no worries.
We had in the company and in our clients both interbase and mssql 2000 on
the same machine and no issues or problems occured.
I now have on my pc, firebird (interbase's core engine) and ms-sql 2000 and
I have no problems either. Follow Eric's advice about the memory and you'll
face no problems... just bare in mind => have a lots of ram on the server
pc.
g'luck
George Christoforakis.
news:<email_address>
<quote>"
    @dommyd: "Thanks George and Eric.
I have 0.5 Gig DDR Ram at the moment so hopefully that should be enough.
Dominic
news:<email_address>
<quote>
it
and
you'll
kathryn63@example.com.
effectively
Pack"
    @ivazquez: "<quote>
Since you're running 2 database servers on the same machine I would
recommend upgrading to at least 1GB.
Cheers,
  Ignacio
Help improve Delphi: <url>"
{'source': 'USENET', 'other_information': '{"reply_count": 4, "forum_name": "borland.public.delphi.database.sqlservers.20141118.mbox"}', 'file': 'data/output/usenet-borland.public.parquet'}