Thats kind of what just hit me. It's worth a shot. Thanks.

This may sound stupid, and I'm starting to reach a bit here, but is it possibly because there isn't a go after the command, such as:

if exists (select * from...

Nice code Lowell, thanks. It shows my foreign keys, with the name as to what should be being dropped. Still think it's security because I can execute it in query,...

That's what I'm thinking but I don't see it. The tables and stored proc are owned by...

And from a few of our very own:

http://www.sqlservercentral.com/Forums/Topic604325-61-1570.aspx

GilaMonster (6/9/2010)

---

Fortunately I was in Isando today, not Sandton. Still, come midday whole load of people started blowing Vuvuzelas (and carried on all afternoon) and the truck drivers joined with...

Wintergreen

This is not meant as a put-down because I've inherited some pretty ugly stuff before but I still believe the design is lacking and will lead to issues somewhere along...

What if it's 11/09 and 2/10 )month and year). In reality, 11 would be the earliest and 2 would be later but you only store month???? Your design leaves some...

Jan Van der Eecken (6/8/2010)

---

The thinking behind not allowing pitchers to catch and vice versa is that the catchers do almost as much throwing as the pitchers do, and allowing...

I always associated...

Did you know they could be "hand or friction" powered? :w00t: I don't even want to know......

I can't speak for the vast majority but my nephew's league (13 & 14 years old), pitchers cannot pitch more than 10 innings over a 48 hour period. The coach...

Nyquil

My setup if the same. As far as server rights, that was a bit of a battle at first but a couple of 5:00AM calls from me stating a disk...