1
vote
1answer
108 views

Remote restore of DB in MSSQL 2008

I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way ...
0
votes
2answers
289 views

MSSQL Remote Backup

Environment: Shared Hosting - No MSSQL control panel - Only have mssql management studio MSSQL Server: Remote - YES Remote SQL Connections - NO FTP - NO Shared Drive Is there a way to backup MSSQL ...
2
votes
3answers
220 views

connect to remote database

I am new to SQL Server and I'm wondering how to connect to a remote database. I am not trying to do this through a web app, I am just trying to connect to and view a database (which exists on a remote ...
0
votes
2answers
908 views

execute a script against a table on a different instance

Scenario Its pretty involved to explain but I have a procedure that updates data in two databases on instance1 and as part of the process (its a cursor for relevant reasons) it needs to make updates ...
1
vote
2answers
303 views

Can I use a remote user to log in into a remote SQL Server?

Can I use the administrator user of a remote (no domain or anything like that) Windows Server to log in into the SQL Server running on that same machine? That would be, using the same credentials, ...