quote:

---

Install SQL Server 2000 client tools (including SQLDMO components) does not overwrite the SQL Server 7.0 files if default installation is choosed....

sqlwire partially brought back from the dead

Add News is back:

http://www.databasejournal.com/news/addnews/

but 3 years of News history still seems to have evaporated as it is still not found in searches...

quote:

---

Hi Brian,

Wow, if I was ever included with Andy on SQL-DMO being one of the "guys." Thanks a lot! What...

damn you snitz! I just lost a post worthy of Billy Shakespeare ...

anyway ... - the gist was thx for the great article. on this subject there is...

more info from user who has solved his issue:

"I have Found the answer (well it works for me)

I'm using the Unicode nchar, nvarchar, and ntext data types instead of the

char,...

quote:

---

Is there a particular reason you app cannot support alternate code pages. The reason for your error is the difference in the...

great - many thanks. let me try this and let you know how it pans out

Brian Lockwood

President

LockwoodTech Software

quote:

---

That looks pretty good. The one issue I have with it, and unfortunately I don't have a lot of time to devote...

quote:

---

You are correct that the only solution to this is in the SQL. You will never be able to get milliseconds using...

quote:

---

OK, I know there are more ways to program than programmers but since you are passing a SQL statement anyway, why not...

I wrote up our VB solution here:

http://www.lockwoodtech.com/index.asp?PageId=articles/milliseconds&TitleID=support

Brian Lockwood

President

LockwoodTech Software

quote:

---

There may be a way, I just don't know what it is. Let me know if you find out. One hack would...

quote:

---

Actually you can disable it for INSERT and UPDATE which is all. To be able to drop a table, even if disabled...