In SQL 2005 there is sys.database_principal and sys.database_permissions
table from where i can see the roles and their permissions.
But these tables are not present in SQL 2000. Which is the table from where
i can get the information about the roles and the permission given to ...

pasword data base sql2005 beda dengan pasword os nya

If you use Windows authentication for database access and they chnage the
name of the Domain is there anything other than creating the news groups
that needs done to allow access?
Example:

Are there any doc's out there describing why this is the preferred method or
non-preferred method when configuring websites to authenticate to SQL Server
running on a different machine? I have searched and can't find anything as to
how this works, why it is used, and why it is OR ...

RULES!!!

Hi, im tryin to get IMPERSONATION to work between SQL Server 2005 and
Exchange 2007 via ExoleDb (Microsoft Exchange OleDb provider)
The two servers are in the same box (Running Windows Server 2003), the user
can impersonate Exchange accounts (its the same user that i use for EWS and