Before I engage in using mssql2 server, I would like to know how I can get a backup to my local machine, as I don't see any .dbo files becuase one cannot ftp to the mssql2 server.
An easy way would be to run SQL Server on your home PC. Using Enterprise Manager you could then connect to the SQL database and copy all the data to your home database.
An easy way would be to run SQL Server on your home PC. Using Enterprise Manager you could then connect to the SQL database and copy all the data to your home database.
I think you can also accomplish this by installing just the Client Tools supplied with MS SQL Server, in case you don't want to (or can't) install the entire server package. Key words here are "I think you can".
