John,

This is the output of a lot of procedures that i've made at two years a go. I only tried when we've got SQL Server 6.5 and SQL Server 2000 and...

Hello John,

I've tried to get one output like this one.

/**********************/

|      Login Information    |

/**********************/

Login Information on HOSTNAME

Login Name                            Default Database    

------------------------------ --------------------

sa                                        master

BUILTIN\Administrators             master

Infraxyz                                {database name}

infra1q2w                              {database name}

/***** User that belong to...

Hello John,

I like to thanks your amability but i dont know if you understand my point.

The question were that i need to get one report with permissions owned by all...

Thanks everybody.

Regards,

Jorge Mendes

Thanks a lot everybody, you we're very usefull.

Regards,

Jorge Mendes

Thanks a lot.

Now i've the results expected.

Regards,

Jorge Mendes

Hi Kidest,

Thanks for your help, but how can i change this parameter?

Its possible to change it without affect the database(its possible to do it with the database online?)

Thanks,

Regards,

Jorge Mendes

Thanks a lot everybody.

Regards,

Jorge

Thanks a lot,

it was what i've already done and it function very nice.

Regards,

Jorge Mendes