Hmm... well I *think* that's probably good, but on the other hand if it's intermittently misbehaving that's not good. Thanks for keeping me up to date. Let me know if...

Thanks for the positive feedback. I'll keep you guys updated with what's happening. I guess it probably makes sense for me to post announcements here since there seem to be...

Hi everyone,

Sorry for the delay in responding to you, although in my defence I will say this is my second attempt. My first attempt was swallowed up this morning by...

Now that's a great car! Shame they're £800,000 otherwise I'd definitely get one (yeah, right - maybe if the price dropped by two orders of magnitude).

Fastest thing I've ever driven...

Just open a new query window in SQL Server Management Studio and execute the command. Easiest way is to type it in, select all the text and then hit F5.

In response to Anthony, and in addition to Simon's comments, I'd also like to apologise for the delay in releasing SQL Prompt 3. A public beta is now available and...

For crying out loud, can't you do your own homework?

I'm going to be spat on for even suggesting this, but is it possible you could create a CLR data type with a list-like interface that you could use for...

Having worked in small town IT for a while I'd have to say that whilst it sounds ideal in some senses the reality can actually be pretty far removed from...

Depends what you mean by monitoring. Quest and Imceda both offer monitoring products for SQL Server. Of the two I probably preferred Quest's because the interface is both funkier and...

I have them both on my development machine and they play quite happily together, but as Ian has said I'd make sure 2000 went on there first.

Yep, as said above really, this would more than pay off the investment of a few hours of your time, and tSQL's really not that hard. You can also find...

You shouldn't need to do a cast at all in general. For example:

DECLARE @fp MONEY

DECLARE @i INT

SET @fp = 2000.00

SET @i = @fp

will work fine.

If you run SELECT @fp after...

If you're updating an Oracle database the problem might lie there: I'd say as a first step you should check out what indexes (if any) are defined on the tables...

Yeah, I don't think you can actually get at the DDL for tables because they're not "text objects", unlike SPs, functions etc. You can (shameless plug) use a tool like...