I'm testing out the install file for Pick'Em v3 and finding some more stored procedures that I don't use. Here's the list:
- PickEmPicksGet
- PickEmUsersGet
- PickEmUsersUpdate
- PickEmWeeksUpdate
I also discovered that my regex for creating sql install files was forgetting to put the 'CONSTRAINT' keyword back into DF, PK and FK statements. Whoops.
Furthermore, I learned that when you're dropping a constraint, you can't use dbo. in front of the name of the constraint that you're dropping. Weird.
Finally, I learned that databaseOwner and objectQualifier are case-sensitive. Who knew'