Julie, try going into Control Panel ~ Admin Tools ~ Data Sources (ODBC) and then change the info on the connection from there.

Sql Server 2000 will reach the end of the mainstream support phase in April 2008 - I would suggest studying for the 2005 exams.

You need one exam MCTS to get...

Here's one more idea - MAKE A BACKUP COPY OF THE ACCESS FILE FIRST

And then open the COPY, click Tools ~ Options ~ Tables/Queries and click the checkbox for "SQL Server...

The last four paragraphs of the article sums it all up - you can never have total control of a project, but if you do the best you can to...

This has happened to me sometimes, too.

But today I tried to vote for Stephen's Excellent SSIS article and it did not record my vote. So I voted a 2nd time,...

I agree that the "correct" answer is wrong due to the versioning nonsense.

I routinely take a backup from a production 2000 system and restore it to my dev 2005 system....

David, you said

"A row per column name, table name, etc. "

Amen to that!

Assuming that the column names selected are unique to begin with, I don't understand why you would alias the _column names. You can't use the alias in a WHERE, GROUP...

If you are running SQL 2005, SSMS knows how to print in color, which can really help when working on a procedure.

There is also a tool called NotePad2 from flo's...

The Instant SQL Formatter does a fairly good job, at:

http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm

I think I picked up that link from one of the forums here.

SAMS Publishing has some books titled like "teach yourself C# in 24 hours" and "teach yourself visual basic .NET web programming in 21 days" they are both excellent for getting...

I did a clean install of Vista Business on a bare-minimum config: 1 GHz Celeron with 512 RAM and 20 GB disk. It runs OK. I changed all the settings to...

I went solo 14 years ago, and never looked back. The 10 points in the article - I see those as positives for a disciplined, self-motivated individual. It's true that...

One more thing - in Access, an autonumber value exists as soon as you begin creating a new record; in SQL Server, an identity value does not exist until you...