I want to share this information with others about how simple it is to use Visual Studio 2008 web site administration tool with a remote hosting site like GoDaddy.com. It took me several hours to figure out how to do something that takes about 5 minutes.
I am going to provide this example using GoDaddy.com because at the setup stage of creating a GoDaddy.com database it gives you the option of implementing the ASP Schema with all the security tables. You also need to select "allow direct database access" for this to work since you will be accessing the database from Visual Studio 2008 on your desktop. Once you have created the database and verified the ASP Schema security tables are there, in the database listing screen click on the little pencil that has the tooltip "Edit/View Details". At the top of the screen that comes up, click on the "Configuration" button. A listing will dropdown and you want to copy the text in the SqlConnection (.NET): ...
Go to the complete details ...