Maybe you can go for the colation-solution with your select. (check BOL)

e.g.print CHARINDEX('k' COLLATE Latin1_General_CS_AI ,@teststr COLLATE Latin1_General_CS_AI )

When you run the package, is that at your client or are you at the server-console ?

Don't modify dts-packages from your client, but always perform this stuff at the server,...

is the job-step set to "quit with failure" when the step fails ?

With Standard VB6 it needs a normal login-procedure and the a switch to the

application-role executing the sp_setapprole.

Is there a .Net-framework-based integration for SQLServer application roles?

If not : are application roles...

If you just want to insert and you don't need the recordset fore anything else in your logic, don't use the recordset to do this, but use a native insert...

maybe isnull(yourcolumn,replacementvalue) can help out or

coalesce(yourcolumn,replacementvalue)

OK Identity does not reuse. Should it ? Depends on the requirements. If your id column reaches the maximum value (int/bigint !!), you're in big troubles anyway and probably you'll...

I think I'll start counting from the other left side

Cheers

use IDENTITY. That's what it's made for.

Or keep your own parameter-file which you access using a genereate-new-id stored procedure.

this EOM-thing , does that mean you have to stand on a chair/table and that everyone else has to sing to you ? ended by 3 times hurray

identity just generates a (sequenced) number, but it does not generate it by recalculating it using the table itself, but it keeps it in a systemtable. It should be no...

The only time I ran regrebuild, I did not supply a parameter and it did the job. The reason I did not supply a parameter is because I did not...

Check "registry rebuild" in books online.

(regrebld utility)

I don't know such a tool.

IMO changing the system-date might be no issue on a TEST server, but on a production environment ???

Provide the date with a parameter to your...

kknudson,

Did you have DRI (foreign keys) ?