SQL Server table setup

Yep, it works the same way bro.
Just connect to your remote SQL account from the manager IDE.

Depending on your own likes you can replicate the changes from remote to local or visa-verse when you're ready.

One tip, it often helps to resolve remote connection timeouts if you check the "Optimize for many tables" option and "Run in a transaction" during Import/Export.

 

if you have enterprise manager or sql server management studio, you can connect directly to the db and create your schema


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

I am new to using SQL Server in web-hosting world but have experience inSQL Server development. My question is can I actually create databases and tables and stored procedures, etc. in web hosting (discount asp.net) or do I do all this on my local computer and export the entire structure todiscount asp.net?

thanks

 

From the SQL Server 2005 Management Studio just click the Connect/Database Enginebutton.
Then fill out the DASP server info in the dialog that opens.

From SQL Server 2000 Enterprise Manager use the connect to Database options.

 

thank you for reply. So Im in my Enterprise Manager, how do I make the connection to my DASP SQL Server 2005, sorry I need step by step on this one.