Limit rows for a user

Is it possible to set a limit for the number of rows to the user that connects to sql server (something like: whatever is the query this user does, set @.@.rowcount to 10000)?

Thanks.

AlbertoLimiting the affected rows is possible though various mechanisms like ROWCOUNT, TOP, ROW_NUMBER() but you are not able to do this per se. You will have to put the statement in all of your queries. There is no way in the query language to change the behaviour neside the ones mentioned.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de