Hi Sheilish,

Only once did I need to get around the limitation of this "dco" security scheme regarding identity_insert where I required strict accountability of the sequential identity numbers (for 1...

Here are 2 UDF's I contributed awhile ago to sqlservercentral.com.  They should be in the "scripts" section somewhere.

RJZeroN is used to zero-fill/right-justify an integer value which is used by date/time...

Sheilish,

Here's what we do to get around this problem.  This is tedious but easy to implement in an existing application.  This is necessary because SQL Server does not "ALTER TABLE", "DROP TABLE", etc....

Test how long it takes to do the join without the update:

SELECT * from adnh

join q12004

on adnh.phone = q12004.col035

If that's efficient, check to see if q12004.batch column is contained in an...

The following books have been helpful for me:

VBScript Programmer's Reference by Clark, Donatis, et al (Wrox Press)

SQL Server 2000 DTS by Chafin, Knight, & Robinson (Wrox Press)

VBScript Pocket Reference Guide by...

I had a similar problem recently where the DTS pkg execution looks ok, but the execution status returned to the job is failure (returned status 1 instead of 0).  MSDB...

The "problem" is: How do you programmatically skip a task/step in DTS so that the execution status of the skipped step is reported as success and consequently the "process exit...

I'm trying to fix the return code programmatically for the DTS pkg execution, not "eliminate" it.  That's impossible.  According to the pkg log, all the "executed" steps are successful.  The only...

The "money" datatype is ok for U.S. money, but it allows 4 decimal places not 2 for cents!  Your app should prevent those hundredths/thousandths from being stored if you decide...

Do any of your tables with duplicates have a text column, and if so is the "textinrow" option turned on (which is not the default)?

Developers here reported a problem with...

Have you tried doing:

INSERT INTO IndicativeHistory (<all  columns&gt SELECT ? AS LastUpdat, <list all columns from IndicativeTemp> FROM IndicativeTemp

If this still gives you...

Options:

(1) Invest in an ODBC driver for RMS.

(2) If you have Oracle installed try using the Gateways product so that your RMS files are viewable within your Oracle db, then...

If you are using SQL7 and can't use functions that's a common way of doing it.

Otherwise, check out my function called "FormatDate" in the script section.  It was just posted...

Here's the only way I was able to get this to work.  Hopefully you can do the same (assuming you are using Outlook for e-mail).

(1) Create the mail profile on your client...