I, too, don't think you're that kind of person, but I couldn't get behind the meaning of your post and I haven't had the best day at all yesterday.

No...

As for 4:

Go to My Account -> My Recent Posts. I think almost all of your posts are listed there. Unfortunately I am only able to see the first page,...

I thought at the next election it will be :

Hasta la vista, Bush

Wasn't aware that you've already replied, Allen.

Actually I've never tried it.

I guess most guys here would stay away from using EM wherever they can. Sometimes it seems to have a mind of its own. If...

Thanks!

Forgive me for this (my mood management today has failed), but you might suggest your boss to post to Microsoft SQL Server newsgroups. With a little bit of luck Joe...

This depends on the version of SQL Server you have. Standard edition is limited, Enterprise edition not. Take a look at Maximum capacity specifications in BOL for detailed informations.

To 1: In most cases only the connection string will change.

To 2: Migrating the data itself isn't that difficult. Either the Access Upsizing Wizard or the SQL Server Import...

Do you get the same results when using Query Analyzer?

Hm,...is your boss the database expert or you ?

50,000 rows are not really much, so I guess either way you won't notice a...

Your table structure slightly exceeds the max pagesize of SQL Server, which might be a reason that rows won't get updated.

http://www.sqlservercentral.com/columnists/sjones/pagesize.asp might clear things up a bit.

Anyway, using EM to...

Michael Moore? Stupid white men? Got the book, but didn't manage to read it yet.

????

Hey alzdba, am I asking for too much when I want to have an explanation for something I don't understand?

Right now I'm insecure if I should feel offended or...

Take a look at Antares explanation here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=17899

No big deal at all, but worth noticing