I'm really a beginner with database and I don't know how can I access by example with SQL server management studio (express or not) to a remote sql database which is based on a remote server through internet.
When I start SQL server management studio express I can put "name of the server" and authentication but I really don't know what to put here. Do I need to put a remote IP address? Does it work like that?
Can i access to a remote database with SQL server management studio or I need something else?
What I want to do is to begin, access to this database, and then, I would like to copy a table from this database to a local SQL server.
Any help will be really appreciated!
View Complete Post