DBA to server isn't always a good thing to go by. One server may have multiple instances and/or databases while another may only have one instance and database. ...

In SIMPLE recovery mode, the transaction log gets checkpointed and SQL Server will 're-use' the space based on the checkpointing.

-SQLBill

Have you tried going back to Microsoft's website and downloading it again?

Are you trying to install it over a network?

Do you have the proper OS permissions to do an install?

-SQLBill

Here's the links where you can buy them:

2000:

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/adminpoc.mspx

2005:

http://www.microsoft.com/MSPress/books/6794.aspx

-SQLBill

What is the error? Check your windows event viewer logs and the SQL Server error log.

You could be trying to install the wrong SP2.

-SQLBill

It would help us if you would provide us your schema (table and column names), sample data, and what you want returned. That way there is no misunderstanding about what...

It's really NOT designed for how fast you can read...it's designed to see if you can pick out the important information from the non-important.

-SQLBill

There's a lot of 'extra' in the scenerio to distract you. Sometimes it pays to read the question, check out the answers, then go to the scenerio where you can...

Do you want to do it via code or GUI?

-SQLBill

Depends. The prefered way (for us) is INT and store it as a 16 digit number. Then use the front-end app to add the dashes if needed.

HOWEVER, there...

So who posted that? The handle says it's Steve, but the sign-off says Tony.

I enjoy kayaking, hiking, or golfing to unwind.

-SQLBill

Please don't cross post. I just answered your question in your other thread.

-SQLBill

Reading your post, I don't think you want to use INSERT. You don't want a new row:

RD 25 1 blue

AB 45 2 green

AC 25 3 purple

AD 34...

Depends. I know that is a wishy-washy answer, but it's true. We don't know your environment and/or requirements.

I had a 300 GB database (SS 2000) at my last...

Microsoft's sp_help_revlogin will work. The KB article says how to move logins from 2000 to 2005.

-SQLBill