• A Smart Developer

    I have been out of touch from VB Programming for a long long time. In front of me is a task and I am ambitious about doing it in a quick & smart way. I work for a small businessman (a shop keeper) who buys Steel wireropes from wholesalers & sells it as a retailer. Currently he has a manual (cash...

    AmjadM50 pointsBadges:
  • 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

    GPNel200675 pointsBadges:
  • 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...

    Cathryn35 pointsBadges:
  • 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...

    Ajf10 pointsBadges:
  • 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...

    Sanisto45 pointsBadges:
  • 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...

    Colin Smith885 pointsBadges:
  • 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

    Ankur7715 pointsBadges:
  • 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...

    Monadba5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • VSS Backup Fails On Servers Running SQL Server 2005

    I have 2 servers running SQL Server 2005. One has Standard and the other has Express. Both are running on Server 2003 w/SP1. Since I installed SQL 2005, Backup Exec (through Remote Agent) has been unable to backup VSS on either computer most of the time, although it's occasionally worked for a day...

    Vurbal0 pointsBadges:
  • VMware ESX 2.5 or 3.0 Virtualizing SQL (2000 or 2005)

    First thanks for weighing in on this.... I support a department whose deployment of several department size SQL 2000 systems needed overhauling. I have recommended virtualizing their SQL because: 1. this is a department level database that has at best moderate use 2. It is currently and comfortably...

    GEdwards0 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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.

    Dkrueger40 pointsBadges:
  • SQL Server 64-bit Memory Requirement

    We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what...

    ITcar5 pointsBadges:
  • Migrating data from a SQL Server 2005 database to SQL Server 2000

    I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked Server Question

    I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when...

    AN5gel675 pointsBadges:
  • SQL SERVER 2000, 2005 & 2008

    Can Sql Server 2000/2005/2008 exist on the same machine

    Sdonthi5 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Investigating SQL Server 2005 memory issues

    We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following