remember that the moment you disconnect, your #tmp table will be DELETED;

it lasts only as long as your session...so you are creating a permenant table on the same database, right?...

Stamey is right;

sql server does not keep track of queries that were executed, or when a view/function/procedure was last used. You HAVE to have a trace running ...

could there be a trigger on the destination table that is causing the issue?

double post.

follow the suggested solutions hee to avoid disjointed answers:

http://www.sqlservercentral.com/Forums/Topic683311-266-1.aspx

sure, but what is "special characters" for you?

anything not a space and alphanumeric, for example? or are you after specific chars, like hi ascii characters?

here's a simple example

select * from...

of course...but it depends on what are "special characters" for you;

do you mean where any character is not alphanumeric(or space) like this?

select * from gmact where actname like '%[^a-z,A-Z,0-9 ]%'

or...

isn't it an html issue, where html does not respect whitespace, carriage returns, line feeds or tabs?

so you need to replace spaces with & n b s p ; or...

since you posted the question in a SQL 2000 forum, that's what we assumed you were using.

it is not possible to do that in 2005 or 2008; it was a...

the change from your real needs to your psuedo code and fake tables makes the real requirement make no sense.

in your example, you had 6 rows, and you insert the...

here's how i would do it.

since the natural "order" of the table is important to you, you cannot use row_number() to populate the number column, so you need to...

in the end, you vb is still just using an ADODB.Recordset and applying filters, right?

vb can take a stored proc's results, or a vb6 function that returns an ADODOB.Recordset, and...

the way described above is the only way.

SQL Server does not keep track of when a table was accessed, only a trace can be used to determine that.

I've personally seen issues where SP_UPDATESTATS or UPDATE STATISTICS [specific table name] didn't fix performance issues for stored procs after an upgrade, and I had to actually call DROP STATISTICS...

glad you figured it out.

in our case, it was the same thing...the app testest for read/write of the key, and failed to connect.

we used regedt32(not regedit) to grant permissions to...

it might be like an application my shop had:

the app stored the connection information in an encrypted format in the registry HKEY\LocalMachine\software; by default users typically can't write to...