index
SQL Server General
- I changed my vrmco\jbechtold password, because they expire every 6 weeks, and found that I could no longer login to my local SQL Server instance. After fumbling around awhile, I opened SQL Server Configuration Manager, and tried to start SQL Server (MSSQLSERVER). It wouldn't let me start it. So I changed the password for vrmco\jbechtold in there (it took a couple of tries, and I had to switch back and forth to login types), and then it started, which then allowed me to login to local in SSMS.
To create a foreign key:
- right-click Keys folder under the table you want to create the foreign key in
- choose "New Foreign Key..."
- In "Foreign Key Relationships" window, click in space to right of "Tables and Columns Specifications". An ellipsis will appear. Click on ellipsis. "Tables and Columns" window appears.
- Foreign Key table is the table you're creating the foreign key in.
- Primary key table is the table containing the PK you want to create the foreign key on
- VRM naming convention:
- FK_ThisTable$ForeignKey_ON_ForeignKeyTable$PrimaryKey
- FK_EmployeeReqToSoftwareTypes$EmployeeReqID_ON_EmployeeReqs$EmployeeReqID
- FK_EmployeeReqs$DepartmentID_ON_ValidDepartments$DepartmentID