Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rimqpp
Starting Member
1 Post |
 Posted - 2009-12-10 : 10:32:24
|
| How to check if the user after "ALTER login " command is active?In the old server it was possible from "sysusers.hasdbacces" field.How it is possible to check it in sql2008? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-10 : 12:11:04
|
| Still works in SQL2008, but is deprecated. See sys.database_principals and sys.database_permissions.Also, look here: http://msdn.microsoft.com/en-us/library/ms187997.aspx |
 |
|
|
|
|
|
sysusers.hasdbacces in sql2008?