블로그 이미지
bedbmsguru

Notice

Recent Post

Recent Comment

Recent Trackback

Archive

calendar

1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
  • total
  • today
  • yesterday
2019. 12. 26. 10:26 SQL SERVER

출처: https://goosl.tistory.com/entry/MS-SQL-설치-센터-실행시-오류 [하늘 빛 하늘]

 

[MS-SQL] 설치 센터 실행시 오류

MS-SQL을 삭제후 다시 설치를 위해 MS-SQL 2008 setup.exe 파일을 오픈 했을 때 다음과 같은 오류가 떴다. 오 마이갓... 캡쳐를 앞 부분이 짤리게 했다 ㅠㅠ 자세히 보면. 내용은 다음과 같다 System.Configurati..

goosl.tistory.com

설치를 위해서 Setup을 실행할경우 아래 오류가 발생하는 경우가 있다.

 

solution
해결 방법은 저기 보이는 디렉토리 폴더를 삭제 해주면 된다. 


 

System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ or one of its dependencies. The system cannot find the file specified. (C:\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config line 5) —> System.IO.FileNotFoundException: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ or one of its dependencies. The system cannot find the file specified.
File name: ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′
at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory..ctor(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord)
at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



출처: https://goosl.tistory.com/entry/MS-SQL-설치-센터-실행시-오류 [하늘 빛 하늘]

 

 

'SQL SERVER' 카테고리의 다른 글

Oracle Client 업그레이드  (0) 2020.01.16
sql server default 제약조건 조회SQL  (0) 2020.01.15
Table Size 확인 쿼리  (0) 2019.12.12
테이블 반환 함수  (0) 2019.10.25
DB파일 MDF 사용량 SIZE 확인  (0) 2019.10.21
posted by bedbmsguru
2019. 12. 12. 11:11 SQL SERVER

SELECT      t.NAME AS TableName
,    s.Name AS SchemaName
,    p.rows
,      CAST(ROUND(((SUM(a.total_pages)   *  8)   /  1024.00),  2)  AS NUMERIC(36,  2))  AS TotalSpaceMB
,      CAST(ROUND(((SUM(a.total_pages)   *  8)   /  1024.00/1024),  2)  AS NUMERIC(36,  2))  AS TotalSpaceGB
,      CAST(ROUND(((SUM(a.used_pages)   *  8)   /  1024.00),  2)  AS NUMERIC(36,  2))  AS UsedSpaceMB
,      CAST(ROUND(((SUM(a.used_pages)   *  8)   /  1024.00/1024),  2)  AS NUMERIC(36,  2))  AS UsedSpaceGB
,    CAST(ROUND(((SUM(a.total_pages)   -  SUM(a.used_pages))   *  8)   /  1024.00,  2)  AS NUMERIC(36,  2))  AS UnusedSpaceMB FROM      sys.tables t INNER JOIN           sys.indexes i ON t.OBJECT_ID  =  i.object_id INNER JOIN      sys.partitions p ON i.object_id  =  p.OBJECT_ID AND i.index_id  =  p.index_id INNER JOIN       sys.allocation_units a ON p.partition_id  =  a.container_id LEFT OUTER JOIN      sys.schemas s ON t.schema_id  =  s.schema_id WHERE      t.NAME NOT LIKE  'dt%'       AND t.is_ms_shipped  =  0     AND i.OBJECT_ID  >  255  GROUP BY      t.Name
, s.Name
, p.Rows ORDER BY      TotalSpaceMB DESC
, t.Name

 

https://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database/7892349

'SQL SERVER' 카테고리의 다른 글

sql server default 제약조건 조회SQL  (0) 2020.01.15
SQL SERVER Setup 실행시 오류발생 해결  (0) 2019.12.26
테이블 반환 함수  (0) 2019.10.25
DB파일 MDF 사용량 SIZE 확인  (0) 2019.10.21
available threads 갯수 구하기  (0) 2019.10.17
posted by bedbmsguru
2019. 10. 25. 13:59 SQL SERVER

테이블 반환함수 VIEW를 대체하면 VIEW보다 성능이 좋다.

 

 

https://templar.tistory.com/34

posted by bedbmsguru