• Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 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:
  • Upgrade to SQL Server 2005 sooner or later?

    Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...

    RobynLorusso230 pointsBadges:
  • import exchange mail log into SQL 2000 personal edition

    i am trying to import the exchange log (in servername.log) to sql2000 for filtering purposes but keep on bumping into error "column delimiter not found". please help

    Faisalsusanto0 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:
  • DB2 function

    Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,

    Meenac0 pointsBadges:
  • Number Crunching Machines

    I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I'm not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400's now for...

    Neilm1m0 pointsBadges:
  • exception join

    SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either invalid plan...

    Meenac0 pointsBadges:
  • ASP.NET performance degradation

    I'm running ASP.NET 1.1 on a Win2k server, application is written in VB.NET, with SQL server 2000 db on another box. ASP.NET application has very large pages with very complex data filled controls, but is only used on an Intranet by a small number of people. When users initially login, it performs...

    Infrastructure328080 pointsBadges:
  • calculation at database level

    Hi! I will really appreciate help. Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to...

    Meenac0 pointsBadges:
  • SQL Clustering

    SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode,...

    Krismop0 pointsBadges:
  • Oracle query to count rows in tables

    Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike

    Mikron20 pointsBadges:
  • Integrating Connect:Direct with Sql Server DTS

    Don't know if any body has managed to - but i need to start a C:D process from within a DTS script. all the components are working independantly - however DTS waits indefinitely for the C:D process to finish - it does not seem to receive the return code. (or process it properly) Any Help/ideas much...

    UselessOne0 pointsBadges:
  • Spaces in Linux is getting Interpreted as ‘@’

    Hi All Need some help. I use the BCP out command to transmit data from SQL Server database table and send it to flat files. The spaces (varchar datatype in table) gets transmitted as spaces only. When I use Linux command to get these files, out of 20,000 spaces , 1 space got interpreted as '@'. Can...

    Bakash0 pointsBadges:
  • Automatically Force User Disconnects via Scheduled Script

    Greetings all ... What is the most efficient automated script-based approach to terminate user connections for "particular" databases? Where: 1. Know name of database(s) 2. Know name of user(s) 3. Do not know name of user(s) 4. Server must always remain in production and user(s) must not be...

    Ericggordon0 pointsBadges:
  • Counting Problem – SQL Server 2000

    Counting Records - SQL Server 2000 I need to count rooms sold. The problem is that a room can be sold more than once for any given trip. How can I retrieve all records including one instance where the room has been sold multiple times on a given trip? Example: Inv. Trip Room 1 A50805 201 2 A50805...

    Mpatdweb0 pointsBadges:
  • Removing spaces between two words in SQL

    Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname 'space' lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function "substring" but since the firstname can be of...

    Kpatel0 pointsBadges:
  • sqlserver 2000 stored procedures

    Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

    Andy119830 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