Another option would be to change it directly from the GUI. Run a trace while changing and see if there is something else besides the proc that the GUI...

Have you ever seen the rain?

Sounds like SSMS may be caching that. Run through the proc again and verify that it remains unchanged, log out of SSMS and back in and check again.

Thanks, that makes sense.

Nobody has said that you need...

If you are doing a backup and restore, you would not need to copy the mdf and ldf file from the source server. You would use the backup file...

If the old domain is going away, then you may need to re-add any domain accounts or groups (especially if that group or user is not currently in the new...

Here is a basic query to give basic info. There are other queries available online that could give you something different if need be.

select top 10 backup_start_date,backup_finish_date,type,backup_size,database_name

from backupset

Order by...

For the issue that Elliott raises, the following doc may be of use.

http://support.microsoft.com/kb/280297

Try this site:

http://social.technet.microsoft.com/Forums/en-us/categories/

There are forums sponsored by MS for just about everything under the MS Sun.

Others are Idera Diagnostic manager, Redgate now has a tool, Confio has a tool, Spotlight, and the homegrown monitoring solutions that many will implement. Each will have pros and...

Have done it in the past and it has been helpful. Our implementation was that each mount point was represented as a folder on the "Drive." This was...

There are other methods, but backup restore will likely be the fastest.

Once you restore the database, make sure you verify the logins work.

The...

One more suggestion along with how to grant the permissions is to grant the permissions to a role. Then add that user to the role rather than granting permissions...