I checked the permissions against another machine that's working and the permissions look fine. The only difference between them is one is Windows Server 2003 (not working) the other is...

It's because of the single quotes in the message string.

PRINT N'A-MSG = ' + REPLACE("[A-MSG]", '''','')
" = double quote
' = single quote

When you're testing the connection, are you logged into the server via the same method/profile/user that installed the Oracle Client tools.

In DTS, the Transform Data task is your best option in terms of speed and batch processing. In the ExecuteSQL task the statement is submitted as one batch.

Another option you...

Have you performed a shrink on the log file? Performing a transaction log backup doesn't not shrink the log file. Make sure there are no open transactions (DBCC OPENTRAN) and...

Personally I'd say datetime values should always be stored as datetime values. The ease and variety of ways you can split the date portion form the time portion almost makes...

Steve

Ahhh ... yes we are implementing the WS. Didn't I say that? No ... oh well silly me

The main point we're trying to get our...

Ok, a home built system is much easier to manage. We have this setup for two servers at our site. It's all basically contained in one table, 2-3 stored procedures...

128 + 86 = 214 ... coincidence ??

What is the datatypes of the source and destination fields. What collation are you using in SQL Server?

You can have basic formatting in your Excel file by setting up the formatting in a blank workbook and copying it each time you run the DTS package.

For more formatting,...

Is this standard log shipping that comes with SQL Server Enterprise, or a "home built" log shipping system?

The "[COLUMN_NAME=memberOf STATUS=DBSTATUS_E_CANTCONVERTVALUE]," is the cause of the error here. The data seems to be stored in weird formats for some fields in Active Directory. How you go about converting...

xp_smtp_sendmail comes from http://www.sqldev.net

It's a very useful replacement for SQL Mail.

We use the method I've described to send out a couple of form letters that are formatted for HTML.

There are various methods to get a list of databases (sp_MSForEachDB, sysdatabases, etc...) but the best method I found was to maintain table that lists the databases and where they're...