InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 03:24:30 GMT20http://www.sqlservercentral.com/Forums/Topic1360001-146-1.aspx[quote]use model[/quote]Model ?? You should be able to execute from any DB including Model, as system views are automatically inserted in all the databases including users DBs..Wed, 19 Sep 2012 23:09:07 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic1360001-146-1.aspxuse modelselect * from sys.server_[b]principals[/b]and not principlesOK ??Wed, 19 Sep 2012 02:30:53 GMTalfgomledhttp://www.sqlservercentral.com/Forums/Topic1360001-146-1.aspxQuery sys.server_principlesMon, 17 Sep 2012 02:03:01 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1360001-146-1.aspxQuery to find out list of logins that are enabled in SQL SERVER 2005.Mon, 17 Sep 2012 01:14:36 GMTmahesh.dasoni