SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2005

Let database work for your daily life

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

0 comments, 1,318 reads

Posted in DBA Philosophy on 11 September 2005

about xp_sendmail

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

0 comments, 1,341 reads

Posted in DBA Philosophy on 9 September 2005

one issue about SQL 2000 BOL

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

0 comments, 1,331 reads

Posted in DBA Philosophy on 8 September 2005