If anyone is interested the SQL2000 equivalent is

USE Master
GO
CREATE PROC dbo.sp_DBA_spaceused_AllTables2
@updateusage varchar(5)='false'
AS
SET NOCOUNT ON

IF @updateusage IS NOT NULL
BEGIN
-- Allow for case sensitivity
SET @updateusage=LOWER(@updateusage)
IF @updateusage NOT IN ('true','false')
BEGIN
RAISERROR(15143,-1,-1,@updateusage)
RETURN(1)
END
END

-- Retrieve the current...

I seem to remember that there is a non-documented stored procedure that runs the resultset of a query.

In some situations I do build up a string of commands and then...

Thanks for the comments Andy and Jeff. I don't get too worried about criticisms, we are fortunate enough to live in a democracy and as Voltaire said.

I disapprove of...

What do you get when you cross a sheep with a bee?

Baa Hum Bug

I've got to put up a Christmas tree, swear at the lights, murder a few carols and fight with relatives, but I will give it a go after Christmas and...

In 192.168.2.10 the octets would be as follows

1. 192
2. 168
3. 2
4. 10

Would I be correct in thinking that by using the most changing octet SQL Server is most likely to think that the...

I don't think that there is any easy answer.

One of the examples in the "Update your development skills to SQL2005" course uses a CLR datatype to hold an IP address.

I...

Thanks, but the WHERE Oct_1 IN () clause doesn't really provide an easy solution.

I can't remember the specific IP address range for the Google ROBOT but similar exclusions look for...

Our data analysts wanted to build a model that excluded IP addresses in a pretty obscure range

The problem was coming up with a simple query that would work on...

The IP Address problem is one that I am facing.

When stored as a string it is a VARCHAR(15), it is human readable but difficult to do range searches.

When stored as...

I was in two minds as to whether to submit this article to SSC. My concern was that it was a little simplistic. Given David Vaughan's response suggests...

Along time ago I came across something that said that VB always stored integers as 32 bit values regardless of whether they were Byte, Short, or Long (long in those...

I think this sort of thing can fundamentally affect the employee/employer relationship.

As an employee I have a duty of care for company resources. An employer has a duty of...

Sorry Jon, but it is a common use case in a sales order system.

You are right that the example was contrived. I did say in the article that it...

I use SET NOCOUNT ON wherever possible. There seems little point gain in stored procedures only to lose in triggers.