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.

Troubleshooting Question

SQL database refresh between 2016 SQL (source server/ db) and 2014 SQL ( destination server/ db)

9
i have couple 2016 SQL database that i need to migrate over to 2014 SQL.

is it possible to backup …
Troubleshooting Question

Upgrading MS SQL Server 2005 databases to 2017 or 2019

4
A client of mine has MS SQL Server 2005 running on an old server.  They have another server they …
Research Question

MS SQL jobs with email alert

1
hi,

I'd like to build SQL jobs alert , as long as a SQL jobs failed it will email me, without …
Troubleshooting Question

Visual Studio 2005 - precompile issue, variable not declared

byPutoch
2
Hi,
I have inherited a package, which is written in VB.net
The package used to run without issue, but …
Troubleshooting Question

Process XML Data from XML field in SQL Server

1
I have an XML String that is stored in a database field.  I need to write SQL to pull certain fields …
Troubleshooting Question

Compress NVarChar column to use less disk space?

bywebsss
8
I have a very large table with 1 billion rows
One of the columns stores full address details …
Troubleshooting Question

Why won't my ODBC connection work after moving from SQL Server 2000 (8) to 2005 (9)? It's classic asp.

13
I am moving my classic asp application from SQL Server 2000 to Sql Server 2005 (8 to 9). Please …
Troubleshooting Question

t-sql Function Working Days

6
Hi Experts,

I have written the following code  to get Working Days.
For example, you will enter …
Troubleshooting Question

SQL Server The transaction log is full due to 'LOG BACKUP'

11
I ran into a full log file issue again.  The error was "SQL Server The transaction log is full due …
Troubleshooting Question

Move/Migrate SQL 2005 database to SQL 2012 server

2
Silly question but I don't have a lot of experience with SQL.  I have a SQL 2005 server and I need …
Troubleshooting Question

slow running query - help with speeding it up

bywebsss
6
I have the following query that is way too slow

select distinct …
Troubleshooting Question

SSRS Save Report to Named PDF and path

The following command string exports a PDF to be saved or opened.

start explorer …
Troubleshooting Question

How can I capture deleted records in SQL Server 2005?

3
Hi experts,

I get a requirement to monitor deleted records in SQL server 2005. As I know, neither…
Troubleshooting Question

Help with creation of Trigger to capture failed INSERTS

5
Hello.

I want to create a trigger on a table on INSERT. So when an INSERT attempts to happen on …
Troubleshooting Question

Display SQL table rows horizontally

6
Hello Experts,
I am trying to display a table rows horizontally by TKT_Id.  I have two tables, …
Troubleshooting Question

SQL question

9
Hello Experts,
Currently I have a view as below (look Current).  I am trying to make it more …
Troubleshooting Question

include a row count in SQL generated HTML formatted email

2
Thank you all in advance for taking a look!

The sql below sends an email update in the form of a …
Troubleshooting Question

conversion of varbinary to varchar givig unexpected result

1
I have a table having varbinary column which is primary key.
Whle trying to retrieve the data as …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more