Hi everyone, I am sorry I couldn't keep up with the forum lately, but work is just killing me.

Thank you all for the replies, I really appreciate your time to...

Yeah, they are same. It is just the sintax that is different 😀

DBMS implement them in the same way, and of course sql 2k5 optimiser is clever enough to realise...

It depends on how you write out your Join as to whether or not a Cartesian product is made.

The columns in the join are sometimes interchangeable with the where...

I totally agree with Steve on that one. The best way is to set up a trace. About the information about the last six months, I don't think there is...

Thanks for the replies but is there any "official" link or site where I could find this??? The thing is that I have to support why it's a good idea...

well after searching a while on the web, my guess is that it's as expensive as using the profiler, the thing is that by default only DDL statements are traced,...

GilaMonster (2/16/2009)

---

digitalox (2/14/2009)

---

Good point, not sure why but I've always...

K. Brian Kelley (1/30/2009)

---

All right, let's break this down to the basics...

...

When the schema are owned by the same person, and that's always the case when both objects are in...

My friend I think I am starting to get a little bit confused here. I have tried creating a single user with no privileges at all, just the public role...

Michael Valentine Jones (1/28/2009)

---

Everything you have described is exactly the way SQL Server Security is designed, and is the same in SQL 7, 2000 , 2005, and 2008, regardless of...

GSquared (1/28/2009)

---

In some way, someone, somehow granted permissions to the public role... At least, that's the only thing I can think of that would do what you're describing. ...

The thing is that I haven't given any permissions to the public role and it still can query all my tables, and I don't think that would be ok because...

What I am expecting to get is that a user without any privileges on tables, but only on a exec of a sp, gets an error trying to execute the...

K. Brian Kelley (1/27/2009)

---

With SQL Server 7, every database user is a member of the public role. If the public role has permissions against the tables, everyone that's a user...

GSquared (1/27/2009)

---

I'm not familiar with SQL 7, but I can definitely say that in 2005/8, you can give someone execute permission without also giving them the ability to view/edit code...