I admit, that I don't really read it, but each week I wonder why it is send weekly and named database daily.

Maybe it's just me, but can you give some more details what will this be used for?

1) Yes, you cannot buy EM or QA separately. You can however buy Personal edition. I think both are included there and it's only about $50 or so.

2) myLittleAdmin...

I bet you'll find something here in the script section. As a very basic starter might this serve:

sp_msforeachdb "select * from sysobjects where objectproperty(id,'ismsshipped')=0"

This statement will never work. You're mixing DDL and DML in one. Either create the table explicitely BEFORE the INSERT with CREATE TABLE or use SELECT INTO.

You got me...

The error message is pretty much self-describing. You can hava only *one* IDENTITY column per table. I think you should provide more information on your table structure. http://www.aspfaq.com/etiquette.asp?id=5006 

It would be helpful if you could post the statement that caused this error.

Do you mean, you can't do

ALTER TABLE < mytable >

 ADD < myid  > INT NOT NULL IDENTITY

GO

???

You have read my post, haven't you?

key column information insufficient or incorrect. too many rows were affected by update.

You have not defined a PRIMARY KEY constraint on your table!

To workaround this, open the table in...

To explain it. You apparently *do* have duplicates in your data. Run the above script, remove the duplicates which will show up there and then you should be able to...

Hey Steve, nice one-man show this thread

One son ate daddy's hearing aid batteries

One might argue, that in many cases at home a hearing aid isn't a disadvantage at all. After all you can always blame it on empty batteries...

Hey, finally found someone with the same problems

Not much, but see if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

You can have a look at the original MS training book. I like that.

As for practise tests, google the archives of the mcdba newsgroup. Plenty of information there.