• Maybe you should keep the default as it is.

    You could use user_id() and this returns sys.principals.principal_id. The value would not change if the database is moved to a different server. This works well, as long as everyone has a user defined in the database.

    However, in many places this is not likelyt to be the case, but users get access through Windows groups. In that case everyone will map to the same ID.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]