I work for a utility company. We have 18 SQL Server servers running 25 instances, 42 Oracle servers running 58 instances, and ADABASE on the mainframe. There are...

Thank you for both of your comments. I will be doing this with VB. Going with .NET.

Thanks again,

Joseph

The system is being designed to share documents accross the corporation and have a sync process. The hardware setup and design is out of my hands. I have...

Thanks for replying.

I was hoping someone finally found a simpler method for monitoring software and databases.

With only 3 of us DBA's, it is hard to research...

Andy,

We use "What UP" for our enterprise monitoring. You said "low tech". I would be interested if you have an suggestions on "high tech" options that...

Use the IMPORT/Export featrue in SQL Server 2000.

1) First the "to" database needs to exist.

2) From "all tasks" select export

3) Choose your source/destincation

4) Copy objects and data between SQL...

One point I have not seen, is that how well Oracle and SLQ Server work depend largely on the people involved.

You have to have people that know what...

Thank you all for you help. I have a solution coded and working. I went with reading the csv into a record set, processing the information into a...

Thanks,

So, I process the *.csv file into OPENXML file, that can be passed into a SQL Stored procedure.

I will try this. If any one has code snipets (vb and/or...

Thanks for the suggestion. I plan on doing the cutting up of the file(s) on the vb side.

I was looking for more efficient way of processing the records into...

Look at the responses to 'devereauxj'. I just posted the same question.

Joe

Thanks you for all the advice. I have to wait until Tuesday morning to try this (24x7)production server. I will post the result.

Joe

The SQL Agent was stopped and is not reporting "Could not start agent... Service did not return error... could be windows error or internal service error... contact admistrator."

I tried running...

Yes, the SQL Server Agent is running.

Thanks for all your help. It ended up being permissions problem with a domain user.

thanks

Joseph