Ah, I'd not noticed it there - I'd been looking at it from the maintenance plan editor, where you don't appear to be able to select, only create

Ain't it always the way 🙂

Yes, the lack of support for cleaning a directory tree is a strange omission. I believe we ended up writing a tool to generate the...

Hi,

I might have missd something, but couldn't you just use a Maintenance Cleanup Task to delete old backups? That's how we have it set up here, and it seems to...

Thanks all,

more or less confirms the conclusion we reached.

Sorry for the delay in acknowledging - just got back from a week and a half holiday!

> How do you know that the DistanceFrom() operator

> can't communicate with a map server?

Now that would be fun, the first time the user does

SELECT * FROM AllHousesInUSA WHERE...

> Displaying the type will be difficult in many tools

> (probably will just show a binary)

I've not had a chance to install sql2005 yet - do the tools...

Anyone looked at the performance implications of this? For example, if we had a few tens of thousands of records in that stock table, and needed the total of both...

I remember doing this once before, and joking that there should be a 'WHEREVER' (pronounced with a rebellious female teenager accent) clause added to the language, and that or a...

Thanks,

Guess I was wrong then. How does one go about downloading these hotfixes? The MS web pages seemed to indicate you had to ask MS directly for them, but he...

Adding a wildcard didn't make much difference (cost up to 0.266), however, switching from LIKE to '=' in the second query causes it to run as fast as the first...