A VERY good article; it's really helping me hit the ground running with this. Of course, with new answers come new questions... We have a vendor supplied database application. We...

That's what I've done but it does not work. After altering the template that's shown in "Template Explorer" it does not become the new default template. When I right click...

Additional Notes: I've found/noticed/realized that when you grant securable/database/dbname and set various perms in it, the next time you look at that role, it will not show securable/database/dbname. I've decided...

Lucky for me we don't do any cross-server queries of any kind... the last time I tried (gaddz I think that was back in v7) it was pretty dreadful no...

Thanks for your input.

You've gotta write the code somewhere... If you put it in a view you only have to write it once-- and if you discover a bug you...

Wow...I wish I'd found this before I rolled my own!

I'm catching up on some old sqlcentral emails... and found this.

I had to move a db from our production server...

I have a user (developer) that tried to alter a view in a db. He does not have rights to the db ("Admin") I write the 2 tables to. He...

ruben ruvalcaba (2/29/2008)

First of all thank you, it's a good point to be considered. In fact, I use functions on the WHERE clause very often, specially when filtering dates...

If all access is via SPs, you could just be sure to refresh "UpdatedDate" field whenever you do an update, rather than using a TRG.

Upside is that it's a bit faster...