That was what I suggested.

The evaluation of null is performed differently in 2000. Its more in line with VB now. For years Null was treated as a value, while in...

Good Proc.

Documented and NO CURSORS unless absolutely neccessary.

Simple concepts, but you'd never believe how often they're thrown out the window.

removal of temp objects, cursors, sort or hash tables, will all cause these clean up tasks to occur. What are you trying to determine? Do you have a high...

Here's what I use for my dumps.

Full dump scheduled 1/day around midnight.

declare @v-2 varchar(250)

select @v-2= '\\BackupServer\MSSQL\BackUps\' + 'MKDB_DB' +

convert(varchar(6), getdate(), 12) +

convert(varchar(2), getdate(), 108) +

substring((convert(varchar(19), getdate(), 100)), 18, 2)

dump...

Select * from Table where email field is null.

What kinds of errors? even if you did it with = null, it wouldn't give errors. How are you going about it...

It looks like a security isssue. With the errors complaining about not being able to execute 'sp_MSadd_repl_commands27hp' on 'TPNPRD01', I'd say it either doesn't have the right securities, or cannot...

What happens is this:

START SNAPSHOT GENERATION

1. Scripts are created on every object involved, and written to a directory on the local drive.

2. Data files are created holding the data from...

I both agree and disagree with David. He's absolutely correct about technical people not needing to be running the company. However, Even the highest CEO in the company had better...

That is actually the most realistic view of the corporate system I have seen in 16 years of contracting. Its too bad that its not easier to get everyone in...

That's one of the few redeeming qualities of being contract. You get to experience such a WIDE array of issues.

That is excellent.....I can't wait to test it out myself....

I've seen a couple issues like this. In one, as burthold mentioned, it was cheap cable (only 76% shielded) picking up RF frequencies.

The other was an incorrectly terminated channel,...

With Fullscan does not affect rowcounts.

Working with a 100,000 row table of numeric values, and examining the execution plan, Here's what I find.

Select a,b,c,d ...

SO, all together, going that route, it took about 4 minutes? That seems MUCH more inline with what I would expect. Did the transaction log still show the huge amount...