Posts

Showing posts from November, 2015

Reversing or disabling Contained Databases in Microsoft SQL Server 2012

I'm no SQL MVP, so I'm not here to tell you the correct way to recover from a failed attempt at enabling SQL Server Contained Databases, but I will tell you about what I experienced.

I started by looking for a way to use this with AlwaysOn and my Infor Visual Manufacturing database on SQL 2012 Enterprise Edition (Required for AlwaysOn) so that my users would show up in the secondary database servers without having to copy their profiles from server to server using tools that export the Hash and SID, like sp_help_revlogin (Look into this! It works great and is a safer alternative).

Turns out that this was a bad idea.  I tested it in a lab and it worked fine, but I didn't test every function and I found that Info Visual Manufacturing ERP has a collation error in the Audit Maintenance window.  This was the error:

Android Play Store Privacy Statement

Privacy Policy Applications written by Ed Hammond do not collect information. I do not have access to any information on your phone and my apps do not send information to any other parties or sites. I do not use in-app purchasing features or ads. If Google or some government want more information that that, then I will just delete my app from the Play market. It's not worth the trouble since I make no money from "Beer Goggles" or "Auto Text message".

Ebates - Who doesn't like cash?

Image
If you look at my blog you will see that I really don't endource anything, and I really don't make any money on this blog either..
That being said, if I helped you in some way you can show your gratitude by signing up for ebates with my referal code:

http://www.ebates.com/rf.do?referrerid=vpPT%2BYiBUnQa9sVBzbenIw%3D%3D&eeid=28187

(You get $10 for signing up too, so better than free!)
I shop online all the time (Love ebay and Amazon) and it saves me lots of Money. Usually 1%, but sometimes up to 10%.  Free to sign up and easy to use.

Thanks for the support!


Solved: Moving Users to a SQL Contained database stops with an error

I decided to convert my ERP Database to a Contained Database so that I could have the logins move between servers with AlwaysOn on Microsoft SQL Server 2012.
https://msdn.microsoft.com/en-us/library/ff929071.aspx
SQL wouldn't let me convert the database while in use, so I had to make the change at night.

This is the script I used for migrating all the user accounts from the server to the DB:
----------------------------------------------------------------

DECLARE @username sysname;

DECLARE user_cursor CURSOR

FOR

SELECT dp.name

FROMsys.database_principalsAS dp

JOINsys.server_principalsAS sp