i think most DBAs do this: use SQL backup to backup the database and log to physical backup file and use NT Backup of third-party s/w to backup the backup...

unfortunately I don't need to run again all DBs, just some of them. Thank you anyway.

correction: I did copy the table by right click and Import/Export, not in DTS.

We are a pure MS shop. I don't blame MS for the security holes since no vendor could say their products are perfect (acttually Oracle did!). I just...

I also admin the off site box. The account used to setup linked server has just READ permission to the tables. Thanks for your input.

OK I got it. The problem is with ELSE 0 in the update statement.

http://dbforums.com/archives/t313796.html gave me the hint.

Thanks everyone.

Hi SQL Gurus,

I made up a sample table similar to my real table. So all sripts here work as desired. However in my real table it is complicated...

Excellent post, David. I was working on a complicated cursor since my real table A has more than 100 columns with different datatypes.

Thanks.

thx for sharing. I paid for my MCSE NT4 for the exams. When Windows 2000 came out, I didn't have time to upgrade my certificate because I do...

works like a charm.

thx.

I used to get tuition compensated in the past when the certificate meant nothing to the executives. Now they want pay $100 for the exam fee , not $2000...

I used to get tuition compensated in the past when the certificate meant nothing to the executives. Now they want pay $100 for the exam fee , not $2000...

I used 1.0; and stopped using it because I didn't trust it. Don't know about existing of 1.1. Will give it a try.

Thx.

Microsoft Baseline Security Analyzer isn't accurate. It prompts me for patches that I already applied.

Hi Brian,

I set SQL memory usage to dynamic. I thought I need to do something with AWE and sp_configure.

Thx.