I have tried to find a way to do this, too, with no luck so far. I ended up wrapping the sp_add_job command in a try-catch block.

Ron Rice

There doesn't seem to be much rhyme nor reason to the isnumeric() function. I don't have SQL Server 2000 nearby to test it, but in 2005 I ran this script and...

That would be sweet, as would a way to alias server names, and even table and column names, so that four-part notation could read: select * from @server.@database.@table.@column.

There...

OK... I'm new to this forum, and happy to see it isn't ... boring!

It would be great to do away with nulls altogether, especially since the ANSI committee in their...