프로젝트 산출물의 하나인 테이블 명세서나 DDL 스크립트를 참고해서 데이터를 분석하는 방법 보다는 아래 Query를 이용하는 방법! 강츄~
select SchemaName=SCHEMA_NAME(t.schema_id), TableName=t.name, ColumnName=c.name, DataType=ty.name, TextLength=c.max_length, c.precision, c.scale
from sys.tables t
join sys.columns c on c.object_id = t.object_id
join sys.types ty on ty.user_type_id =c.user_type_id
order by 1, 2, 3
Wednesday, March 14, 2012
Monday, March 12, 2012
MS SQL Server 2008 R2에서 Collation 변경하기
setup.exe
/QUIET
/ACTION=REBUILDDATABASE
/INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts
[/SAPWD=password]
[/SQLCOLLATION=collation_name]
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=Bongsub /SAPWD=P@ssword /SQLCOLLATION=Korean_Wansung_CS_AS
http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
주의)master 데이터베이스 변경작업이기 때문에 Backup은 필수... 테스트 해보니 모든 데이터베이스가 훌라당 날아감!
/QUIET
/ACTION=REBUILDDATABASE
/INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts
[/SAPWD=password]
[/SQLCOLLATION=collation_name]
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=Bongsub /SAPWD=P@ssword /SQLCOLLATION=Korean_Wansung_CS_AS
http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
주의)master 데이터베이스 변경작업이기 때문에 Backup은 필수... 테스트 해보니 모든 데이터베이스가 훌라당 날아감!
Wednesday, July 20, 2011
List of feature ID, listTemplate
Feature ID | Name | List Template |
00bfea71-e717-4e80-aa17-d0c71b360101 | Document Library | 101 |
00bfea71-1e1d-4562-b56a-f05371bb0115 | Form Library | 115 |
00bfea71-c796-4402-9f2f-0eb9a6e71b18 | Wiki Page Library | 119 |
00bfea71-52d4-45b3-b544-b1c71b620109 | Picture Library | 109 |
2510d73f-7109-4ccc-8a1c-314894deeb3a | Report Library | 433 |
29d85c25-170c-4df9-a641-12db0b9d4130 | Translation Management Library | 1300 |
00bfea71-dbd7-4f72-b8cb-da7ac0440130 | Data Connection Library | 130 |
0be49fe9-9bc9-409d-abf9-702753bd878d | Slide Library | 2100 |
00bfea71-d1ce-42de-9c63-a44004ce0104 | Announcements | 104 |
00bfea71-7e6d-4186-9ba8-c047ac750105 | Contacts | 105 |
00bfea71-6a49-43fa-b535-d15c05500108 | Discussion Board | 108 |
00bfea71-2062-426c-90bf-714c59600103 | Links | 103 |
00bfea71-ec85-4903-972d-ebe475780106 | Calendar | 106 |
00bfea71-a83e-497e-9ba0-7a5c597d0107 | Tasks | 107 |
00bfea71-513d-4ca0-96c2-6a47775c0119 | Project Tasks | 150 |
00bfea71-5932-4f9c-ad71-1557e5751100 | Issue Tracking | 1100 |
00bfea71-eb8a-40b1-80c7-506be7590102 | Survey | 102 |
00bfea71-de22-43b2-a848-c05709900100 | Custom List | 100 |
00bfea71-3a1d-41d3-a0ee-651d11570120 | Custom List in Datasheet View | 120 |
29d85c25-170c-4df9-a641-12db0b9d4130 | Languages and Translators | 1301 |
065c78be-5231-477e-a972-14177cc5b3c7 | KPI List | 432 |
List IDs for onet.xml
100 Generic list
101 Document library
102 Survey
103 Links list
104 Announcements list
105 Contacts list
106 Events list
107 Tasks list
108 Discussion board
109 Picture library
110 Data sources
111 Site template gallery
112 User Information list
113 Web Part gallery
114 List template gallery
115 XML Form library
116 Master pages gallery
117 No-Code Workflows
118 Custom Workflow Process
119 Wiki Page library
120 Custom grid for a list
130 Data Connection library
140 Workflow History
150 Gantt Tasks list
200 Meeting Series list
201 Meeting Agenda list
202 Meeting Attendees list
204 Meeting Decisions list
207 Meeting Objectives list
210 Meeting text box
211 Meeting Things To Bring list
212 Meeting Workspace Pages list
301 Blog Posts list
302 Blog Comments list
303 Blog Categories list
1100 Issue tracking
1200 Administrator tasks list
101 Document library
102 Survey
103 Links list
104 Announcements list
105 Contacts list
106 Events list
107 Tasks list
108 Discussion board
109 Picture library
110 Data sources
111 Site template gallery
112 User Information list
113 Web Part gallery
114 List template gallery
115 XML Form library
116 Master pages gallery
117 No-Code Workflows
118 Custom Workflow Process
119 Wiki Page library
120 Custom grid for a list
130 Data Connection library
140 Workflow History
150 Gantt Tasks list
200 Meeting Series list
201 Meeting Agenda list
202 Meeting Attendees list
204 Meeting Decisions list
207 Meeting Objectives list
210 Meeting text box
211 Meeting Things To Bring list
212 Meeting Workspace Pages list
301 Blog Posts list
302 Blog Comments list
303 Blog Categories list
1100 Issue tracking
1200 Administrator tasks list
Friday, April 9, 2010
Subscribe to:
Posts (Atom)