Either PATINDEX or CHARINDEX should work for you, just use the position of the pound sign to determine what the start pos and length will be. If other characters...

Try using -n (note the lower case n)

To emphasize you can use case statements. For example

Select CASE datename(dw,getdate()) WHEN 'Saturday' THEN '|Saturday|' ELSE datename(dw,getdate()) END

To change to your language, change the language of the user...

This happens because the application is connected to the SQL Server.  Check your previous lines and calling statements that use the DMO object, somewhere is missing or skipping the diconnect.

Use the Import/Export wizard (DTS) - Right click a database and choose "All Tasks - Import/Export Data..."

If you use -- as your delimiter your table will end up like this:

The Link JLK posted will work and is a good script, (I promise I'm not trying to one up you JLK) I just spent time writting this so I'll post...

You can't turn off errors in SQL 2000 and the try catch logic isn't available till 2005 (http://technet.microsoft.com/en-us/library/ms175976(SQL.90).aspx)

In SQL 2000 If an error is encountered the client...

You can try a dbcc dbreindex (if the query plans are changing for worse performance, this sometimes helps.)

Haven't had the problem myself, but I'm curious to know if the other servers in your cross server query are SP4 or SP3.  if they are SP3 do you have...

Here are some articles/Posts that might help:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=248941

http://www.sqlteam.com/article/xml-validator

http://support.microsoft.com/kb/279430

It is possible (I'm guessing here) that she is prompted for credentials because her current credentials were rejected.  Does your email alert show what username had insufficient permissions, if so...

Follow up to the prev post.

The reason I ask is that I had the same issue (today no less) and although I still don't know what in the table...

Try using execute process task.

By setting the connection timeout to 0 you shouldn't time out, sounds like the command called in xp_cmdshell may be timing out...

Again though, try...

Are you able to bcp manually, meaning can you execute bcp out from the source table on your publisher then bcp into your destination table.

Also are you able to...

I always use DTS to import data from text files (DTS can get very involved, but if all you're doing is importing all rows from a text file, the wizard...