If you get a chance, check out a site that I just stumbled across earlier this week. It exposes email punctuation substitution techniques that I believe you would find...

There are several products "out there" to do comparisons of both structure and data. I'll agree with Norene that Red Gate is a good product, but I've also checked...

OK. I'm an idiot. I forgot to put in example usage.

select dbo.checkspelling('blah') -- Returns 1 (success)

select dbo.checkspelling('blahh') -- Returns 0 (failure)

Sorry 'bout that...

Ken

Try this. You'll need Word installed on the machine you're running this on. It works but it's [slow].

Cheers,

Ken

CREATE FUNCTION dbo.CheckSpelling (@checkword VARCHAR(50))

RETURNS BIT AS

BEGIN

DECLARE @w...

This may not help much but I recall reading somewhere that specific DTS jobs may change the recovery model. I wish I could offer more or at least be...

SLBt

As you may know, sp_executesql implicitly converts [whatever you send to it as a statement] to NTEXT. While you can't declare a local variable as NTEXT, you -can- declare...

Elise

You may want to research triggers in the SQL BOL. Also, here's another link that may or may not be helpful:

http://www.databasejournal.com/features/mssql/article.php/3489111

I'm not sure what the performance will...

Mike

I'll only admit I ran into the error before .

Definitely either scheduled backups and virus scanning [will] cause this error. Depending on the scanning package, you may have trouble...

Re: maybe it's you.

ouch.

That really hits home for me too. I agree with Del (above). I have a short list of developers that I actually consider savvy enough to build solid...

outSTANDing!

Congrats, Frank. Excellent news on the "career" and "home" fronts. Best wishes for more successes on the "career" side and plenty of good times on the "home" side.

I...

I've used SQLCheck and for the price, it's great. I found it to be a [bit] doggy as far as data refreshes but that could have been as a...