hi, I have this query according to my need and it works nicely in sql server 2005 . select name ,default_database_name from sys.server_principals Plz tell me appropriate query to see login detail in 2000 when i try to run this query this error comes Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'sys.server_principals'. plz give me the write query thaxxxxx jagpal singh
As per my reply to one of your other posts, the structure is a bit different in SQL2K. There are no DMV's but you can still get all the information you want in the master database. Login info can be found in the master.dbo.sysxlogins table. Please refer to SQL2K Books Online for this kind of information, or just have a look in the master database of a SQL2K instance. You would find the answers you need a lot quicker by doing that...
