SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

To view/edit mdf file in SQL2005

2/4/2010 1:17 PM	Rate (0)
Nil96 Posts: 325 Rating: (14)	Dear all, Can anyone let me know if its possible to view / edit mdf file in SQL2005. I just tried this but unable to find the data... First thing, I opened SQL Management Studio and attached the mdf file to the databases. Then under "tables", tried to open "TagCompressed" and I suppose the values are stored in binary. Or may be I am not adopting a proper way to view the mdf file. Just let me know how exactly to view the data in mdf file. regards Nil Attachment SQL.JPG (254 Downloads)
Nil96 Posts: 325 Rating: (14)
Suggestion To thank Quote Answer

2/5/2010 10:58 AM	Rate (0)
cumulus Posts: 993 Rating: (103)	Hi You can read thetables of alarmlogging and taglogging in WinCC or with WinCC conectivity pack from external functions. To write in this archives is a manipultion on the data and make no sense in my opinion. i hope that helps you: http://support.automation.siemens.com/WW/view/de/27147643 regards cumulus
cumulus Posts: 993 Rating: (103)
Suggestion To thank Quote Answer

2/9/2010 7:46 AM	Rate (0)
Nil96 Posts: 325 Rating: (14)	Hi cumulus, So to view data in SQL Server Management Studio, I need to have Connectivity Pack License... is this correct?? Since I don't have this right now, all the data is been showed as binary value!!!!! Am I right??? Regards Nil
Nil96 Posts: 325 Rating: (14)
Suggestion To thank Quote Answer

2/9/2010 10:35 AM	Rate (0)
cumulus Posts: 993 Rating: (103)	Hi I did not try to view it in SQL Server Management Studio. I allways readout the data with external programs like here http://support.automation.siemens.com/WW/view/en/39040079. I do not know ifSQL Server Management Studio can decompress the data You can try touse the WinCC-OLE-DB-Provider in a WinCC internal function, to read the data or you use the WinCC conectivity pack. regards cumulus
cumulus Posts: 993 Rating: (103)
Suggestion To thank Quote Answer

Share this page:

Share this page on...