SQL Server

Accessing SQL Server data

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

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

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

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

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

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?

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

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?...

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

SQL Monitoring

I am just wondering what others are currently usig for monitoring and projection of databases and server? Currently I use code I wrote allong with Excel.

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

Sql Server Linked Server to iSeries

Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on...

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

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

Oracle In Linux

How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

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?

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

SQL Server DB Backups and Transaction log fileseize

I have a DB that has a DB filesize of 6 gb and a transaction log filesize of 66gb!!!! This DB has a potential for alot of growth because it holds scanned documents for retention and they are in the process of scanning in several years worth of documents from what I understand. I have my...

Defrag SQL Database

To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.

MIgrating SQL Server 2000 to Active Directory

When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working...