Thanks for the info.

Steve Jones

steve@dkranch.net

Same here. No problems, but not used extensively. Mainly because of the $$ involved.

There are some reports of problems in these forums. Searched on "named instances"

Steve Jones

steve@dkranch.net

Not that I know of, Andy?

Steve Jones

steve@dkranch.net

Don't connect in global.asa. Put the connection string there and then reference that on each page as Jon suggested.

Steve Jones

steve@dkranch.net

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