Viewing 3 posts - 1 through 3 (of 3 total)
I did a search and found that SQL 2000 does have a system procedure called sp_change_users_login
which does fix the database login to match the SQL Server instance.
MSDN...
December 19, 2007 at 2:31 pm
sunjiulu,
Thanks for the explanation.
Yes, I am using SQL Server login rather than Windows Authentication. We have created a SQL Login of the form "ApplicationUser" with access to...
December 18, 2007 at 3:06 pm
I've noticed that when I Restore a database (in my case to a different machine) that the security settings that were in place on the original database are not replicated...
December 18, 2007 at 2:38 pm
Viewing 3 posts - 1 through 3 (of 3 total)