I've been around for 6+ years. I make a point of reading the newsletter every day, looking at the articles if they sound interesting and always reading the editorials. The...

Really really useful. Most of our jobs are set to move to next step on failure, so I've altered it to report on step failures only rather than the success...

Thanks for the responese. I admit that permissions and security has never been my strong point 🙂

However, I managed to port over the 2000 cubes to 2005 and alter...

I'll take a look. Luckily I have a test box for the first time in four years, so I can actually try it out without too much fear 🙂

I'm on...

I can't connect to the 2000 AS from SSMS on the 2K5 box. I haven't got Excel on the 2K5 server, but running master..xp_enum_oledb_providers shows that I've only got the...

Thanks for your response. I was under the impression that was true too. But I'm connecting from a 64 bit 2K5 box to a 2K cube on another server. Assuming...

I don't think I've ever actually had to post a question, but I've used the site and forums enough to get the answers I was looking for (usually at least...

I've not used it with text columns, but if you give your temp table a unique identifier (say an Identity field), you could try something like:-

delete a from...