i use sql server 2005 express where i created several databases. When
opening Management Studio, i can see, besides my databases, also Master,
Model etc .. which manage the databases.
Now i also use MDF files which are disseminated on the same server.

I installed SQL Server 2005 a while ago and am liking it.  There are some
examples of new features in Books Online that use the AdventureWorks database
that I would like to try out.  Unfortunately I do not have the database on my
system.  Could someone please tell me where I can ...

What is the maximum amount of RAM supported by SQL Server 2000 on Windows
2003 standard edition server?
Regards
Ram

I have SQL2000 EE, Window server 2003, 8GB of memory, and PAE switch in the
boot.ini. Looking at task manager and perfmon(total server memory counter) it
looks like SQL Server is only using a little less than 2GB of memory. Some
things I have read seem to indicate that taskman ...

We just upgraded to SQL server 2000 sp3 from sp4 . Could the collation
change upgrading to SP4 (from SQL_Latin1_General_CP1_CS_AS to
SQL_Latin1_General_CP1_CI_AS.  Or can that only be changed on the
installation.

I'm a complete nub with SQL and have a question. I haven't been able to find
any resoures on this....We have an application that uses SQL 2000 on the
backend. I'm trying to setup an automated way to backup a database, then zip
that database up. The final step would be to set a ...

I read in another post that after installing the latest SP2 (downloaded on 27
March 07) i would see a version number: 9.00.3152.  Instead i see
9.00.3042...which was the original sp2.  
Is there truth to the idea that the version number of sp2a is different from

I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy
Database option from Management menu. I want to transfer all tables, and all
stored procedures. I've tried everything for the past 3 days, and it didn't
work. I always get the same error.

When creating table, now we usually include the colunm(Id) whose datatype is
uniqueidentifier.
My first question is why choosing datatype as uniqueidentifier instead of
int[identity(1,1)] if no replication needed.

Is the route tomigrate SQL 2005 standard to enterprise edition needs special
operaions? forexample desinstall/reinstall or just put he CD for
theenterprise editionand doan upgrade. Is ther a doc that explains the route
to follow, thanskin advance

We will be migrating our 2000 standard to 2005 standard in the near future. I
was under the impression that we could do this a variety of ways, but thought
we would go with the import/export, or backup and restore option. I've
searched quite a bit without coming up with any solid ...

Can the 32 bit SQL 2000 be installed on a 64 bit Server 2003? There
are certain reason pertaining to DTS jobs we run that make us
currently want to run the 32 bit version of SQL. We would like to make
the move to SQL 2005 64 bit in the future hence we would like to

I have installed Microsoft SQL Server 2000 along with Service Pack 3 on a
system with Microsoft Windows NT, Ver.4.0 (with Service Pack 6a).
Everything seems to work fine except that everything in the Enterprise
Manager application is displayed in an annoyingly tiny font and I do not

I'm a C++ programmer so my SQL knowledge is very limited.
I have installed a MS SQL 2000 SP4 Server on a Windows XP SP2. I have
created a database with a number of tables and filled them with data.
I have accessed the database using C++ from my local computer.

I have a new laptop and am trying to install sql2k on it but it installs
only tools and server and tools greyed out.
How to force it to install server on the laptop?