Yes, SQL backend. It's Snitz, available under GNU license.

Andy

There are some tables in msdb. Dont know that you'll find a way to do this reliably - I often have packages sitting on the server that are only run...

Tom,

It's not that 6.5 encryption is not supported, there is just a flag that has to be set in syslogins so that SQL knows which encryption was used. I posted...

Have not seen this. What do you have for users in the db?

Andy

Put your joins in the from clause - it wont many difference for performance, but it's ANSI and other developers will appreciate it.

Andy

This works without error using SQL2K Developer Ed on my workstation.

Andy

Found this in the MS newsgroups, posted by Rich B (RBeverly@Dickies.com):

"The cause of the problem in this case was that I was

failing to provide the same settings in the...

We use a Dell Powervault, which is just EMC/DG rebranded. It shows up as a logical drive - all the set up is done through a utility provided with the...

#1 is the usual solution.

Andy

Interesting problem. Gotta ask - why would you cursor through 3 million rows?

Andy

Did a lot of testing when we got the FibreChannel. Not exhaustive by any means, but enough to see that smaller cluster sizes didnt work as well. Intel has a...

Why wouldnt it work exactly the same way?

Andy

Or even if SQL can coerce the data types to match. Biggest mistake I see with union is that most people leave off the 'ALL' - not realizing that SQL...

Is the db set to auto-close? If no activity and it shuts down, you'd see a fair delay while it reopened - plus there would be no data cached.

Andy

4k or larger should be ok. I try to use a 64k stripe on the raid sets. Even though SQL stores data in 8k pages, everything is a 64k read.

Andy