Can SQL Server 2000/2005 Co-Exist On One Server?

Can I install SQL Server 2000 and SQL Server 2005 on the same physical server and be able to access them independently through their respective tools (E/M, Q/A, SSMS) and through ADO, OLEDB?

We have an upgrade issue that involves some parallel testing without buying a new server. Hey, i just work here right?

Yes this works just fine

Can SQL 2005 load assembly from GAC?

CREATE ASSEMBLy seems to be able to load assembly from physical path only.There are a bunch of assemblies that are loaded from GAC automatically by
SQL Server, but user defined assemblies are registered into the database
from a path or binary bits only.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"ffee" <ffee@.discussions.microsoft.com> wrote in message
news:6A027912-4859-42FA-BE57-D47AAD2F3D59@.microsoft.com...
> CREATE ASSEMBLy seems to be able to load assembly from physical path only.|||To add on to SriSamp's response, the assemblies are stored in the database
so that the database is portable. This allows the database to be restored
to a different server without assembly dependency issues.
Hope this helps.
Dan Guzman
SQL Server MVP
"ffee" <ffee@.discussions.microsoft.com> wrote in message
news:6A027912-4859-42FA-BE57-D47AAD2F3D59@.microsoft.com...
> CREATE ASSEMBLy seems to be able to load assembly from physical path only.

Can one rename the underlying physical file name of a SQL 2000 database?

Gurus,
Can one rename the underlying physical file name of a SQL 2000 database?
I.E., bring the database offline, rename the physical file MDF and LDF name,
then safely bring the database back online again?
SpinYou can detach, rename, then re-attach.
Do have a good backup just in case.
-oj
"Spin" <Spin@.spin.com> wrote in message
news:4go8juF1ok79lU1@.individual.net...
> Gurus,
> Can one rename the underlying physical file name of a SQL 2000 database?
> I.E., bring the database offline, rename the physical file MDF and LDF
> name, then safely bring the database back online again?
> --
> Spin
>

Can one rename the underlying physical file name of a SQL 2000 database?

Gurus,
Can one rename the underlying physical file name of a SQL 2000 database?
I.E., bring the database offline, rename the physical file MDF and LDF name,
then safely bring the database back online again?
--
SpinYou can detach, rename, then re-attach.
Do have a good backup just in case.
--
-oj
"Spin" <Spin@.spin.com> wrote in message
news:4go8juF1ok79lU1@.individual.net...
> Gurus,
> Can one rename the underlying physical file name of a SQL 2000 database?
> I.E., bring the database offline, rename the physical file MDF and LDF
> name, then safely bring the database back online again?
> --
> Spin
>