I have pretty much no experience with SQL Server's Enterprise Manager so I am not sure if this is even possible (or hopefully laughably simple!) During an import into a database something has happened where each table has duplicated itself with two important differences. The first is that the Owner on both tables is different, the seco...
I have a table with a whole bunch of FKs. Table Vehicles ----------- ColorID -> Color.ID MakeID -> Make.ID ModelID -> Model.ID etc... My issue is that I forgot a few columns and I need to add them. I can add them through right clicking on the table and choosing 'Design', but not if I want to make them NOT NULL, or delete a column. I...
Guys, I know this might not be related to programming, but its close to home. Our company has embarked on a process of acquiring an ERP, we shall be doing things like business process mappings and business requirements(BR) later in the project. This is a massive undertaking for our company. I'll be leading the technical team on this jo...