SQL Server 2005

Deciding on a RAID Level for a 64-bit SQL Server 2005

I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which RAID level...

Linked server problems

I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and try to create alinked server to SQl 2005 i get...

What are basic differences between SQL Server 2000 and 2005?

What are basic differences between SQL Server 2000 and 2005?

Processing XML files with SQL Server functions

Hi I read through your tip on Processing XML files with SQL Server functions. It's great but what happens when the XML file exceeds 4000 charcters? I'm using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to import an XML file that...

SQL Server 2005 database mirroring over a VPN router

Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

Attaching MDF and LDF files to SQL Server 2005

I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

SQL Server 2005 query to get the average

Hi, I'm using MSSql 2005 on Windows 2003 Server. I need some assistance to write a query to get the average of two columns and write the value to a third coulmn. All the transactions is in one table. Basically it is column 1 + column 2 devide by two = column 3 Thank you, George

install a second instance of sql server 2005

how do i install a second instance of sql server 2005 on the same server?

SQL Server 2005 SP2 backup failing

This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, "BackupMedium::ReportIoError: write failure on backup...

SSIS and Microsoft Excel

I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

What are basic differences between SQL Server 2000 and 2005

What is the Basic difference between SQL 2000 and 2005, thanks

SQL Server Agent job Failures

I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures...

VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000

I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005...

Running .NET Code to manipulate sql tables

is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

Differences between SQL Server 2005 Standard Edition and Enterprise Edition?

What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

SQL Server 2005 Text Function

Hello I have used text-function of SQL server 2005. I have ran my codes on a table with 800,000 records to serach for some specific words ( a list of 3milion words) in that. it took about 4 hours to be executed. Now I have some part of that table ( 1/8 of that including 100,000 records). I am...

Why and how to performance tune SQL Server 2005

Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better - SQL Server 2000 or SQL Server 2005?

Removing a node from a working SQL Server 2005 cluster

I have Windows Server 2003 with SQL Server 2005 Standard Edition. We have seven divided instances, with each using only two of the three nodes. However, node one has to be taken out of the cluster; what steps should be taken to insure no significant loss in performance?

Configuring a SQL Server to optimize for best performance

We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL...

Update trigger

I am working in SQL 2005 and need help creating a trigger that will update fields in a record with the user/login and system date after a field in the record is updated.