Extended Properties


i ask how can add & update extended properties in sql express 2008 database propertiesusing c#?
jassim rahma

using smo extendedpropertycollection

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.extendedpropertycollection_methods.aspx
sankar reddy http://sankarreddy.com/


SQL Server  >  SQL Server Database Engine



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more

TFS 2012 Update 3 Issue with PSBridge ISAPI Filter

i have upgraded tfs 2012 update 1 tfs 2012 update 3.  had similar issue had previous upgrade psbridge isapi filter not loaded.  around deleted psbridge filter list.  wondering if causing other issues , correct solution going forward seems come back. tfs 2012 update 3 installed on windows server 2008 r2 service pack 1 running iis 7. this issue event viewer: log name:      application source:        microsoft-windows-iis-w3svc-wp date:          8/16/2013 10:31:29 am event id:      2274 task category: none level:         error keywords:      classic user:          n/a computer:      vbmprweb289.cbn.local description: isapi filter 'c:\inetpub\wwwroot\lms\psiisbridge.dll' not loaded due co...
Read more