K12IT

Apparently, in SQL Server Management Studio, copying a database via Tasks -> Copy Database and choosing the “Detach and Attach” method can drop all user permissions from the source database. Awesome.

I’ve yet to figure out whether this always happens or if it’s only in specific circumstances, but I can say that I’ve had it happen to me multiple times. My advice: use the tried-and-true method of backing up the source database and restoring it to the new destination instead.