Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

« Newer Snippets
Older Snippets »
2 total  XML / RSS feed 

Fix orphaned users in MSSQL

Thanks to CodeProject for this code

Run this in the Query Analyzer (make sure the right database is selected first).

sp_change_users_login 'auto_fix', 'UserName'
to users sql mssql microsoft data transact orphan orphaned user restore restoration restoring by chrelad on Dec 11, 2007

Creating a MySQL database and adding a user from CLI

mysql -uroot -p
mysql> CREATE DATABASE staff_hieraki;
mysql> GRANT ALL PRIVILEGES ON staff_hieraki.* TO staff@localhost IDENTIFIED BY 'password-goes-here' WITH GRANT OPTION;
to mysql databases users by jason on May 26, 2005
« Newer Snippets
Older Snippets »
2 total  XML / RSS feed