RE: Fuzzy searching – SQLServerCentral

WaltersGE1

Old Hand

Points: 333

July 29, 2013 at 8:42 am

#1636669

Here's the first 5 mins of my current log:

2013-07-29 07:59:04.53 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2013-07-29 07:59:04.53 Server Server process ID is 400.

2013-07-29 07:59:04.53 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2013-07-29 07:59:04.53 Server This instance of SQL Server last reported using a process ID of 240 at 7/26/2013 3:02:46 PM (local) 7/26/2013 7:02:46 PM (UTC). This is an informational message only; no user action is required.

2013-07-29 07:59:04.53 Server Registry startup parameters:

2013-07-29 07:59:04.53 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

2013-07-29 07:59:04.53 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2013-07-29 07:59:04.53 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2013-07-29 07:59:04.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2013-07-29 07:59:04.79 Server Detected 2 CPUs. This is an informational message; no user action is required.

2013-07-29 07:59:07.07 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2013-07-29 07:59:07.21 Server Database Mirroring Transport is disabled in the endpoint configuration.

2013-07-29 07:59:07.24 spid4s Starting up database 'master'.

2013-07-29 07:59:07.42 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2013-07-29 07:59:07.65 spid4s SQL Trace ID 1 was started by login "sa".

2013-07-29 07:59:07.76 spid4s Starting up database 'mssqlsystemresource'.

2013-07-29 07:59:08.67 spid8s Starting up database 'model'.

2013-07-29 07:59:08.68 spid4s Server name is 'HNA-002297\SQLEXPRESS'. This is an informational message only. No user action is required.

2013-07-29 07:59:08.70 spid4s Starting up database 'msdb'.

2013-07-29 07:59:08.79 Server Error: 17190, Severity: 16, State: 1.

2013-07-29 07:59:08.79 Server FallBack certificate initialization failed with error code: 1.

2013-07-29 07:59:08.79 Server Warning:Encryption is not available, could not find a valid certificate to load.

2013-07-29 07:59:08.79 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].

2013-07-29 07:59:08.79 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].

2013-07-29 07:59:08.79 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2013-07-29 07:59:08.82 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.

2013-07-29 07:59:09.43 spid8s Clearing tempdb database.

I don't think this specific dll is the problem. I say this because it worked for a few days until all of the CLR functions stopped working. I've tried implementing the same functionality, but I get the same error when I try to install the dll on the server. I can't even install a quick one-liner function. Here's the dll I'm looking to use: http://anastasiosyal.com/post/2009/01/11/Beyond-SoundEx-Functions-for-Fuzzy-Searching-in-MS-SQL-Server. It doesn't give the C# source, just the dll unfortunetly.

Thanks again for your help.