Try this:

alter table clients

Add SceneFlag [char](1) NOT NULL DEFAULT 'Y'

😎

If you post your current DELETE code, I am sure that there are individuals out here who help you modify it to delete small batches and thereby control the size...

I'd have to agree with Steve. I actually enjoyed every IT position I have had to date. Things got really bad at my last employer during that last...

I have used sql_variant in a database I was using for data analysis of data stored in a database. The only thing I couldn't store was blob data, or...

blandry (7/8/2008)

---

...As for the explanation of Inner Joins themselves, the article is very basic and though for some that might be helpful, it was not very "real world" and did...

Between Turkey Week 1989 (Thanksgiving Week in the US) to August 1993, I drove 90 miles one way to work 5 days a week. Left the house at 6:00...

orrego.cesar (7/8/2008)

---

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition to...

And this site is used internationally by many others than just us American's. We...

Jeff Moden (7/7/2008)

---

Marios Philippopoulos (7/7/2008)

---

2) Are you allowed to use sp_OA* procedures?

I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, and...

From BOL regarding the INSERT statement:

😎

Here's something, could the working trigger be interfering with the trigger that isn't working? Have you tried disabling (or deleting) the working one to see if the one you...

Though I didn't respond to your original post, I assure you, not a problem. Sometimes asking for help is all it takes. In asking for help, you had...

Yep! That's why I tried the logical exercise. Pretty much helps put it in perspective though.

😎

GSquared (7/3/2008)

---

Adding the Exists command seems to me to be unnecessary in any case. Will it actually resolve the lack of such rows more efficiently than the Delete command...

Way back in the days of Novell, didn't their Novell Certified Administrator require that you have at least one year experience before awarding the cert, and your company had to...