Using an indexer for SQL Server 2005
Hi The application I work on is a Java web application with sql server 2005. A user can search for a document stored in a file server. When they search for a document, a stored procedure is invoked from the java code and an open query code is used to go to a catalog created [...]

Answer Question   |  March 9, 2009  7:12 PM
Indexed tables, Java applications, Java Web application, SQL Server 2005, SQL Server Indexes

How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Hey guys!!! I’m quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I’m trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is [...]

Answer Question   |  March 9, 2009  11:01 AM
Data Junction, Extract Transform Load, INSERT statement, SELECT statement, SQL Server 2005, SQL Server connectivity, VB.NET 2005, Visual Basic .NET, Visual Basic 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 [...]

Answer Question   |  March 6, 2009  8:22 PM
RAID, RAID Level 1, RAID Level 1 +0, SQL Server 2005, SQL Server 2005 (64-bit)

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 [...]

Answer Question   |  March 6, 2009  2:34 PM
Linked Server, Linked SQL Servers, SQL Server 2000, SQL Server 2005

What are basic differences between SQL Server 2000 and 2005?
What are basic differences between SQL Server 2000 and 2005?

Answer Question   |  January 25, 2012  9:40 AM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

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 [...]

Answer Question   |  March 2, 2009  1:43 PM
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005

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?

Answer Question   |  February 27, 2009  3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers

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?

Answer Question   |  May 20, 2011  3:33 PM
LDF, MDF, 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, [...]

Answer Question   |  February 24, 2009  5:43 AM
SQL, SQL queries, SQL Server 2005, Windows Server 2003

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

Answer Question   |  February 23, 2009  8:41 PM
Multiple SQL Server Installations, SQL Server 2005, SQL Server installation

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 device ‘\server_namedb_dump.bak’. Operating system [...]

Answer Question   |  February 23, 2009  7:54 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database

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. [...]

Answer Question   |  February 24, 2009  4:43 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS

What are basic differences between SQL Server 2000 and 2005
What is the Basic difference between SQL 2000 and 2005, thanks

Answer Question   |  February 23, 2009  11:35 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005

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 [...]

Answer Question   |  February 13, 2009  7:33 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Agent, SQL Server Agent Jobs

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 Management Studio my [...]

Answer Question   |  February 13, 2009  10:22 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server connectivity, VB.NET, Visual Basic, Visual Basic .NET

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

Answer Question   |  February 12, 2009  8:52 PM
.NET, SQL Server 2005, SQL tables

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?

Answer Question   |  February 10, 2009  9:00 PM
SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard 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 [...]

Answer Question   |  February 6, 2009  9:01 PM
SQL Server 2005, SQL Server performance, SQL Server Query, SQL Server Text Function

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?

Answer Question   |  February 4, 2009  6:30 PM
SQL Server 2000, SQL Server 2005, SQL Server performance tuning

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?

Answer Question   |  February 2, 2009  6:22 PM
SQL Server 2005, SQL Server clustering, SQL Server performance