September « 2011 « www.nuneworld.net

September 26, 2011

Cant insert Cyrillic Macedonian or Russian characters into database when doing bulk insertion.

Filed under: Software, info — admin @ 10:07 am

If you are Bulk inserting informations in your database that contain characters with value greater than 127 or less than 32. then in your bulk insert procedure just add

CODEPAGE = { ’ACP’ }

and also be sure that your .csv file is saved in ANSI.

BULK INSERT
   [ database_name . [ schema_name ] . | schema_name . ] [ table_name | view_name ]
      FROM 'data_file'
     [ WITH
    (
   [ [ , ] BATCHSIZE = batch_size ]
   [ [ , ] CHECK_CONSTRAINTS ]
   [ [ , ] CODEPAGE = { 'ACP' | 'OEM' | 'RAW' | 'code_page' } ]
   [ [ , ] DATAFILETYPE =
      { 'char' | 'native'| 'widechar' | 'widenative' } ]
   [ [ , ] FIELDTERMINATOR = 'field_terminator' ]
   [ [ , ] FIRSTROW = first_row ]
   [ [ , ] FIRE_TRIGGERS ]
   [ [ , ] FORMATFILE = 'format_file_path' ]
   [ [ , ] KEEPIDENTITY ]
   [ [ , ] KEEPNULLS ]
   [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ]
   [ [ , ] LASTROW = last_row ]
   [ [ , ] MAXERRORS = max_errors ]
   [ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]
   [ [ , ] ROWS_PER_BATCH = rows_per_batch ]
   [ [ , ] ROWTERMINATOR = 'row_terminator' ]
   [ [ , ] TABLOCK ]
   [ [ , ] ERRORFILE = 'file_name' ]
    )]

Comments (0)

September 22, 2011

Event Viwer Error ODBC

Filed under: info — admin @ 8:56 am

Perfmon

Short:

You are runign in services.mcs Smlogsvc.exe service and that service is run under Network Service account that have no privilege to read data from MS SQL bin folder. Locate your MSSQL bin folder add permisons to Network Service to be able to read.

—

Long: http://support.microsoft.com/kb/912399/en-us

The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Error in d:\nt\enduser\databaseaccess\src\mdac\odbc\core\dm\perf.c(349), Access is denied.

: Failed to create mutex for MS ODBC Perf File Mapping.

Couse:

This problem occurs because the Performance Logs and Alerts service (Smlogsvc.exe) does not have sufficient permissions to access the performance counter DLL or the “bin” directory and “bin\en” directoryfor SQL Server 2005 Analysis Services.

On a Windows XP-based computer, the Performance Logs and Alerts service runs under the Network Service account. However, the Network Service account has limited permissions on the local computer. The Network Service account cannot access the performance counter DLL or the SQL Server 2005 Analysis Services “bin” directory and the “bin\en” directorywhen you collect data from SQL Server 2005 Analysis Services performance counters.

Solution:

To resolve this problem, you must grant the Read & Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services. The DLL is located in the following folder:

C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Bin\Msmdctr90.dll

Additionally, you must grant Read permissions to the Network Service account on the “bin” directory and the “bin\en” directory for SQL Server 2005 Analysis Services. For example:

C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin
C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin\en

Note MSSQL.x represents the corresponding value for the instance ID in the system.

For more information about how to grant permissions to a specific folder in Windows XP, click the following article number to view the article in the Microsoft Knowledge Base:

308419 How to set, view, change, or remove special permissions for files and folders in Windows XP

resource: Microsoft

Comments (0)

September 21, 2011

Missing performance counters of MSSQL 2005

Filed under: Software — admin @ 11:51 pm

Missing performance counters of MSSQL, check if your MS SQL is 32 bit runing on 64 bit server and if its then do this

If you want to log you results using the CounterLogs functionality take the following steps

1) Stop the Performance Logs & Alerts service from services.msc

2) Open up the registry editor (regedit.exe), browse down to HKLM\System\CurrentControlSet\Services\Sysmonlog.

3) Change the ImagePath from the default value to %SystemRoot%\syswow64\smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)

4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%\syswow64\perfmon.exe, & add the SQL counter objects to a Counter log.

5) Set the various parameters of the Counter log, & start it to collect the data.

Comments (2)