Explore SQL Server 2005 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2005Microsoft SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...

Read more
  • 71K Content
  • 9.8K Contributors

Expert Spotlight
Senior DBA (Microsoft MVP)

Senior DBA, SQL Server, specialising in tuning / performance.

Article

How to Fix SQL Server Login Failed Error 18456 State 38

One of the most common issues faced while connecting to a SQL Server instance is "Login failed for …
Article
Restore Stored Procedure in SQL Server

How to Restore Stored Procedure in SQL Server

In this article, we will discuss how to deal with a situation wherein you face an issue with a mandatory stored procedure in your critical database.
Article

SQL Database Backup and Recovery - All you Need to Know

This tutorial is a great guide for newbies in SQL Server who never backup the database and for people with some experience, because you will learn some tips that you may not know.
Article

How to Recover Deleted SQL Data with the Help of Best SQL Recovery Software

1
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and consists of using a SQL Recovery Software.
Article
Attach SQL Database

How to Attach SQL Database Which is Not Properly Detached

1
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Article

Stellar SQL Database Toolkit is Best Solution for All SQL Database Issues

1
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as well as instant password recovery. 
Article

How to recover deleted rows in SQL Server

3
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Article

How to Reset a Lost SA Password in Microsoft SQL Server

5
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Article

Batch File to Perform Backup of MSSQL Database

8
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and will then append that to the file name.
Article

SQL Server database migration - The Copy Database Wizard method

2
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

SQL Server database migration - The Backup & Restore method

2
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

SQL Server database migration - The Detach/Attach method

1
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

Robust Field Cleaning Function

11
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. …
Article

SQL Server Security: Server authentication mode

1
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server …
Article

SQL Server - Converting RFC822 Dates Into Any Timezone

2
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an …
Article

Multi-tenant Database: Shared Database Separate Schema in SQL Server

byRita
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This …
Article

Does SELECT retrieve rows in the order they are inserted ( Back to Basics -1 ) ?

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it …
Article

Lightweight SQL source control using a single stored procedure

INTRODUCTION:

While tying your database objects into builds and your enterprise source …
Article

Running queries on remote databases from SQL Server

When running hybrid database environments, you often need to …
Article

Dynamic Pivot Procedure without the Pivot function

3
by Mark Wills

PIVOT is a great facility. Well that was the opening line in my previous similarly …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more