Cool! I like your way to move to a migrate from one server to another. It also reminded me of why we didn't try anything like that the...

The way I would use, since I know almost nothing about ActiveX (although I plan to try Paul's way), is to set up the two connections to send to a...

We have upgraded servers a number of times and the quickest way I know is to backup a database and restore it on the new one. Using DTS or...

I've begun learning VB and have noticed that the queries sent to SQL Server are the same as if I created them in Query Analyzer. Hopefully, all the languages...

You mean there is nothing similar to DTS packages in Oracle? Then how do you get data in and out of Oracle? Can the process be automated like...

I didn't realize that once one machine is hit it can go through that buddy list to another. I planned on limiting my AIM to my buddies only and...

One technique I use to try to avoid deletes or updates when highlighting only a portion of a query is to use table aliases and always include a FROM clause...

We currently use SQL Server 7.0 and our company is considering upgrading to SQL Server 2000 or to Oracle. I have heard a few things that I like about...

I forgot to post an invitation for others to add your own learning experiences here. Please add experiences you've had that taught you a valuable lesson about being a...

Often it is beneficial that people think I am busy as I can then focus on a task and complete it. However, I am always able to break away...

I sometimes help our network department and give minimal support for our researchers with the VB app. Usually the VB support is when none of our VB programmers are...

I just hope the switch to using various languages doesn't all happen at once. I consider myself a quick learner, but trying to learn many different programming languages at...

I have approached a similar problem differently (due to my lack of knowledge about any other way). I need to get a different file each day to import the...

Correct, I am using a shared directory on our FTP server. Forgive me for not realizing that would be an important fact, however access to the share is limited...

I create scripts for all objects and include the granting of permissions in the script. Then I execute the script in our testing environment. I modify the script...