List registered SQL servers using C#

Applicable to: SmartMarine 3D, SmartPlant 3D using SQL 2005 client

Smart Plant/Marine 3D software require the SQL servers where projects/plants database is located to be registered on each client workstation. In the software version up to 9.1 HotFix: ANY it is required to have also SQL 2005 client installed on the workstation.

Writing . . . → Read More: List registered SQL servers using C#

Leave a comment   Smart Marine 3D   , , , , , ,  

Smart Marine 3D beginners SQL quick start

Some simple SQL queries that can help new users start faster.

Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.

Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database – XXXX_MDB. The table view JNamedItem contain all items names and their IDs – . . . → Read More: Smart Marine 3D beginners SQL quick start

2 comments   Smart Marine 3D   , , , , ,  

SmartMarine 3D – Show recent objects in the workspace

Database platform: MS SQL server Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D) Task: Show in the workspace all objects created or edited recently For troubleshoting and for monitoring purposes it is useful sometimes not only to get a list of the objects created or edited recently, but also to show these objects in the workspace. . . . → Read More: SmartMarine 3D – Show recent objects in the workspace

Leave a comment   Smart Marine 3D   , , , , ,  
 
  Older Entries »