Sorry, I missed the second part of your reply - If your Windows user is a login to the box and a user of the database then you should be...

Yes, only one instance - the default and no, the port has not been changed.

SQL is set for both named pipes and TCP/IP for local and remote connections. I have tried running under my user account and sys admin accounts. I am...

Hi Jack and thanks for responding so quickly. This is a Helpdesk application and we can connect via a web URL. I can not connect (so far) with...

Thanks again, John. Your first WHERE statement is enough for me to get what I needed. There were only about 2500 rows so not too much to go...

Somehow part of my post was lost. The query I am using is:

SELECT distinct badgenumber, employeenumber, lastname, initials

FROM PersonTable

where employeenumber '103999' or employeenumber is null

order by...

Thanks, Rich. That's what I was looking for. Even though I won't primarily be programming, I'm the only one here who does the queries. I believe that...

Thanks, Steve. Actually, the school is AUM - Auburn University, Montgomery, Alabama Technicenter. It's a certified Microsoft training center. My experiences with these is that they "Read...

Also, do not give them the SA account. You can create an account with the required rights for this.

just my $0.02

To answer your first question: Yes, I do have a red stapler. It's a Swingline model 747. Actually when Office Space was made, Swingline didn't make the...

Hey - This is just a WAG. Check users and see if there is "Ghost Cleanup" running. This shows up from time to time and can suck resources...

And I might add - even though you said the database is huge, I would make a strong effort to restore it to a test box just to be sure.

To restore the database from a *.bak file to the empty database you created:

1. open the databases tab and right-click on the database you want to restore.

2. Select Task\restore\database

3....

Also, make sure you have the logs and data files in the proper location - might be different between the old server and new.

For me, I make a backup of the database and copy that over to the 2005 Express server. I then just create the blank database and restore. I...