This is just a principal that I usually follow - install the early version first - and then the later version. I guess I want to make sure that...

I would recommend installing SQL 2000 FIRST then SQL 2005.

When I need to do this, I usually use the "Generate Script" feature to generate a script that scripts all of the relationships between the 2 tables. Once the...

I would say that you should test your restores enough so that you know that you would feel comfortable restoring the db (and possibly the server) in an emergency situation...

Thanks for the responses - I do appreciate them. Yes, I agree that it would be easy to set up something using SQL. However, we don't have the...

1) Are you trying to log into the server using SQL authentication or Windows authentication? Try logging in using Windows authentication.

2) Are you sure that the SQL services are...

We have a similiar situation where all of our users use the same SQL login to log into the db for our in-house db application. I asked one of...

Are you sure that at the time of the backup - this table was not empty?

Have you tried creating a new blank db and restoring the same backup file to...

One of the advantages to telecommuting is that if you can be disciplined enough, working at home affords you the opportunity to work WITHOUT interruption on a project that you...

I'd give the CIO a report containing:

1) the sales data (plain)

2) The following data hashed so that it is NOT recognizable (to use to identify a specific customer) but remains...

OK - it is late in the day. Although my "find" feature on my PC did not find svrnetcn.exe. I did find it on my C drive. ...

Here are the answers to your questions. Thanks so much for your help!

1) There is no firewall between server A and my PC.

2) I tried to connect...

Thanks for the response.

Here is what I found:

1) I can ping my PC from server A so that means that they can talk to each other on the network (via...

select convert(int,VARCHAR_VALUE)

just replace VARCHAR_VALUE with the varchar value that you want to convert to an integer.

Is there something wrong with the database that is assigned as the "default database" assigned to the user that you are logging into Query Analyzer?