To the best of my knowledge this can't be done so. You can have only a particular collation associated with an object.

I have seen people reporting this few many times. With SQL server 2005, Browser services needs to be started in machines that have more than a instance. ITs the browser...

Data partitioning gives you added advantage on the table that is heavy. You need to place the datafiles on different drives on the disk to get the performance benefit.

Yes as mentioned aboe you can't rename the schema. create a new schema and move the objects to the new schema. Also take measures to seee if anything is impacted...

You can use the link below which has a script for the same.

http://www.sql-articles.com/index.php?page=Scripts/orphan_id.html

That depends on the memory need for your server. Also on the number of users, database size, no of transaction, indexed, and lot many. you need to plan for the...

Hope the link below would help you.

http://msdn2.microsoft.com/en-us/library/ms189479.aspx

Just follow these steps.

1. login to the server using the account that you need to send mails

2. create a mail profile in the control panel

3. change your sql services account...

Put the model database in simple recovery model. Also don't create any table in the model database and no transaction there.

You can use the dynamic views to find that info using the DMV

Sys.dm_fts_active_catalogs

Sys.dm_fts_index_population

Sys.dm_fts_memory_buffers

Sys.dm_fts_memory_pools

Sys.dm_fts_population_ranges

The link below should help you.

http://www.databasejournal.com/features/mssql/article.php/1468971

Just restart SQL Server services and that would do the trick for you.

You can setup database mail using the link given below.

http://www.sql-articles.com/index.php?page=articles/database_mail.html

Yes you can move your sql server to a new PC and can access from it.

That depends on the disk space and SQL Server does not restrict you directly with this.