Along the same vein as testing backups is "Disaster Recovery" planning.  Therefore, I think it is best to test the procedures for restoring an entire server (including all of its databases). ...

Do you think it is trying to upgrade the current 2000 dbs on that PC?

Curious, are you trying to install it on a fresh clean machine or a machine that already contains SQL Server?

The turkey sandwiches that play "Jingle Bells" sounds neat.

Wishing everyone a very happy holiday and a wonderful new year.

Hope you get everything you want...

Have you considered using the "Upsizing Wizard" for Access (http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx)?  We migrated from Access to SQL Server 2000 a few years back and tried both approaches (DTS and Upsize...

Yes, please do. 

The line:

There are two tables in this database, StillAnotherSchema.MySecond

should read ...

There are two tables in this database, StillAnotherTest.MySecond

Yes, the AdventureWorks db replaces Northwind and pubs in SQL Server 2005.

Not sure this is what you are looking for ... but we use "VSSPELL" (an ActiveX control) from ComponentOne in our client application that allows our users to run spell...

We have a similiar setup so I ran your query [SELECT * FROM SERVER1.DATABASE1.DBO.TABLE1 WHERE COL1 NOT IN

(SELECT COL1 FROM SERVER2.DATABASE1.DBO.TABLE1 )] on our 2 db servers.  The query...

Here's an idea:

Store the login/password in encrypted form (for more security, use 1 encryption key for the login info; 1 encryption key for the password) in a secure file on...

As I mentioned, I did try setting the "collation compatible" option.  However, the query still resulted in blocked processes (even after running for a few minutes).   The tables are not...

The field that I am using in my join is a varchar.  I set the "Collation Compatible" option on the linked server properties and tried the update statement ... same...

I agree with Kenneth that there is no "fail safe" way to find the addresses if there is no convention to how they are stored within the field.  In addition...

When setting this up, keep in mind that you will need the correct permissions setup so that the account running the SQL services have access to write to the network drive/device.

One way to see if this is a network issue is to have the users who can't connect to the server, do a "ping" to the server.  This will indicate...