• Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Crystal Reports – Rounding Nearest 1/8 Mile

    I'm trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?

    Sarahtaj5 pointsBadges:
  • How to roll back service pack in SQL server 2005

    HOW TO ROLL  BACK SERVICE PACK IN SQL SERVER  2005 

    Venkatdbait35 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 pointsBadges:
  • Automatic backups for production databases without taking SQL server offline

    I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

    ITKE366,410 pointsBadges:
  • How to migrate a database from SQL Server 2000 to SQL Server 2005

    Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?

    SQL Server Ask the Experts2,585 pointsBadges:
  • File backups for Windows server 2003

    What files should we be backing up across all of our windows 2003 servers? Is there a list of what should be backed up to restore the entire system if a disaster occurs?

    ITKE366,410 pointsBadges:
  • SQL Server 2005 Performance

    1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?

    Rick Martinez585 pointsBadges:
  • Error when trying to restore SQL Server database backup file

    We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we have no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database Log File sql server 2005

    We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the application...

    Rick Martinez585 pointsBadges:
  • How to export excel data to Sql server 2005

    How to export excel data to Sql server 2005

    Rasheed1802075 pointsBadges:
  • steps for accessing sql data through ado.net code over LAN NETWORK

    steps for accesing sql data through ado.net code over LAN NETWORK

    Jib35 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • Transactional Replication: Publisher & Subscriber size mismatch

    Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however...

    Test1215 pointsBadges:
  • Scheduled job for Oracle 9 returning ORA-01858

    We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...

    OracleATE190 pointsBadges:
  • Log In then Output the Data of the Logged Person C# SQL 2005

    I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear...

    C1a4h15 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000

    HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

    ETHMAN55 pointsBadges:
  • SQL Server 2005 Log Shipping question

    I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server - it seemd to stop working for a period of 2 weeks (I dont know why - I could not login to it...

    Lorelei10 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • AS/400 SQL Procedure call from CL program

    I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.

    Burmanr10 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