• compare 3 columns

    i have 3 tables table1 has the column id1 with three values in it '1','2','3' and table2 has column id2 with three values '3','4','5' and table3 has column id3 with three values '5','6','7' how do i join all the three tables, and i also want the null value to be displayed.pls go through the example...

    harish978920 pointsBadges:
  • SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • How to compare fingerprint images in VB.NET

    I'm working on FINGERPRINT RECOGNITION SYSTEM. I'm using VB.NET as front end and SQL Server 2000 as back end. I had saved fingerprint images in sql server using image datatype, now I need suggestion on how to compare fingerprint images.

    Dlfshweta5 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005

    What are the Basic difference between SQL 2000 and 2005? Thanks!

    Amin4rmOvexTechnology250 pointsBadges:
  • Advantages of SQL Server 2005 over SQL Server 2000

    What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Updating the database using information_schema in SQL Server 2000

    I am having database a and b. I want to update database a according to adaptations in database b. b is same as a operations are done on b database and after completion a will get updated for permanent change? How can I do this automatically by using information_schema in SQL Server 2000

    Mcm5 pointsBadges:
  • Linked SQL Server problems

    I have 2 servers. Server 1 has SQL 2000 (SP2). Server 2 has SQl 2000 + SQL 2005 (sp2). I'm 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 a linked server to SQl 2005, I get...

    KH155 pointsBadges:
  • How to restore SQL Server 2000 backup file

    How do I restore a SQL Server 2000 backup file?

    Nareshaswal5 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 pointsBadges:
  • How can I make backup 4 file only and restore in SQL Server 2000

    How can I make backup 4 file only and restore in SQL Server 2000?

    01058478505 pointsBadges:
  • The specified module could not be found

    We are trying to install a software (on about 70 workstations) that uses a SQL type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...

    Kc54555 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime). I get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results? Thanks.

    DBM10 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Connectivity with Developer 2000

    Hi friends, I am using d2k as front end and for back end. I want to use my SQL Server 2000 data. How can I connect it? Thanks!

    Amitd15115 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • Planning to move data on new database server?

    Well I'm working in MNC as a network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to separate database server & application if any body has a plan or he/she know how move...

    Ravijoshi2020 pointsBadges:
  • Making a WAN

    Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ (head quarter) - HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server 03  +...

    PRINCESS85 pointsBadges:
  • Need to upgrade SQL Server

    Hi, Right now my database server running on SQL Server 2000 & my application is also running from the same server for heavy load on server. I'm going to separate my database server & application server. I need help because my database size is all most 3 GB. Also I need to upgrade my...

    Ravijoshi2020 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.

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

Following