I had heard that the Transmeta Crusoe chip is "painfully" slow, to the point of music/video skipping and dropping frames.

Now the Origami with the Intel Pentium chip.....

Sergiy:

Now you agree that Customer Number is a property of Customer, not Person

NO, I did NOT agree.  I said (repeatedly), it is all relative to the system you...

"ORDER BY hdr_HeaderID, col " doesn't work?  If not, I suggest that you make each of your headerid columns the same name.  I think that SQL Server will only use...

Your example is wrong.  If the system was an order system, then the orders would (likely) be linked to a Customer table, not a Person table. If the Person table...

I would understand the problem with almost any application installation in terminal services session is that the system registry would not be updated correctly.  Each terminal session is using a...

Not sure what you want to show.  If it is just how a query would work, you can do SETUSER in the query window to test being a specified user. ...

As the message indicates, you must list the table fields in the insert clause.

INSERT INTO mytable

(field1, field2, field3)

SELECT * FROM mytable_temp

A handy way to do this in QA is to...

Everything else - relations between Person and other entities, including other Persons

And that is the point.  It depends on the application the database is designed for.  A person table in...

Gender, customer number, marital status, social security number, drivers license number, felon, religion, height, weight, eye color, hair color, VIP, MVP, CPA, CAP, PCA, CPIM, MCP, A+, CLU, favorite food,...

I don't believe that any Windows OS ever had a CAL for SQL Server.  The closest thing I can think of would be an SBS cal has SQL CAL for...

MDAC no longer contains the Jet drivers (after version 2.2, I believe).  You have to get them separately from the Microsoft download site.  Go to http://www.microsoft.com/downloads and search for...

If my understanding is correct, when the DTS is executed by the job, if the DTS uses 'Windows authentication' on the connection steps, the credentials associated with the sql server...

Charles;

Is your Windows authentication logon defined in sysadmin? 

If not, then opendatasource (and openrowset or linked server) do not use the SQL Server service account for access, but the SQL...

As Ian described, you need to explicitly list the columns in both the insert clause and the select clause.  You do not need to include the identity column in the insert...

Yelena;

Sorry I hadn't noticed this post until you had pointed it out in the QOD forum.  I thought I would add this as a help for others that may be...