Blog

Configuring Linked Servers

You can use the instructions below to set up a linked server in SQL Server 2005. NOTE: Make sure that the SQL Server that you want to link to be configured so that you can access the SQL Server.

By Admin

SQL Server Management Studio

One of the most important tools to manage your database is Microsoft SQL Server Management Studio. This application will allow you to manage all of your databases on a server as well as write queries against a selected database. Once you open the Management Studio application, you will see a dialog on selecting a server. You will use this dialog to select the server of the database that you would like to manage.

By Admin

Restoring a Backup

Use the Object Explorer and select the Server that the database is in Expand the Databases folder Right click on the database that you want to restore the backup to

By Admin

Backup a SQL Database

Use the Object Explorer and select the Server that the database is in Expand the Databases folder Right click on the database that you want to backup

By Admin

SQL Server Stored Procedures

Addressing Code Injection Risk If you have a query that you want to execute often, you might want to make a stored procedure out of it. Stored procedures help to avoid SQL injection. SQL injection is a code injection technique that exploits a security vulnerability occurring in the database layer of an application.

By Admin