David's correct - set based systems return a bunch of rows that form a set - a set has no order.  To maintain row numbers, etc you'll need to add...

I haven't used log shipping yet as it was previously only included in the enterprise/developer version of SQL 2000.  We are about to set up a small accountant's office with...

It's a shame when something is so straight forward but you need the new version - i'm in a similar situation myself for a small part of our proposed Infopath...

For row #27 is there a field with the value 27 in it?  (this would be like an identity).  If not, how do you know which row is row 27? ...

No probs

Just reread my post to remember what I said...  The tool on win2k is still in the system32 folder, just that...

Please explain what you mean by the statement "the pkeys are not unique" - they have to be unique to be primary keys!?  That's the whole point of them.

Are you...

I don't have a copy of SQL 2005 installed near me at the moment, but perhaps you need to put the DOMAIN\USERNAME in square brackets, such as

ALTER

use the inner join - from your description you have some pkey that is the same in each table... So an inner join such as

select A.pkey, A.field1, A.field2, B.field1, B.field2,...

And the quoted discussion is DEFINITELY talking about memory being 2GB limit, not DB disk size - although that happens to be the limit for DB sizes in MSDE

The osql utility is not MSDE per se - much like enterprise manager is not sql server standard/enterprise... osql happens to come with all flavours of SQL..

Anyhow, see here.

C:\Program Files\Microsoft...

If yo uare going down this road then you should

a) Make sure that you provide tools to do things like backup / restore, consistency checks, etc

b) Be aware that...

I guess you are running a foreign language version of windows so no probs there.  The actual error message indicates that you can connect to SQL Server but the default...

try running this from the command prompt when you leave QA idle.

ping -t [MY_SQL_SERVER]

This will constantly send pings to the server.  If it keeps getting consistent replies but your connetion...

Personal edition is the same as MSDE but with a copy of Enterprise Manager, Query Analyser, etc...  When you purchase SQL Server Standard/Enterprise you also receive media for Personal edition. ...

Remi has expressed the right point I must admit - this is, if used for reporting, a client-side issue.  However, there are times when having some sort of row number...