Posted by sanjitg via SQLMonster.com on 09/29/05 17:52

i also saw sp_columns was not working
there are other admin function i was not able to do

so i did rebuild master database and it worked out fine


Simon Hayes wrote:
>If you're absolutely sure that the registration is using a sysadmin
>account, then I have no idea why you can't create logins. Can you do
>other sysadmin tasks successfully in EM, such as creating scheduled
>tasks owned by sa?
>
>It may be a bug of some sort, but if so it's very unlikely that you'll
>find a fix - there will be no mainstream support available for SQL 7
>from the end of this year. And since you can manage logins from QA
>anyway, it's probably not a critical issue.
>
>Simon


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200509/1

[Back to original message]