Is the directory a SHARED one? Can you access the other server and path from the server where you are running the package from? It sounds like a...

One cause of Loading, is that a database was restored without the use of WITH RECOVERY so it is still looking for additional files to be restored.

Try this:

RESTORE DATABASE dbname...

It looks like Adam answered a different question than was asked.

You can install the CLIENT TOOLS (SQL Server Management Studio) on a desktop or the server.

You can only install the...

Also, have you tried rebooting the server in case the upgrades required a reboot and it didn't happen?

-SQLBill

Quick question - was this a licensed or evaluation version of SQL Server? If it was an evaluation version then it may have expired.

-SQLBill

There is a change management meeting every week at my job. Everyone finds out there what is happening over the next month, so you know what will affect you....

OOOOO, I can answer this one.

Most likely issue:

The front end had a connection to the database. The server gets rebooted, but the front end is still trying to connect. The...

cyousa,

I'm not trying to be rude, I really am just curious. Why are you teaching or even setting up a SQL Server 2005 class if you are not familiar...

Yes it is possible to retrieve the information from the transaction log. As one poster stated you have to buy software specifically designed to do that. Lumigent LogExplorer is...

Thanks John. I usually try to do that when I see the poster is new to SQL Server. It helps them learn something new. I agree that...

I tell every company I interview with:

I believe in a 40 hour week. I get my work done and if it is going to take longer than my 8...

I've heard the exact opposite. You should never have a user own a database unless absolutely necessary. If the user account is dropped and they still own a database...

Good point John. I overlooked that the rule is objects should have a letter first.

-SQLBill

Yes. Just need to add the new column to the GROUP BY.

-SQLBill

Does the database 015 exist already? If not, then you aren't replacing it and need to remove the REPLACE and the comma after .ldf.

-SQLBill