Activity overview
Latest activity by dlgross
Comparing Between Domains
Will the Compare tool work if we have a development server in one domain and the production server in another domain?
Renaming Tables
How can I rename a table in my development db and have the changes propagate/sync into my test DB without dropping the table in the testDB. This would cause me to lose my testing data. The scripts ...
Auto Update Failing
When I check for an update, I see a message that a New Maintenance Updates are available, but when I click View Details I get the following error. I have SQL Bundle 3.40.
See the end of this messa...
Toolbar Suggestion
It would be nice if I could click on a toolbar button to hide the tables that have identical data like I can when I am using SQL Compare tool and do not want to see objects that are identical
The SPMUser is a SQL Login / comments
The SPMUser is a SQL Login
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 / comments
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'...
Comparing Users
Where can I find more information about what is happening when Users are compared?