• Replication in SQL Server 2005 deleting records

    We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second pass. We think...

    Getmygto5 pointsBadges:
  • Upgrading two instances of SQL 2000 running on the same SVR to SP4

    I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I'm sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem is...

    Cridgy35 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??

    JimmyIT1,725 pointsBadges:
  • sql server 2000

    i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.

    Css10 pointsBadges:
  • how to run sql server 2000 on terminal which is logged on as user having limited rights

    how to run sql server 2000 on terminal which is lgged on as user having limited rights

    Css10 pointsBadges:
  • SQL Command

    I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ' : '+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in...

    283036050 pointsBadges:
  • Automating an application

    I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I do not know how to use it....

    Karibu5 pointsBadges:
  • Upper limit for numeric fields

    What is the maximum numeric field length for Visual Basic Applications running on SQL 2000

    Mozie10 pointsBadges:
  • Merge Replication

    How To Create Merge Replication in SQL Server 2000. There Are 20 Subscribers

    Abhaykumarpatel10 pointsBadges:
  • vb.net appilication not running a in network

    Hellow All I have developed a small appilication in vb.net 2005 with sql server 2000. the appilication is running in a machine is ok. but when i am going to access the appilication through another machine in the network is not running. How can I solve this problem please help, Thanks

    Sowmi ssk5 pointsBadges:
  • Clustered indexes

    Why can only once clustered index be created on a table ? What is a row locator?

    Satya teki0 pointsBadges:
  • 7 SQL Servers working seperately need joining.

    I am working in small bank with 6 branches and a Headquarter. Each Branch is running a SQL server with 8 workstation connected to it over LAN. At each day end branches closes their work send their data to headquarter in an export file format. Where it is imported to Headquarter Sql Server database...

    Naveed Khan0 pointsBadges:
  • MS SQL 2000 memory leak

    Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that...

    Alexandria0 pointsBadges:
  • how do i resolve two conflicting msde instances?

    I have installed a second application that uses msde (ms sql server 2000) but during installation the installer found an existing msde db. when I try to use the 2nd application, it tries to log on using a different password, unsuccessfully. Does anyone know how to create a seperate msde instance...

    Phil in Camas20 pointsBadges:
  • How to create a user login and password in Enterprised Manager in SQL server 2000

    Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,

    Tian81680 pointsBadges:
  • Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 pointsBadges:
  • How to write the query

    How to write the query from one table.(i don't want first row and second row)

    SQL Server0 pointsBadges:
  • COMPARING CELLS IN SQL

    My database KoloID FIRST SECOND THIRD FORTH 01 4 8 6 10 02 10 8 12 9 03 4 5 6 9 04 3 6 6 9 ETC How can I use select to return P,P1, P2,... P10 ETC P = relationship between values of the last koloId(04) and koloID(3) = Number of cell with the sam values = 2 (6 and 9) P1 = relationship between values...

    Ajibola110 pointsBadges:
  • COUNT IN DATABASE

    My database NumberId jb1 jb2 jb3 jb4 jb5 jb6 01 1 2 0 5 7 9 02 2 2 2 1 0 9 03 0 2 1 6 6 7 select( cast(case when jb1 = 1 then '1' else '0' end as int)+ cast(case when jb2 = 1 then '1' else '0' end as int)+ cast(case when jb3 = 1 then '1' else '0' end as int)+ cast(case when jb4 = 1 then '1' else...

    Ajibola110 pointsBadges:
  • SQL backups failing

    All of a sudden some of our SQL backups are failing with this error: Operating system error 64(The specified network name is no longer available.). These backups are being written to a different server, then backed up to disk. To rule out DNS issues, I changed the failing ones to use IP. Still...

    BRNeyes0 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