Never tried this. I do all the DTS work. I'll take a look.

One thing off the top of my head is to save as a COM file and allow someone...

I like Jon's idea.

Steve Jones

steve@dkranch.net

Two ideas,

1. Use a temp table/table datatpye to loop through the time interval and count each time,

2. Build a temp tabel of ten minute intervals. Join this to your...

BTW, thanks for removing the sa login

Steve Jones

steve@dkranch.net

Can you connect from ISQL/W using this login and execute the stored procedure?

You might also run SQLTrace and see the exact call. Perhaps there is something you are not noticing...

Personally, I vote for people skills first. Can't really teach those, I can teach all teh SQL stuff. Of course, the skill level depends on how motivated I am to...

I have a standard test as well. I had an article on it (maybe still do). I used to get some really funny things as well.

What was really amazing to...

Be interested to hear. We have been all W2K except for the PDC/one BDC for over a year. We love 2K, but have been hesitant to take on the migration...

The Bell Curve just shifted again!!!!!!!

Steve Jones

steve@dkranch.net

memory leaks are this biggie. Load is another. This is overhead that is better spent somewhere else as your server gets busy. I'd hate for my database server to be...

I'd recommend DTS, but I used this with SQL 7 early on in its life.

Script out all objects from v6.5 (EM does this)

Run script on new server

Had script to BCP...

Whew, not sure if you can get the db without the log.

I think you need to recreate the database with a blank file (using the GUI). Then shutdown the server...

I like the article. We need a standard view of our jobs for it to be more accepted in all industries.

I think that the production DBA should report to an...

I'd always leave it to users to change things, but try to standardize whereever possible for storage. especially for loads of data from an external source.

Steve Jones

steve@dkranch.net

I think you need 3 environments at a min. Prod, dev and a QA/staging area. Refresh QA and test before moving changes to production. Reffresh dev rarely and be sure...