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 [...]

Answer Question   |  December 2, 2007  12:52 PM
Memory leak, SQL, SQL Server 2000

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 through [...]

Answer Question   |  December 2, 2007  6:02 AM
Networking, SQL Server 2000

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

Answer Question   |  November 2, 2007  9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005

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

Answer Question   |  October 29, 2007  11:10 AM
Query, SQL Server 2000

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

Answer Question   |  December 2, 2007  10:07 AM
SQL Server 2000

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,

Answer Question   |  November 2, 2007  8:45 PM
Enterprise Manager, Password, SQL Server 2000

sql server 2000
i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

Answer Question   |  May 23, 2008  11:37 AM
SQL, SQL Server 2000

SQL 2000 to Yukon Migration
Posted on behalf of Kilaru: We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it [...]

Answer Question   |  May 23, 2008  9:32 AM
Exchange Server ActiveSync, HTTP, SQL Server 2000

SQL Server 2000 (Performance Trace)
Hi All, I have a job which is running since last 6 months. The job was taking around 2-3 hrs to be completed. However, for the last couple of weeks, its taking more than required time (Max-26 hours)and we have to kill the job for users to acces the database. I am not able to [...]

Answer Question   |  October 8, 2008  9:56 AM
SQL Profiler, SQL Server 2000, SQL Server performance

Moving from single server to multiple servers
Hi all, We have a Single Windows 2000 server (Back office edition, configured as a Primary domain controller). It has SQL server 2000 running, which serves a bespoke database application. The server is also used as a simple fileserver for documents, etc… We do not use Exchange Server. I need to have a way to [...]

Answer Question   |  August 22, 2008  11:41 AM
Backup & recovery, Backup servers, NAS, SDSL, Server migration, Server upgrades, SQL Server 2000, SQL Server 2003, Windows 2000 Server, Windows Server 2003

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)+ [...]

Answer Question   |  July 25, 2005  3:44 PM
SQL, SQL Server 2000

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 [...]

Answer Question   |  July 25, 2005  3:16 PM
SQL, SQL Server 2000

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

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

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

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

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

Database comparison
I know this is ‘cheating’ but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp’s etc. I think this can be done using systables, however i was wondering if anybody had done this and how [...]

Answer Question   |  March 10, 2005  4:21 PM
Database, DB2, Oracle, SQL Server, SQL Server 2000, T-SQL

Can’t register remote SQL 2000 server
We have fresh installs of XP Pro SP2 on several workstations in the same site and the same subnet done not from the image. We want to use TCP/IP to register the default instance of SQL 2000 server located behind the firewall, not in our site. Some of workstations have no problems registering the SQL [...]

Answer Question   |  January 3, 2005  5:36 PM
Security, Servers, SQL Server, SQL Server 2000

Accessing MS SQL Server DB from iSeries
I am trying to find a way to execute a SQL statement on the IBM iSeries and access info in a MS SQL Server DB that is on a different server. Can someone point me in the right direction to find any info on this?? Thanks, Dave

Answer Question   |  December 20, 2004  4:16 PM
AS/400, i5, iSeries, OS/400, SQL Server 2000