I want to know where I can find those!

Yes, look search the web for the stored procedure sp_help_revlogin. That will get you everything you need to script out the logins. That should work fine on 2005 as well.

What happens when you do a restore database Test with recovery?

Are you looking for free space in the data file or are you looking for free space on the disk?

Does this link help? http://www.sqlservercentral.com/scripts/Backup+/+Restore/31640/

Well, I would recommend trying to a lower version of SQL Server and / or a database created on 2008 and set with a lower compatibility level. Just a thought....

What version of Access? Curious if you were to try this against a database server less than 2008 to see what would happen. You could always take the database and...

I guess the thing that bothers me the most in all of this is that many of the people that reply to these posts do so in a way that...

When are you getting this error? Was the upsizing process successful?

Being that you are 2005 you should look at using sp_send_dbmail. The parameters @attach_query_results_as_file and @query are the key ones you are going to need.

Post with any problems or...

This is a permissions problem. You should check with the person who manages the security for the database in question to validate that you have the appropriate permissions required to...

Lee - Is this a "what if" question or did this really happen? If you are concerned that you may have a corrupted database and that the database backup you...

The white paper at this link is where you want to start your research - http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

Please post with any specific questions that come from your reading and investigation.

Hope this...

sp_who2 is the command you want to run and it should provide all the information you need.

I agree and the post that I referenced discusses these concerns openly.

Marker - Please make sure you read the rest of the post that I referenced to ensure that...