SQL

Question In SQL Server Management Studio, why is there a red arrow pointing down in the icon next to a login? This icon can be found in the Object Explorer. Expand Security , then expand Logins , and note that one or more of the login icons c...

Symptom When running Database Backup in SQL Server the following error message appears: "Backup failed for server "XXXXXX". (Microsoft.SqlServer.Express.Smo)" Additional Information: System.Data.SqlClient.SqlError: Ca...

How to perform a clean uninstall of Microsoft SQL Server Procedure Steps Important: Modifying the registry could cause irreversible damage to your Windows operating system; be sure to back up the registry before making any changes. Follow t...

How to change the Lenel database password Procedure Steps 1) Click the Start button, then select Programs > Microsoft SQL Server xxxx > SQL Server Management Studio . 2) Log into SQL Server Management Studio. 2) In the Object Ex...

How to install and configure SQL Server 2005 Express Procedure Steps To configure SQL Server 2005 Express when the installation utility was not used, complete the following steps: Note: If preferable, uninstall SQL Server 2005 Expres...

How to configure SQL Server 2005 Express if the installation utility was not used. Procedure Steps 1) Click the  Start button, then select All Programs > SQL Server 2005 > Configuration Tools > SQL Server Configurati...

 How to restore a database backup to SQL Server  Procedure Steps 1) Install OnGuard, SQL Express, and Microsoft SQL Server  Management Studio. Microsoft SQL Server Management Studio and SQL Express can  be downloaded fro...

How to check SQL Server authentication settings Procedure Steps 1) Start Microsoft SQL Server Management Studio. 2) Right-click the server name and select "Properties." 3) Select the Security page. 4) Verify that Server auth...

How to attach a database to SQL Server  Procedure Steps 1) Open Microsoft SQL Server Management Studio.   2) In the left pane, right-click on Databases and select Attach . 3) In the Databases to attach section, click [Add]. ...

How to modify the server name in SQL Server Procedure Steps NOTE: Please be sure to back up the Master and AccessControl databases before proceeding. To update the name do the following: 1) Open the Microsoft SQL Server Management Tool. ...