Hmm... there was actually some dump files, but they where much older than when this first started occurring, so that shouldn't be it either. Just to be sure I did...

Thanks again Antares. I checked the server min setting, but it was set to 1500, with max = 2500. So that doesn't seem to be it. Next stop is checking...

What exactly do you need to accomplish? Are you sure it's not enough with siundex and the difference-function?

Maybe you should do this outside of SQL, or in an extended proc...

Why does not a trigger work? I would create a trigger on sysobjects, checking for inserted rows with xtype = 'U'.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Not sure I understand the question fully, but I guess you're asking how to store data in any language. If so, use national character data instead av normal character data,...

No need for a trigger, just make sure the column of the first table is at least a candidate key. You can do that by adding a unique-constraint on it.

--

Chris...

What does your connection string look like?

Are you sure that the servers can reach eachother across the domains? Can you ping the SQL server from the IIS server?

--

Chris Hedgate @...

You could of course use INSERT INTO newdb..tbl (col1, col2) SELECT col1, col2 FROM olddb..tbl

Or just use the Import/Export Tool, should be pretty handy in this case.

--

Chris Hedgate @ Apptus...

IIS is Microsoft's web server software. It is not tied into SQL Server in any way, except that many web applications are made up of dynamic scripts that fetch and...

Yep, I copied the code from a proc I have, so that's why it was more than necessary. But won't the trace be stopped (or rather never started) if you...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

That's one of the articles I mentioned, and it is supposedly corrected in SP1 plus it discusses problems with sp_OA-procs, which are not used at all on the server. So...

How are you entering ip+port number? It's not entered in the same way as a web address, but instead with a comma for port, like this:

192.168.0.123,1433

--

Chris Hedgate @ Apptus Technologies...

Exactly what do you mean by 50% If you mean the first half, then you can use something like this:

select * from yourtable

where substring(companyname,1,len(companyname)/2) = substring('ABC Corporation',1,len(companyname)/2)

But if you're just...

Something like this?

DECLARE @Retval int, @TraceID int, @Message varchar(100)

EXEC @Retval = sp_trace_create @TraceID OUTPUT, 8

IF @Retval = 0

BEGIN

SET @Message = 'Blackbox trace created. TraceID=' + CONVERT(varchar(12), @TraceID)

EXEC sp_trace_setstatus...