.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Database diagram failur - Invalid class string SSMS 2008

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
Hi There -  Help needed In SSMS 2008 (not express) the Database Diagram  cast the exeption "Invalid Class String" (MS Visual Database Tools). Why is this happening. I have used the diagram designer before succesfully My OS W7 - SqlServer 2008 - every thing updated  - every service pack installed I have tryed reinstall seceral times - not positiv What is going on - It had been working (1 month ago) Please help Freddy

View Complete Post

More Related Resource Links

Missing Database Node using SSMS 2008 Express

Hello,It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.Before:After: I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.Thank You for your help,-imperialx

Missing Database Node in SSMS 2008 Express

Hello, It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS and login back, the database node is missing. I have asked this question over at asp.net forums with images (http://forums.asp.net/t/1600718.aspx).   Thanks, -imperialx

Error while connecting to Database Engine within SSMS 2008

Error text is as below:- any suggestions ?   ===================================   Cannot connect to TEJ-PC.   ===================================   A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476   ------------------------------ Error Number: 2 Severity: 20 State: 0     ------------------------------ Program Location:      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)    at System.Data.SqlClient.SqlInternalC

SSRS 2008 configuration Manager - "Invalid Class"

Reporting Services Configuration Manager is throwing an error when I try to "Find" the server. The manager starts up and takes me to the "Reporting Services Configuration Connection" window. I click on the "Find" button (leaving the default comptuer name as-is; the local machine)  and get the error message "Invalid Class" with the title "Reporting Services Configuration Manager".

I've been searching around the interner and only found one forum post with a similar problem to my own. It was on this forum and the advice seemed to be pointing towards a problem with WMI, but it seemed that the user never found a solution. I've downloaded and ran the WMI diagnostics program and the log does contain quite a few warnings, but I don't know how to go about solving most of them. I did run regsvr32 on some dll files though :)

I won't post any logs yet, as I have no idea where the problem may be based. Please advise and I will post the required information.

error getting database diagram on sql server 2008


Database diagram support object cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the database properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, the add the database diagram support objects.

i do have a valid owner in the database Files tab.


any idea ?

T-SQL for database size and space available (like on Database Properties page on SQL 2008 SSMS)


How can i (using T-SQL) get the database size and free space like the database properties page of SQL 2008 SSMS shows? I want to be able to display that information in our software.


SQL Server 2008 (Std) : Database diagram distorted on printout



When I create a diagram in MS SQL Management Studio 2008 Std (version see below) I have an ugly mis-rendering on every table on the printout. I have SP2 applied on the client (Managment Studio) and on the server. It looks like "a part of a window" is drawn below each table.

I did:

1. Create new diagram
2. Add Table
3. print diagram to pdf printer or real laser printer

=> same result ugly printout with portion of a window under the table.

I went and used  MS SQL Management Studio 2008 R2. And it worked (from another PC). Directly on the server using SQL 2008 Managment tools it produced the same distorted output.

This is annoying. What am I doing wrong?
Any tips are welcome

Best regards



Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.1.2600

Cannot attach database using SSMS 2008

Install SQL Express 2008 Advanced Services RC0 and launched SSMS2008 to attach some database files from previous 2008 install. But was unable to do so becuase of the following error...

Ho do I fix, reinstall or ?

Code Snippet


Cannot show requested dialog.

Parameter name: nColIndex

Actual value was -1. (Microsoft.SqlServer.GridControl)

Program Location:

SSMS 2008 - Is there a better way to display/group tables in multiple scheams under single database


In SQL server 2008 we have 30 users schemas setup under a single database (say "UserDB")

Each user is set up with access to his/her own schema

So when you login to server and drill down to Databases >>UserDb >> Tables,  you will see the tables that belong to your schema


Now I have to give cross Schema access. User 1 wants to see User 2's schema tables.

User 1 tables shows up as user1.table1 and user 2 tables show up as user2.table2


Question is: Instead of listing ALL the tables, differentiated by prefix, is there a way to show them like windows folders.

Can not create table via SSMS 2008 database designer (GUI) even with db_ddladmin role


I have SSMS 2008 (version - 10.0.2531.0)
Back end Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (X64)
I have DB_ddlAdmin role on a database

I can create/alter a table via sql script.
In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error.
"You are not logged in as Database Owner or System Administrator. You might be able to save chnages..."

Then i get a screen where SSMS asks me to enter column names. When I enter column names and I can click on Save I get "Not a Table Owner" error. The table does get created but after that i can not alter it via Database designer (I can alter it via a alter SQL).

So Long story short, I can create tabels via DDL sql but not via the SSMS database designer. This from a technical view point might not be a big deal but for a business person not knowing SQL syntax will be a critical issue.

This was reported back on 06/2009 but can't imagine it still being a active bug

debug and class diagram question, visual studio 2008


Hi. Im working on a project where there are a lot of imported dll's from a company that have e-soultions. now some times when i debug i get to a dead end when a class or method is used from their project. They supplied me with their sourcecode so i got that, now the question is can i somehow debug in my main project and to trace it to their project if i got the source code? (hope im clear on what i want to do)


second question is that i want to print all the classes and inherits, can i get that somehow with the different relations between classes straigh out of visual studio? i know about class diagram but it dont show relations.


thanks for reply

Connestion string create any database server

This links important to how to create connection string to any data base sever.

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

VS 2008 IDE does not see the AsyncPostBackTrigger class


I am trying to work with the AJAX AsyncPostBackTrigger class in the System.Web.Extensions 3.5assembly. I am in VS 2008 and the project is targeted for .NET 3.5.

In the IDE, the source for Default.asp, I am getting a warning (wavy green line) for the <Triggers> tag and the <asp:AsyncPostBackTrigger> tag. The cue for the Triggers tag is "XHTML 1.0 Transitional - element triggers is not supported".

for the other tag it is saying it is not a known element. Intellisense doesn't even list the <asp:AsyncPostBackTrigger>

Anybody have any suggestions what I may be missing? The System.Web.Extensions v 3.5 is listed in the Web.Config file and is in the project references.


BinaryFormatter, SortedSet base class and a few instance variables.

/* This example successfully serializes and deserializes the SortedSet<string> base contents, but all the instance variables show up uninitialized. Here's the output: n1: 0 n2: 0 str: s == "String 1" s == "String 2" s == "String 3" Any ideas? */ using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.Serialization.Formatters.Binary; using System.Runtime.Serialization; using System.IO; [Serializable] public class MyObject : SortedSet<string> {     public MyObject() : base() { }     protected MyObject(SerializationInfo info, StreamingContext context)         : base(info, context)     {     }     public int n1 = 0;     public int n2 = 0;     public String str = null; } namespace BasicBinarySerializationInheritanceFromSortedSet {     class BasicBinarySerializationInheritenaceFromSortedSetTest     {         static void Main(string[] args)         {             {                 MyObject obj = new MyObject();   &nb
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend