Articles in this category Allow both Windows and SQL authentication in SQL Server Q: How do I set SQL Server to allow both Windows and SQL authentication? A: Follow these steps: Open SQL Management Studio. In the tree at the left, Right-Click on the server name. Select Properties in the pop... (624) SQL Authentication Q: Can we connect the Client interface using SQL authentication?A: Yes, you may use SQL authentication; however, if you do, you will need to add both the Windows user and the SQL user as users within ... (305) Backup SQL Database and Send Q: How do I send a backup copy of my SQL database? A: To send us a backup copy of your database, you will need access to your SQL Management Studio. Please follow these steps:Make a backup of your database1. Op... (368) Restore SQL Database from Backup Q: How do I restore my SQL database from a .bak file? A: To restore a SQL Server database from a back-up, please follow these steps: 1. Open SQL Server Management Studio (379) Create a Test Copy Q: I would like to set up a test copy of TRAIN TRACK®. How do I do this? Your license allows you to have a production copy, a test copy, an (512) Move database to a new server Q: How do I move my database to a new server? A: A quick guide to moving your database to a new server. More comprehensive installation instructions are included with your purchase. Install and configure SQL o... (1692) Run a Script and Update Tables Q: How do I run a script and update the tables? A: To run the script and update your database, please follow these steps: (678) HRESULT_FAIL has been returned from a call to a COM component Q: After I generated a database script, when I tried to open it, I got the message: "Error HRESULT_FAIL has been returned from a call to a COM component". What is wrong? A: This error may be displaye... (324) Transaction Log Full Q: I am getting an error message when I try to run a script saying the transaction log is full due to active transactions. A: To resolve this issue, open SQL Server Management Studio (SSMS) and locate your dat... (141)
"