Comparing Users

dlgross

Where can I find more information about what is happening when Users are compared?

Brian Donahue

Hello,

Thanks for your post. The information about users comes from the syslogins system table. Is there a specific thing you want to know about the way that it compares them?

dlgross

Why is comparison showing the databases as different for the following user?
1st database
-- User
if not exists (select * from master.dbo.syslogins where loginname = N'SpmUser')
exec sp_addlogin N'SpmUser'
GO
sp_grantdbaccess N'SpmUser', N'SpmUser'
GO
2nd database
-- User
if not exists (select * from master.dbo.syslogins where loginname = N'SpmUser')
exec sp_addlogin N'SpmUser'
GO
sp_grantdbaccess N'SpmUser'
GO

Brian Donahue

Is SpmUser a Windows logon, or a SQL one? Unfortunately, SQL Compare differentiates Windows security users if they are from different machines. In other words, MACHINE1\ASPNET is not the same as MACHINE2\ASPNET.

dlgross

The SPMUser is a SQL Login