Viewing 15 posts - 16,636 through 16,650 (of 19,564 total)
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...
March 10, 2010 at 4:39 pm
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.
March 10, 2010 at 4:18 pm
YSLGuru (3/10/2010)
...and so far most of the replies have said I can't do a restore without those system DB's whcih is just untrue.
Nobody has said that you need...
March 10, 2010 at 3:54 pm
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...
March 10, 2010 at 2:57 pm
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...
March 10, 2010 at 2:32 pm
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...
March 10, 2010 at 2:06 pm
For the issue that Elliott raises, the following doc may be of use.
March 10, 2010 at 1:36 pm
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.
March 10, 2010 at 1:34 pm
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...
March 10, 2010 at 1:21 pm
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...
March 10, 2010 at 1:18 pm
There are other methods, but backup restore will likely be the fastest.
Once you restore the database, make sure you verify the logins work.
March 10, 2010 at 1:05 pm
sandip.vs (3/10/2010)
Finally i figured out the problem...its because of Blocking and Locking issues.......But i don't have much idea how to solve those issues.....Can u guys throw some light on it???Regards,
Sandeep
The...
March 10, 2010 at 1:04 pm
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...
March 10, 2010 at 12:55 pm
Viewing 15 posts - 16,636 through 16,650 (of 19,564 total)