Hi All,
Is there a way to generate a "URN" out of IFORMATION_SCHEMA resultset? (or system objects, for that matter). I need to generate SMO objects for a Database. Doing it purely using the SMO namespace is horribly slow. In my test, it took almost two hours before I could build a complete tree structure for every single object in the database. Retrieving the schema info with INFORMATION_SCHEMA is a snap. But I still need to populate my tree with SMO objects. The only way I know to create a SMO object is by passing an "URN" parameter to the Server.GetSmoObject() method. Can somebody help me with this issue please?
Babu.