Post the error message that you get when you fire the alter db syntax.

URL for the article.

http://www.sqlservercentral.com/columnists/jDave/3046.asp

Database Monitoring is a Disaster Recovery solution where by your database can be put up in a secondary server and can be used when the primary server loses connection. DB...

You would need to give access to other user databases as permission needs. the second part of your question is not clear. can you post briefly.

This error occcurs when databases with different collation interacts. This can be solved by specifying the collate collation name in the from clause of your query.

Script the index and the fire against the destination table before that remember to change the tablename in the script generated.

You can use read committed isolation level so that you don't get uncommitted data as a result.

Check if this post given below helps you.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=362688

Are you mentioning any delimiters in moving data.

Sure i shall do that.

This looks funny. you are posting a question on how to post a question. Just post a question like how you have done now and post it in the right...

Check setting isolation levels appropriate so that deadlocks and locks can be avoided.

dbcreator role should be the one you should give if you give sysadmin then the users cando anything with sql server so better avoid that.

use

backup log dbname with truncate_only

go

dbcc shrinkfile(2,targetsize)

this should shrink logfile for you.

Recovery model full is the best option to backup tlogs. If you dont want to lose much data then backup tlogs every 5 or 10 mins and have a retaination...