Ok,I got this,but you can be sure that I have searched in internet and MSDN but I didn't find anything

thanks for replying

but when I say that is there any system or catalog view,I mean if any type of view exists which holds complete script of the relations not only...

what type of answer is it?

please read my question again

do you call sp_setAppRole to activate your application role?

Alter login privilage exist only for login,application role does not have any logins,it 's only a data base role,

for god sake check it to see it.

it is wrong ,we are talking about application role,the application role is defined in special data base,it is not a sql server login,the permission can be set for application role...

such a thing doesn't exist.I mean 'Alter Any Login' permission,we have 'Alter any user ' permission that I 've already granted it.As you may know user is different from login.

I...

yes,exactly:-)

Ok

I assume you have a null value in your database so it causes that

aggregate functions to fail.the best and correct way is to use 'Isnull'

function to eliminate null value...

where is the "from" clause of your query.

if you want me to help you write the whole query.

you see 'select ' query is in this form:

Select a,b,c,... from tableName

write the complete query