Ms Sql Server Management Studio Unspecified Error
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » ms visual database tools not implemented SQL Server Express » Unspecified error MS visual database tools 19 posts,Page
Unspecified Error Ms Visual Database Tools Sql Server 2008 R2
1 of 212»» Unspecified error MS visual database tools Rate Topic Display Mode Topic Options Author Message rafaelbonfarafaelbonfa Posted Tuesday, unspecified error in sql server 2005 October 30, 2007 8:39 AM Forum Newbie Group: General Forum Members Last Login: Thursday, March 12, 2009 4:36 AM Points: 2, Visits: 15 Hi, i am using sql server management studio 2005 ms visual database tools download express, and every time i try to open a table in a database i receive this message "Unspecified Error (ms visual database tools)" And i can't open the table. Any one can help me? What could be this problem?Thank you. Post #416551 brendan.hargiebrendan.hargie Posted Tuesday, March 4, 2008 11:20 PM SSC Rookie Group: General Forum Members Last Login: Sunday, May 10, 2009 9:29 PM Points:
Unspecified Error Sql Server
29, Visits: 6 I too am having this issue. It has only started today and I have tried restarting my PC as I thought it may have been an issue with my current session, but continued after. Any help with this issue would be greatly appreciated.Regards,Brendan Hargie Post #464218 faheemMfaheemM Posted Wednesday, March 26, 2008 1:45 PM Forum Newbie Group: General Forum Members Last Login: Thursday, February 5, 2015 2:12 PM Points: 5, Visits: 166 Hi Increase the no of connections.By default it is 5right click sql server instance and go to propertyfrom there click connections taband increase user connections connected to sql server instance you can also use sp_configure stored procedure Post #475064 shermdawgshermdawg Posted Monday, August 4, 2008 11:06 AM Forum Newbie Group: General Forum Members Last Login: Saturday, November 23, 2013 6:41 PM Points: 1, Visits: 25 I'm having the same issue. The application can connect read and write to the databaae but when I want to see the table data via Visual Database Tools. I get 'Unspecified Error'. I've increased the number of consurrent connections permitted but this makes no difference.I think it's to do with the drivers.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Unspecified Error in Sql Server Management Studio up vote http://www.sqlservercentral.com/Forums/Topic416551-324-1.aspx 3 down vote favorite I just started getting an error window with "Unspecified Error" in MS Sql Server Management Studio 2005. I get this when trying to Create a New Table in a DB or Right Click > Design on an existing table. I am able to open up a new connection and query the DB without any problems. The error message obviously is no help. Any thoughts on what is the cause and how to http://superuser.com/questions/100709/unspecified-error-in-sql-server-management-studio fix this? sql-server-2005 sql-management-studio share|improve this question asked Jan 26 '10 at 12:28 Yaakov Ellis 307515 Did you install any plug-ins? In my experience, that can break Management Studio quite effectively. –user3463 Jan 26 '10 at 12:34 No Plugins. The only thing that I have installed recently is an upgrade for Windows Live Messenger and Writer. –Yaakov Ellis Jan 26 '10 at 12:45 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote I realize this answer is a little late in coming, but I just ran into this same issue. Strangely enough, the error seems to go away if I use SQL Server Authentication rather than Windows Authentication. If you don't have that as an option or that doesn't work for you, I suppose you'll need to resort to old fashioned SQL statements. share|improve this answer edited Apr 2 '13 at 13:20 answered Mar 14 '13 at 21:35 Cavyn VonDeylen 1013 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions t
structure of a table making a right click on the table, and choosing Design, sql server then we receive the following error: Microsoft SQL Server Management Studio Unspecified error (MS Visual Database Tools) Cause. When you are connected to databases created on SQL Server 2008 ms visual database instances using SQL Server Management Studio 2005, you cannot make use table design features against the tables of those databases. Solution. You need to use SQL Server 2008 Management Studio to perform table design changes on databases created on SQL Server 2008 instances. Table design functionalities of SQL Server 2005 Management Studio can be used only on databases created on SQL Server 2005 instances or previous versions of SQL Server. .Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.
numerous reports of this problem, while most of them ended up unanswered. The following is an answer I found from a MS person so I guess it's likely to be authentic. The answer is, no, you cannot open a 2008 table using the SSMS 2005. An alternative is to right click the table, and select 1. "script table as" 2. "select to" 3. "new query editor window" 4. Then a new query window, with the "select" statement populated, will appear. You can then simply click the "execute" button. This is of course not as good as the one right click and left click of the "open table", but probably the best available option. http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335534 Comments Hi,
Thank you for reporting this problem. Currently one cannot use OpenTable functionality from SQL Server 2005 SSMS to connect to SQL Server 2008. The only workaround is to use SQL Server 2008 Tools to Design SQL Server 2008 Tables. Thanks Karthik MS SQL Server Manageabilty Team Posted by Microsoft on 4/17/2008 at 7:14 AM ============================== ===== Unspecified error (MS Visual Database Tools) -------------------- Program Location: at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options) Like this:Like Loading... 6 Responses to "Unspecified error (MS Visual