Then try

UPDATE tblX SET colV = LEFT(colV, LEN(colV) - 2)

since we know it is 2 spaces on the end. I will look into the other issue though.

"Don't roll your eyes...

Answer one is no, not like you are speaking of, but you could schedule with agent to run the DTS pull every so often. Replication requires the server to be...

See the article "Copying DTS Packages To a Different Server" http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Ok so you found a work around with issues. What do you mean though they cannot be rtrimed off. Can you not run

UPDATE tblX SET colV = RTRIM(colV)

"Don't roll your...

I believe you can edit the file directly.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

This should do the trick.

The following is from MS Knowledge Base article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195759

Run SQL Server 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server...

Is you login a SQL login, if so then it does exist on the other server with permission (I assume based on what you said)? If so the use profiler...

Try this

DECLARE @filedate VARCHAR(10)

SET @filedate = SUBSTRING(@files,3,2) + '/' + SUBSTRING(@files,5,2) + '/' + SUBSTRING(@files,7,4)

And test

PRINT @filedate

You should get MM/DD/YYYY, if not what do you get?

If you do then use...

Just email it to me. I will look at it tomorrow.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Can you post the code snippet for your connection? Also, ADO has always worked better for me using the SQLOLEDB provider instead of ODBC.

"Don't roll your eyes at me. I...

How are you defining the connection authentication method for the linked server?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Can you post the DDL of the table and the first few lines of data so I can see. Also what does the error state?

"Don't roll your eyes at me....

Yes, it is the registry entries that cause this. And once the file is in use the OS won't let it go until process using it stops. I have not...

SQLMail does require a MAPI connection. However, I am playing with notes to see if I can build a stored procedure to do the same. We have you direct SMTP...

No there is no comparison of the two as to any improvements over the other. It is kind of like SUB versus FUNCTION in VB, in many case either can...