I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but I still prefer to do these by myself, so here is how I do:

Always download my credit card transactions / bank statement to an Excel sheet, and then use… Read more

I got a very interesting issue, I may guess the reason but not sure why it is this way.

Symptom: Logon to a SQL Server (Server_A) through QA with Windows Authentication (my domain account Domain\JeffYao has sa priviledge), then try to run the following statement

-- the following is SQL_Statement_1
    exec… Read more

This is my first post, congrats to myself. :-)

DTS Connection object does not list "UseTrustedConnection" property

I am working on a DTS package where I'd like to reset the connection authentication from Windows to SQL Server with user id and password. I tried to search the properties under Connection object,… Read more