Not per se. The thing is, you need to be very careful about how you manage security. If you give a role blanket execution priveleges, then you may need to...

OK. You may or may not want to continue the existence check. From what I can see though, I think you could skip it. It looks like you're doing a...

I volunteer to continue processing beer to lager as time & money allows. I know it's a sacrifice, but someone has to do it.

This really gets into DB design, but based on what you're saying, I would drop the FK that is currently in place on the Property table. From what you say,...

majorbloodnock (8/13/2008)

---

Grant Fritchey (8/13/2008)

---

Jeff Moden (8/12/2008)

---

Now... if you can do that without spilling the Beer you're holding... 😉 The really good ones can do it while taking a sip...

Let me understand this...

The Historical_Propertys table has a pk, Property_ID. The Property_Managers table has a pk, Property_ID. There is a foreign key constraint on the Historical_Propertys table against the Property_Managers...

I'm a little confused. If you grant execute to a stored procedure that can insert data... it's going to insert data. The way around it is to not grant execute...

While I love VS for DB's and I'm even presenting a session at PASS on how to use it for multi-environment deployments, I don't think it will do what you're...

Well... It depends...

The IN clause in this case is probably going to cause a table scan. I'd say that you're better off using IF EXISTS in a nested fashion such...

Whether or not business logic should be inside a query is a HUGE debate. There are extremists on both sides. I'm pretty much in the middle. If it makes sense...

Can you post the scripts you're using to create the tables? There may be something there.

Jeff Moden (8/12/2008)

---

Now... if you can do that without spilling the Beer you're holding... 😉 The really good ones can do it while taking a sip without getting getting...

Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know what to...

Too late. I ran up a silly example and posted...

riix (8/12/2008)

---

Grant you seem more stressed than Gail; the point of discussion was Gail earlier stmt:

"Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones...