如何删除SQL蔚蓝的入口？ [英] how to delete an entry from azure sql?

问题描述

下面是从我的蔚蓝的sql数据库截图。我想删除用户Nazerke。我已经删除的行，当我想保存它，它给了我，你可以在数据库的顶部看到WHERE附近有语法错误。如何删除用户，并可能是什么可能的解决方案？

here is screenshot from my azure sql database. I would like to remove user Nazerke. I've deleted the row, and when I wanted to save it, it gives me " Incorrect syntax near WHERE" as you can see on the top of database. How can I delete the user and what could be possible solution?

推荐答案

它看起来像密码包含的字符怪异，也许Silverlight应用程序已经支持了这些问题（不知道是肯定的）。你可以尝试删除其他的记录，像用户名用户的 JDuck

It looks like the password contains weird characters, maybe the Silverlight application has issues supporting these (don't know for sure). Could you try to delete an other record, like the user with username JDuck?

更新：实际的解决方案，可以在这个问题上找到：<一href=\"http://stackoverflow.com/questions/13662752/how-to-change-permission-for-the-service-account-in-azures-sql-management-porta/13663466#13663466\">how在蔚蓝的SQL管理门户变更许可服务帐户

Update: The actual solution can be found in this question: how to change permission for the service account in azure's sql management portal

这篇关于如何删除SQL蔚蓝的入口？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！