• 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:
  • 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:
  • 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:...

    Ronjar0 pointsBadges:
  • 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 couple of minutes all throughout...

    Zannemarie0 pointsBadges:
  • 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...

    Bakash0 pointsBadges:
  • 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 easy it was. All...

    UselessOne0 pointsBadges:
  • 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...

    Findit0 pointsBadges:
  • 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

    DWolfe0 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