have you tried putting single quotes around the value? i.e. 'mm/dd/yyyy mm:hh:ss'

Try

master..sp_tables tables, information_schema

The views only exist in the Master db, but will use the sysobjects from the currnt db.

If I were you, I'd make a view. Even if for right now it's just SELECT * FROM Table. This way you can more easily test various query senarios by...

Thanks David, I'll give it a try and report back.... setting up a "very slow test senario" takes me a few.

Can you provide an example of the TSQL code you are using when calling the SP?

A good option may be to do "vertical partioning"... Create separate tables for data, then create a VIEW combining the tables. This is especially nice in SQL Server... When creating...

Found something interesting...

xp_getfiledetails [Last Written Time] has the timestamp of the mobile PC file until it has completed it's copy. After completion, [Last Written Time] shows target server time....

I do not know specifically if the "IN (...)" has a size / items limit, but I've submitted lengthy SQL statements to SQL Server without problems. One exception I have...

Brian, both are good ideas, but changing the mobile application in this manner is not feasable. WINPC deposits multiple other files also etc. and complexity of this issue is more...

Thanks David.

Seems like xp_fileexist ruturns "OK" data as soon as the file exists, but prior to the file being available to import. I'm looking for a "file property" something...

SQL Server VIEWs can even limit the data that may be inserted / updated if you use the WITH CHECK OPTION in the view.

CREATE TABLE A (ID Int,...

Can you register it once using the servername, then again using the IP, or even multiple IPs?

File is deposited from a WINPC connected to server using a "UNC Share", then VB application performs a WINAPI "File Copy".

Each mobile WINPC deposits it's own, same name every...

Select SubString(Convert(Varchar(25), GetDate(), 9), 13, 8) + Right(Convert(Varchar(25), GetDate(), 9), 1) + 'M'

Select Convert(Varchar(8), GetDate(), 8)