... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

2007-12-03

SQL Server OBJECT_ID

In SQL Server 2005, the function OBJECT_ID takes a second argument which specifies the type of the object (e.g. 'U' for user table).  It turns out that SQL Server 2000 will also accept this parameter (at least, SP3 will).  This is not documented behaviour and does not work if you attempt to compile a procedure that calls OBJECT_ID with the second parameter (you get the message 'Invalid parameter 2 specified for object_id).


Blog Archive