t2support wrote:
I find solution.
Is modify [dbo].[web30searchsoftware] ? Right ?
Thanks a lot.
Yes, change varchar to nvarchar
ALTER PROCEDURE dbo.web30searchsoftware
(@soft nvarchar(1000))
AS SELECT Software, Version, Total
FROM dbo.web30repsoftwaretotal
WHERE (Software LIKE @soft + '%') OR
(Software LIKE '%' + @soft + '%')
ORDER BY Software, Version
GO
ALTER PROCEDURE dbo.web30softwarepercomputer
(@software nvarchar(1000),
@theversion nvarchar(200))
AS SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblOperatingsystem.Caption AS OS,
dbo.tblComputers.Domain, dbo.tblComputers.Lastseen
FROM dbo.tblComputers INNER JOIN
dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername
WHERE (dbo.tblSoftware.softwareName = @software) AND (ISNULL(dbo.tblSoftware.softwareVersion, '') = @theversion)
ORDER BY dbo.tblComputers.Computername
GO
ALTER PROCEDURE dbo.web30searchuser
(@name nvarchar(300))
AS SELECT dbo.tblADusers.Displayname, dbo.tblADusers.Title, dbo.tblADusers.Company, dbo.tblADusers.Department, dbo.tblADusers.Username,
dbo.tblADusers.Firstname, dbo.tblADusers.Lastname, dbo.tblADusers.Telephone, dbo.tblADusers.email, dbo.tblADusers.Userdomain,
dbo.tblADusers.Mobile, dbo.web30lastlogontop.lastlogon, dbo.web30lastlogontop.Computername
FROM dbo.tblADusers LEFT OUTER JOIN
dbo.web30lastlogontop ON dbo.tblADusers.Username = dbo.web30lastlogontop.lastuser AND
dbo.tblADusers.Userdomain = dbo.web30lastlogontop.lastdomain
WHERE (dbo.tblADusers.Username LIKE @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%') OR
(dbo.tblADusers.Firstname LIKE @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%') OR
(dbo.tblADusers.Lastname LIKE @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%') OR
(dbo.tblADusers.Displayname LIKE @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%') OR
(dbo.tblADusers.Displayname LIKE '%' + ' ' + @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%') OR
(dbo.tblADusers.Department LIKE @name COLLATE SQL_Latin1_General_Cp1_CI_AI + '%')
ORDER BY dbo.tblADusers.Displayname
GO
