Posted by xAvailx on 04/27/06 20:10

Check the following articles:

http://weblogs.asp.net/Firoz/archive/2005/06/12/411949.aspx

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/03/4945.aspx

http://www.sqlmag.com/articles/index.cfm?articleid=43922&

I use a tweaked version as shown in Itzik's article with sorting and
filtering. The only caveat is that is uses dynamic sql. With SQL 2005
you have a few more options to manage permissions for these type of
stored procedures. SQL Server MVP Erland has a very good article on
this topic:

http://www.sommarskog.se/grantperm.html

HTH.

• Next in forum: Re: Compound Primary Key - order not as expected
• Prev in forum: Re: Limits on rows in a table
• Thread view: Re: How to page SQL query result returned from FOR XML statement?

[Reply to this message]