开发者

SQL Server 2008 create tables, invisible in SQL Server Management Studio

I created a database and some tables in C# using .NET SQL Server provider. Wh开发者_开发百科en I open up SQL Server Management Studio, I see the database; but the tables aren't there. If I run queries from inside my application, the queries return expected results; and SQL Profiler shows the create table commands executing properly. If I cut-n-paste the queries into SQL Server Management Studio, they execute fine, and the table shows up.

I suspect it's a permissions issue; however my .NET application is using SSPI in the connection string, and when I authenticate using SQL Server Management Studio, I am using the logged on windows account creds, so they should be using the same credentials.

Do I need to explicitly set the table permission in the SQL call or is my assumption that SSPI is the same as the logged-on windows creds wrong?


Same as Permission required to view list of tables in Management Studio. http://social.msdn.microsoft.com/Forums/en/sqltools/thread/9507f18c-7175-40dc-93e4-a7e236b9aa46.


A few thoughts:

  • does the account have permissions to the schema the new tables are in?
  • have you refreshed the Tables directory in SSMS? (Silly, I know)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜