Create the same Login for Multiple Databases on Same SQL Server -

Hi,

If I create the same login for 2 databases that are on the same SQL Server will I be able to run sql statements that take data from DB insert it in the other?

Thanks,

Will

 

If they are on the same server, yes, you can move data between them.

But you won't be able to create the same username for two databases on the same server...database usernames have to be unique, for security reasons.