I made some minor modifications to see if the SP's and UDF's would work with nvarchar data. Specifically, I modified the SP's to use nvarchar instead of varchar.

 I then modified...

One more question. I noticed that the stored procedures define the variables as varchar. Is there any reason this wouldn't work with NVARCHAR? (double-byte characters)? I read something about blowfish...

Great package. Thanks!

I followed the steps: copied the dlls, and ran the add_xp.sql (which finished successfully).

But when I try to call the blowfish encrytion, I get the error:

ODBC: Msg 0, Level...

Use the utf-8 encoding for all pages.

Yep, that is definitly a way to fix the problem. MS changed the install defaults with MSDE Rlease A. Previous versions allowed other machines to access the MSDE by default....

It could also be related to a clustered index. It looks like you have nearly 6 million records, and you're deleting roughly 200 thousand records. Depending on the clustered index,...

Have you setup a relationship between the tables?

Is the ID auto generated by SQLServer? If the ID is not being generated automatically by the system, then are the ID's being inserted in a fairly sequencial order? If...

You can just install Enterprise Manager without the dev version of SQLServer database. I believe that you can install Enterprise Manager on as many machines as you want.

I have read...

I know exactly what you're talking about. I found the solution about a year ago; I believe it consisted of doing a registry edit. Anyway, since then, I cannot find...

Yep, that's why I have the REPLACE function within a WHILE loop.

Remi:

I suspect it's simply an "HTML" thing. HTML ignores whitespace (well, at least more than 1 whitespace). You could enter "Hello World" with 100 spaces in between the 2 words,...

I would backup the DB's on the old machine, and then restore them on the new machine.

BCP should handle it. But I would suggest:

1) drop indexes on the table receiving the data

2) make sure your transaction log is large enough. OR, if you don't want the...

The identity value gets assigned BY THE DB AT INSERT TIME; not by you prior to the insert. When you insert data into a table, do not list the identity column when...