Check following common IIS-related services:

Service Name

Iisadmin

Msftpsvc

Nntpsvc

Smtpsvc

W3svc

HTH

My suggestion; do not change/update any thing on system table/database.

Database which you are going to restore is in use hence your restore fail. No one should connected to the database your are restoring. If you found any connections to...

Easy One! thanks.

Yes, your error is very correct as there is no column called 'SSMA_TimeStamp' on the table 'doctors'.

What error you are getting?

sp_MSforeachtable will perform the execution on all the tables but you need to remove the column from some tables?

As mention by Stuart you need to kill the connections for required database. If database is in use; you can't perfrom restore operation.

It is not advisable to put anything like user proc on master; instead you can create new database and store stored procedures. Also it is not a good idea to...

If you do have multiple databases/applications on server you can move some of the application to other server to reduce the load.

If load on the server is more the only...

It purely depends on the customer requirement. We can't create more database and put more data to manage. Instead of finding howmany DB supports try to understand environment of the...

Appreciate your help to find out this link.

Appreciate your help to find out this link.

Yes, CDC can be used to update DW database. Refer following doc

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=5&ved=0CD4QFjAE&url=http%3A%2F%2Fwww.infosys.com%2Fmicrosoft%2Fresource-center%2FDocuments%2Fchange-data-capture.pdf&ei=Ylc-U7PEA8aSrgfn5oHIAg&usg=AFQjCNEd1IyaLTlQmx9O0lXJ7GVYfJE0yA&bvm=bv.64125504,d.bmk&cad=rja

HTH

Also if publication not set up to replicate schema; you need to remove and add from subscriber & publication. Also need to run snapshot agent to pickup the change.

Still I will let SQL Server to decide instead of external WITH RECOMPILE.