If this is all for development it would be best if your account was a member of the sysadmin role. You will be able to do anything you need once...

I am not sure if you are going to be able to get that file anymore. It is probably better that you describe what your problem is in detail, that...

Correct, the database itself is okay, but I wonder if the backup somehow was bad. If you run a restore verifyonly on the backup you used, what do you get?

RESTORE...

Not sure. It seems like it was either taken offline or they denied access to the file. You may want to post a question on one of the SQL/Office forums...

What does the following command come back with:

dbcc checkdb(db_name) with no_infomsgs, all_errormsgs

If you had a dedicated drive for your page file, then it could definitely help in performance, although if you do not have a certain amount of space also reserved...

I know in merge replication you can reinitialize a subscriber, which takes a recent snapshot and applies it to the subscriber and any changes since the snapshot occurred. The same...

Just to make sure, are any of your databases in replication?

You might want to check if any jobs/maintenance plans that were running at the time failed. They will need to be investigated and run again.

What does the Windows event logs and SQL log say?

If you are unsure of the result you could always wrap the statement in a transaction. That would ensure that if it was cancelled it would be rolled back.

Have you checked this out:

Using Global Variables with DTS Packages

Which part are you trying to figure out how to do? If you want to create an array with files it would be something like this:

$fileArray = get-childitem directory-name

If I...

Yeah, if they are restricing xp_cmdshell, then powershell scripts won't work either. You have to start the powershell executable with the the correct parameters and the path to the powershell...

There is a known bug that is related to this. You may want to check if it applies to you:

Maintenance job fails on named instances of SQL Server 2000 with...