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 failing. Turned [...]
Answer Question
| July 18, 2005 8:49 AM
SQL Server, SQL Server 2000
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 failing. Turned [...]
Answer Question
| July 18, 2005 8:49 AM
SQL Server, SQL Server 2000
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,
Answer Question
| July 1, 2005 3:00 PM
Development, Programming Languages, Software testing tools, SQL, T-SQL
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,
Answer Question
| July 1, 2005 3:00 PM
Development, Programming Languages, Software testing tools, SQL, T-SQL
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 10years [...]
Answer Question
| June 20, 2005 8:05 AM
Database Management Systems, DataCenter, DB2, Desktops, Hardware, IT architecture, Networking, Oracle, Servers, SQL Server
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 10years [...]
Answer Question
| June 20, 2005 8:05 AM
Database Management Systems, DataCenter, DB2, Desktops, Hardware, IT architecture, Networking, Oracle, Servers, SQL Server
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 well – on [...]
Answer Question
| June 14, 2005 11:09 PM
ASP.NET, Microsoft Windows, T-SQL, VB.NET
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 well – on [...]
Answer Question
| June 14, 2005 11:09 PM
ASP.NET, Microsoft Windows, T-SQL, VB.NET
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 [...]
Answer Question
| June 13, 2005 10:27 PM
Development, Software Quality Assurance, Software testing, SQL, T-SQL, Tech support
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 [...]
Answer Question
| June 13, 2005 10:27 PM
Development, Software Quality Assurance, Software testing, SQL, T-SQL, Tech support
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 codes or blank plan codes. How [...]
Answer Question
| June 19, 2005 3:50 PM
Development, Software Quality Assurance, Software testing, SQL, T-SQL, Tech support
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 codes or blank plan codes. How [...]
Answer Question
| June 19, 2005 3:50 PM
Development, Software Quality Assurance, Software testing, SQL, T-SQL, Tech support
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, each with two processors. Please offer [...]
Answer Question
| June 8, 2005 3:33 PM
Database Management Systems, Hardware, Servers, SQL, SQL Server, Storage, Windows 2000 Server
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, each with two processors. Please offer [...]
Answer Question
| June 8, 2005 3:33 PM
Database Management Systems, Hardware, Servers, SQL, SQL Server, Storage, Windows 2000 Server
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
Answer Question
| May 27, 2005 12:22 PM
Oracle, SQL, T-SQL
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
Answer Question
| May 27, 2005 12:22 PM
Oracle, SQL, T-SQL
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 [...]
Answer Question
| May 25, 2005 8:10 AM
SQL Server, SQL Server 2000, T-SQL
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 [...]
Answer Question
| May 25, 2005 8:10 AM
SQL Server, SQL Server 2000, T-SQL
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 [...]
Answer Question
| May 16, 2005 1:23 PM
Database Management Systems, Linux, SQL Server
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 [...]
Answer Question
| May 16, 2005 1:23 PM
Database Management Systems, Linux, SQL Server
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 disconnected from other databases Thanks in advance.
Answer Question
| May 16, 2005 12:09 PM
Backup & recovery, Database Management Systems, Security, SQL Server
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 disconnected from other databases Thanks in advance.
Answer Question
| May 16, 2005 12:09 PM
Backup & recovery, Database Management Systems, Security, SQL Server
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 [...]
Answer Question
| May 9, 2005 6:12 AM
SQL, SQL Server
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 [...]
Answer Question
| May 9, 2005 6:12 AM
SQL, SQL Server
SQL Server Restore history (last restore date)
I am trying to find when the last time a database has been restored. We have several SQL servers. I have formed the following query based on an article I found. It worked great on the first one I tried, but wasn’t recent enough. When I tried to go to other servers looking for a [...]
Answer Question
| April 18, 2013 2:57 PM
SQL Server
I am trying to find when the last time a database has been restored. We have several SQL servers. I have formed the following query based on an article I found. It worked great on the first one I tried, but wasn’t recent enough. When I tried to go to other servers looking for a [...]
Answer Question
| April 18, 2013 2:57 PM
SQL Server
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 VARIABLE length, I do not know [...]
Answer Question
| April 26, 2005 4:40 PM
DataCenter, MySQL, Oracle, SQL Server
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 VARIABLE length, I do not know [...]
Answer Question
| April 26, 2005 4:40 PM
DataCenter, MySQL, Oracle, SQL Server
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
Answer Question
| April 4, 2005 10:02 AM
ColdFusion, MySQL, SQL, SQL Server
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
Answer Question
| April 4, 2005 10:02 AM
ColdFusion, MySQL, SQL, SQL Server
REPORT WAIT TIMES
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
Exporting Data to Text/CSV file in SQL Server 6.5
Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti
Answer Question
| March 24, 2005 3:37 PM
Database Management Systems, SQL Server
Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti
Answer Question
| March 24, 2005 3:37 PM
Database Management Systems, SQL Server
SQL Trigger to create .csv file
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every [...]
Answer Question
| March 30, 2005 2:32 PM
SQL, SQL Server, SQL Server 2000
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every [...]
Answer Question
| March 30, 2005 2:32 PM
SQL, SQL Server, SQL Server 2000
Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]
Answer Question
| March 24, 2005 10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]
Answer Question
| March 24, 2005 10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
Urgent!Please help: TOP 3 cities only returned based on count() – result
I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table: cityid, cityname Restaurant-table: restaurantid cityid countryid isactive Only [...]
Answer Question
| March 30, 2005 3:04 PM
SQL, SQL Server, SQL Server 2000
I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table: cityid, cityname Restaurant-table: restaurantid cityid countryid isactive Only [...]
Answer Question
| March 30, 2005 3:04 PM
SQL, SQL Server, SQL Server 2000
