Copying a SQL server database from access vba (1 Viewer)
- Thread starter mrbg07546
- Start date
SQL_Hell
SQL Server DBA
- Local time
- Today, 15:37
- Joined
- Dec 4, 2003
- Messages
- 1,360
Hi there
You can do this by T-SQL, but might be difficult to automate if you don't have Management studio / access to the server.
Why don't you have access to Mangement studio?
Do you have access to the server via remote desktop?
Do you have the permissions required to backup and restore databases?
You can do this by T-SQL, but might be difficult to automate if you don't have Management studio / access to the server.
Why don't you have access to Mangement studio?
Do you have access to the server via remote desktop?
Do you have the permissions required to backup and restore databases?
