The following T-SQL statements will print the logical name and physical location of system database files:
USE master;
GO
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'master')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'model')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'msdb')
Result:
This will get the list of all languages supported by the SQL Server 2008 Full-Text Search:
Code Snippet
- – to determine run_value corresponding to locale [LCID - LoCale IDentifier]
- SELECT lcid, name FROM sys.fulltext_languages
Result:
lcid name
———– ———————————————–
5124 Chinese (Macau SAR)
4100 Chinese (Singapore)
3098 Serbian (Cyrillic)
3082 Spanish
3076 Chinese (Hong Kong SAR, PRC)
2074 Serbian (Latin)
2070 Portuguese
…………….
1036 French
1033 English
1031 German
1028 Traditional Chinese
1027 Catalan
1026 Bulgarian
1025 Arabic
76 76
69 69
25 25
13 13
1 1
0 Neutral
(53 row(s) affected)
The following query will bring the list of system stopwords corresponding to the English locale:
Code Snippet
- – list all stopwords corresponding to 1033 locale [English]
- SELECT * FROM sys.fulltext_system_stopwords
- WHERE language_id = 1033
When this query is run 154 records containing system stopwords will be returned.
