I have an issue on querying against UTF-16 encoded characters in
SQL2000 database: For example the "López" is saved into database as
"López" (due to the UTF-16 encoding); somehow, when I query data
with conditions of "like 'lop%'" or "like 'Lóp%'", the row of López

has anyone met with this before?
the setting is SQL2K with SP3 on a 2 node active-active W2K3 cluster.
on one of the machine, it occasionally prompts for the following error:
"The log file for database "tempdb" is full. Back up the transaction

I can't remember how to do this.
I have a SQL table that we use to report our system problems.  The field is
a DATETIME Data Type
I want to create a simple grid/result to count the number of entries per

I am looking for a solution that allows me to encrypt a MS SQL 2000 Database
at the column level.
This is because I have a table with names, telephone numbers, addresses,
etc. My client is not comfortable with allowing the DBA or anyone else who

Is it possible to avoid the last used server being in  Query Analyzer
'Connect to SQL Server' dialog by default(when I click on File/Connect
in Query Analyzer)  - I don't want to apply 'truncate table' scripts to
a production server by mistake!

I have a stored proc that identifies indexes that need to be
defragmented ( LogicalFragmentation > 20% ) using DBCC SHOWCONTIG.
This works fine and shows me all of the candidate indexes to be
defragged.  I am using DBCC DBREINDEX to rebuild the indexes.  What I

Is it possible to somehow set a SQL Server DTS job to automatically
disable itself, when it encounters a fail, so that future scheduled
occurrences don't happen until the problem has been fixed?
I've hunted about for this on the web, but drawn a blank unfortunately!

i have created a field like this in sql 2000
CREATE TABLE MyTab(ABC_CLASS VARCHAR(3) NOT NULL,ABC_PERCENT DECIMAL(2) NOT
NULL,ROWVERSION TIMESTAMP NULL)
and i tried to insert a row

How can one identify the current licensing model on an existing
(production) SQL Server?

I am trying to do an update where I first cast as string as a INT and get
back the following message:
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the nvarchar value '725

Simple question: A customer has an application using Access 2000
frontend and SQL Server 2000 backend. Data connection is over ODBC.
There are almost 250 concurrent users and is growing. Have they
squeezed everything out of Access? Should the move to a VB.Net frontend

Hot to get unique, sequential number during execution
of stored procedure ?
I can create table with autoincrement column,
add record, get ident_current and delete record

How can I tell (preferably by a version attribute on some DLL or EXE) that
Service Pack 3a has been installed on a client PC?  KB articles such as
321185 do a great job of showing how to use SERVERPROPERTY to determine what
version the SERVER is running, but that's not my ...

I have a problem using serializable transactions. In one transaction I
select a single specific row from a table using a where clause (this
causes it to acquire and hold a range lock). In another transaction I
attempt to insert a new row into the table (which does not match the

Hiya everyone,
I have two tables in SQL 2000. I would like to append the contents of
TableA to TableB.
Table A has around 1.1 Million Records.