System Table in SQL2K

It's interesting to have an "system" table declaring itself as a user table in the ANSI INFORMATION_SCHEMA views.

This message pointed out the findings while checking the system table "dtproperties"
microsoft.public.sqlserver.security | Google Groups

Restarting my pro blog

hello to the new blogger.com

I plan to blog again.
It seems the blogger does improve...

during the past year, there are several changes hit me much.

1. I was once away from development jobs.
2. I was jumping from in-house IT to software house.
3. I was leaving my lovely colleagues
   
4. I was off working on time before but now I kept working OT every day.
   

Nullable DateTimePicker

The DateTimePicker winform control in .NET v1.1 doesn't accept null value, so I surf and find this replacement:

Nullable DateTimePicker
http://www.codeguru.com/Csharp/Csharp/cs_controls/custom/article.php/c9645/

So far it works fine, in general.
As it's written in C#, I have to compile it to class library for my VB.NET project.

MSN Spaces MetaWeblog API

Just forgot to blog this
MSN has started its support to MetaWeblog API.

I would give it a try during the coming holidays. = =+

Check this: MSN Developer Center: MSN Spaces

DTS Bug: Fail to report error message by RAISERROR

I'm so unlucky to hit a bug again~

M$ claim it was fixed since SP4.
FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR

The above page said it can be solved by the security patch of SP3.
I've tried but SP3 actually didn't fix it. The patch even doesn't include update file for the DTS library dtspkg.dll.
SP4 does update the DTS runtime.

However the bug is still here after patching, if I use global variable as the SP input parameter