• thanks alot. That's exactly what I was looking for;-). How can I get the Windows User Name for example I want the user to be created like this:

    SQL Server Name\User Name.

    if I run that script you gave me will it solve my issue?