Re: [ADMIN] "Data import from Mysql to MS Sql Server"

2012-07-26 Thread Mark Lane
Wrong list, but I would look at creating SSIS packages to transform and load data into SQL Server. You can find out quite a bit about this from the technet area of the Microsoft website. Mark On Jul 26, 2012, at 3:46, Rajat Sangal wrote: > Hello Everyone, > > I want to import Data from

Re: [ADMIN] New role can connect to all dbs with no grants

2012-03-20 Thread Mark Lane
Gordon On Tue, Mar 20, 2012 at 5:02 PM, Gordon Shannon wrote: > Hi. I'm confused about how to restrict databases from roles. When I > create > a new database, I thought I would have to grant connect to a role in order > for that role to connect to it and see its objects. > > But... > > [admin@