• T-SQL, and cascading updates or finding constraint names

    Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every...

    Sonotsky695 pointsBadges:
  • Accessing SQL Server data-2

    I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

    As400guyone0 pointsBadges:
  • Database choice for web application

    I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be...

    JacobSCracker0 pointsBadges:
  • TopIndex property for .NET Web ListBox

    I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...

    Nohemi0 pointsBadges:
  • SQL server developer

    Is a server required, or can this be installed on XP Pro.

    Shasta880 pointsBadges:
  • Accessing SQL Server data

    I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

    As400guyone0 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:
  • SQL Website

    Hello again. We have an internal web server that is built using SQL Developer 2000. THis is on our DMZ on the firewall. we can not link to it from our internal network to transfer data to the sql tables. to test i opened all traffice between dmz and the internal network to test and no success. is...

    Schuit0 pointsBadges:
  • Query Analyzer editor pane/window size

    When I start Query Analyzer the Editor/Query pane defaults to smaller window size than maximized. Is there some way to force the Editor/Query pane window to open maximized?

    ByteMan0 pointsBadges:
  • How to purge records from the database?

    I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...

    Jinisha0 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:
  • How do I check for changes in a database on insert / update?

    Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in...

    Scooby0 pointsBadges:
  • Calling a Function which uses ado command object in ASP

    Hi... I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. can u help me plz?...

    RKPatel0 pointsBadges:
  • Upgrade from MS SQL Server 6.5 to SQL 2000 Fails

    The upgrade process using Microsoft "SQL Sever Upgrade Wizard" fails at the "Import and Export via Named Pipe" part. With the following Error: Starting MSSQLServer............................... Waiting for recovery. Sysmessages # 4002 [Microsoft][ODBC SQL Server Dirver][SQL...

    HenryKafeman0 pointsBadges:
  • ORA-03113 error while compiling Oracle packages

    Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and...

    Boball0 pointsBadges:
  • web site built on sql server

    hello we had a person develop our website using sql server. we want to transfer that to an in house server and host our own website. the webserver is in our dmz zone off of our firewall. the sql server is on the same machine. we can not connect to the sql server to update data from our internal...

    Schuit0 pointsBadges:
  • Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

    We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files...

    Onilke95 pointsBadges:
  • SQL Server ODBC Configuration

    I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

    Rmartinez780 pointsBadges:
  • MS SQL Server 2000 and memory management

    I'm wondering why memory management even, in the newest versions of MS SQL Server (e.g SQL Server 2000), seems to be working very poorly. I'm facing problems with memory usage in a 5-10 user environment (3-4 simultaneous users). An VS.NET based application (iScala) is being used during working...

    KajBre0 pointsBadges:
  • database server needs to be reloaded with software but database is intact

    We have an intact database but lost the server. What method can we use to reestablish the database to the SAP database server?

    BasisDBA350 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