I have a problem with MSDE sp4 and MDAC 2.81
I install this files to the client machine but I can't registered sqldmo.dll
with regsvr32
     SQLDMO.DLL 2000.80.2039.0

How can I create a trigger that obliges UPPERCASE of a field in the
database?
thanks

Sometimes I get error : "The conversion of char data type to smalldatetime
data type resulted in an out-of-range smalldatetime value. "
If  I look on SQL there is ok example with error -  insert into calendar
(tema, pol_1, dodal, date_from, date_to, user_id, status) Values ('test' ...

I've been sent a backup file from a SQL Server 2000 DB and tried
restoring into a blank DB (with the same name) on my SQL Server 2K,
only it errors, see below:
(I've separated each line with a return, to make it more readable)

This is a simplification of a query I'm attempting to write at the
moment.  I can do it with a temp table, but I think it can be done in
one query.  15 minutes of fame to the correct answer.
3 tables:

Does anybody know where I can purchase the SQL 2000 Resource Kit?
Thanks

In the following query, I would like to have view1 as a sub query instead of
a separate query, but can't get it to work.  View1 is simply a SELECT ID,
NewValue FROM Table WHERE TYPE = CM.
UPDATE TestTbl

Any reference for good practices on database backup.  Which type to use
complete or differential, and Append or Overwrite media.  Also, is it safe to
keep other back up sets (Exchange and system state) on the tape as the
database?

SQL2K on W2Kserver
I need some help revamping a rather complicated query.  I've given the
table and existing query information below.  (FYI, changing the
database structure is right out.)

If I have two tables that I want to synchronize via replication publish
subscriber model and they don't contain primary keys i.e. an ID field, but
there are three columns that make a unique key.  The tables are HUGE so I
want to minimize down time.

I am looking for a function I can use in SQL Server similar to the
DateSerial(year, month, day) in Access.  Any help is appreciated.
Thanks,
Randal

I'm trying to count field login totals for users which updates another field
in another table. Which is the most efficient method?
I don't want to use a standard query as it will take too long if there are
1000 users per company each with 1000 plus logins.

Sorry for the cross post, but I am not getting a reply on the Windows 2003
Server newsgroup.  I am setting up a dedicated SQL Server running Windows
Server 2003 and I understand that the convential wisdom is that I should add
the Application

Can anyone point me to a good how-to to lock down SQL server 2000?

hi all and sorry for my english
I write into a SqlServer2000 database via jdbc using a PreparedStatement
(pstmt) and one of fields is a TimeStamp, my code is:
qwdum=System.currentTimeMillis();