You should have replaced

  WHERE P.PRODUCT_ID IN (select PRODUCT_ID from product where name like '%' + @txt + '%')

with

  WHERE FreeText(name, @txt)

Note that using FREETEXT changes the behavior of your...

How about this:

CREATE FUNCTION dbo.uSN3(@n FLOAT)

RETURNS VARCHAR(12)

AS

BEGIN

 -- delete charpos 6,7,8,9 after converting to scientific notation

 RETURN Stuff(Convert(varchar(20), @n, 1), 6, 4, '')

END

Mike

You don't show your declaration for @filecontent, but the largest it could be is varchar(8000). If your file is longer than that, then the statement:

   SELECT @filecontent = filecontent FROM...

It's not necessary to assign a column name to the parameter in the SELECT. Try this:

INSERT INTO IndicativeHistory SELECT ?, * FROM IndicativeTemp

The SELECT just needs to return the correct...

Are you sure the truncation occurs during the insert and not the subsequent retrieval? If you know the length the error listing should be, run

SELECT Datalength(listing) AS Listing_Length FROM nmsErrorLog...

The WAITFOR DELAY '00:00:01' statement waits for 1 second. For 1.8 million rows with a batch size of 5000, that's 6 minutes of waiting. 1 second seems like a long...

Adding to what Jonathan said, here's an example:

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER ON

SET NUMERIC_ROUNDABORT OFF

GO

DROP VIEW vdoctest

DROP TABLE doctest

GO

CREATE TABLE doctest( FKEY_DOCTOR...

If the server is stand-alone, and not a member of a domain, just use the local system account. The common recommendation you refer to is to use a DOMAIN user id,...

Log on to the server and run the Server Network Utility ( svrnetcn.exe ). By default, you should see Named Pipes and TCP/IP. Again, the order on the server is not relevant,...

I ran some tests where I changed the network libraries, and under one set of conditions, nt_username is populated with my domain user id and loginame is populated with my SQL...

Thanks, Greg. That's the direction we're leaning, and the reasons you provided for doing so are good ones.

Well, given the situation you've described, the nt_username should not be populated on either server, if the application is run as you described. In fact, it cannot be populated that...

Do you know how the application logs in?  Some applications try to first log in with Integrated Security, and if that fails, log in with a standard SQL Server login. Maybe the...

That's the problem, Howard. Your application logs in using standard SQL Security, using the same username for all users.  In that case, nt_username column will be NOT be populated. The information you...

As I mentioned previously, the only time the nt_username column is populated is when the user connects using Integrated Security (Windows login).  The ability to login this way is dependant...