The database scheme consists of four relations:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)

SQL Server 2000.
In SQL Enterprise Manager, the properties page for the server is
blank
for the operating system, language, platform, OS memory and

I am currently partitioning a table with an identity column as
PK/ClusteredIndex. As required, I am supposed to add the partitioning column
(another column, bigint) to the existing clustered index. I am not sure how
the column order on the clustered index makes a difference on ...

I can't seem to find the Microsoft page that compares all the different
editions of SQL 2000.  I have SQL 2000 Standard running on Windows 2000 (32
bit).  I need to migrate the SQL server to Windows 2003 Enterprise 64-bit .
Ideally I would like the SQL server to take advantage of ...

I want to watch a Invoice layout before saving and printing (like "Print
Preview" option). What is "best"?
-To save registers in regular tables and delete them if are not definitive,
or

I don't know how to rearrange my select but I want only the last
sighting per clm.  The clm should be grouped by the car_mark and
car_number.  Do I need to only have a select getting the
c.last_sighting and a group by c.car_mark and c.car_number?  If so

Assume that there are 2 jobs scheduled to run at midnight daily.
If the server is down when the scheduled time occurs, do the jobs
automatically run when the server is restarted?
From my tests this does not appear to be the case, but I would like

Can anyone tell me how to determine the most recent date a database was
accessed or written to?  I am using SQL Server 2005.  Thank you.

I have to move the SQL Server backend of a Sharepoint Portal Server to
another SQL Server. Both the servers are running SQL Server 2000 SP4. Can I
simply do a detach and attach of all the Sharepoint databases? I'll
appreciate if anyone can provide with some more information on ...

I am using Vista and in Microsoft Outlook when I use Contact Manager I
keep getting notices unable to complete action because SQL Server is
turned off.  Any advice to fix this please?  Seaker

Is there one?  I can't seem to find any "this must be included and made
visible at the time of installation if you automatically install the product"
license or licensing information.  Is one to conclude that after signing up
to be *able* to redistribute that I can just do so all ...

Hello all.  I’m having an issue with joining the contents of two
tables.  The join options available to me seem to have limitations
that are keeping me from retrieving all data from both tables.  I will
do my best to give the table details below, and try to give you an

When i am trying to run this SP i get Incorrect syntax near '1' error
from sql server 2005.
Here are the SP Values i pass.
exec aspnet_Membership_CreateUser

We are installing a new version of our trading application that uses SQL 2005
instead of Sybase which it currently uses. I'm using books and will try
e-learning, but the guy that is goto for the system does not like those
learning tools.  Has anyone taken a SQL 2005 ...

I am new to SQL.
I currently run a server with SBS 2003, MSExchange, SharePoint and some
third party software.
The SQL versions are: