Do I use my own SQL Server Management Studio to attach it to the web server?

>>If I were to set up a pre-designed SQL Server database on a web server, according to a friend of mine, all I have to do is to copy the database to the web server. Is that true? It would seem to me that it's a little more complex than that. My friend says that he uses MySQL and that all he does it copiy his files over to the web server and he is done. Is it that easy for SQL Server database files?

>You need to attach the database. So, if you designed your database locally, you detach it, send to Web Server and attach there.