IF UPDATE fires if a value is sent for the column even if is has not changed. Try this:

IF OBJECT_ID('dbo.temp') IS NOT NULL

BEGIN

...

GilaMonster (11/25/2009)

---

Ok, I vote this as one of the more ... 'questionable' recommendations I've read here recently.

As your log file is very huge, and it is required to Truncate the...

I'm going to agree with Lowell and Jason on this one. Especially the part about not giving restore rights. If they restore over top of the existing database...

Great Jonathan. That's the blog post I've been working on for a couple weeks as I figure it all out:-D

I had the general idea right, just the implementation wrong.

Try this:

SELECT

*

FROM

#frUser_Copy

WHERE

[UserName] LIKE '%[^a-z0-9]%'

Unless you have a case-sensitive collation then the a-z will work for any alpha characters including...

How about something like this:

/*

Set up test table and data

*/

IF OBJECT_ID('dbo.#test') IS NOT NULL

BEGIN

DROP TABLE #test

...

What do you mean by special characters?

Glad I could help. Had to do that with some columns I was importing in one of my processes, so I had experience with it. Hope you don't...

I haven't had an issue with the "Deleted" rows in FoxPro using the OLE DB Driver. At least not that I am aware of. I'll have to double...

I'm with you when it comes to FoxPro. Have you tried doing a conversion at the source? Cast(column as new datatype). This may work. Are you doing...

I don't really know dreamweaver but it seems to me the issue must have something to do with the way you are passing the date variables. Are you using the...

Thanks for taking the steps to check on Barry, Bob. Once again a sign of community not Forum.

GilaMonster (11/24/2009)

---

Can you post the definitions of the two procedures involved (QDB_Central.dbo.uspUpdateOrgUnitAcknowledgements and QDB_Central.dbo.EnqueueMessage), the definitions of the table involved (QueueData) with all of its indexes.

Why are you using the...

Never having built a scheduling app, I'm not sure what the best way would be. I would likely do something with a structure like this:

CREATE TABLE [dbo].[calendar](

[the_date] [datetime] NOT...