And to make that clear...

 you can update a view as long as you update one table at a time even though you can have more than one table included in...

Try:

DBCC rebuild_log('<database name>','')

If the rebuilt action is good you need to run DBCC CHECKDB afterwards and possibly take your data out of that DB!! (DTS or bcp come in...

First you haven't said what is supposed to happen when some of the rows are accepted and some of the rows are not.

Second. From your code the raise error does...

This is a presentation issue and the best way to hadle it is at client side. If this calculation is to move data into anther table then you do need...

http://www.databasejournal.com/features/mssql/article.php/3339681

The sort order is used on insertion only to determine existence! All values are not read because the index data is saved in BTree format. If you had no index...

That simply implies that the index does not exists for that ID or that it si not a 'real'  index.

Where did you get that ID from ?

>>If I'm not making a lot of changes to the portal/database, why would the max for my log file keep increasing?<<

I suspect some index rebuild is happening (probably after hours). If...

create table t1 (coltxt text)

go

-- put some data in it

insert into t1 ( coltxt ) values ('some test data')

go

-- add unicode column

alter table add colUnicode ntext

go

-- transfer values

update t1 set...

Constraints in MS SQL Server are enforced by using indexes. With Sort order you tell SQL how do you want the index created. Unfortunately I see no reason other than...

 ..If you're dealing in "x = y" type WHERE clauses though, simply encrypt y to match x and voila.

NOPE! that is not the case. If you run that, you will...

Well at least for every american you have two things for certain:

Death and taxes

Cheers,

Select Max(Id) Id, Custnbr,  Email

into #t1

from Yourtable

group by Custnbr,      Email

having count(*) > 1

delete D

from YourTable D join #t1 t

on D.Custnbr =t.Custnbr and D.Email = t.Email and t.ID <> D.ID

--...

There are other weak points on the encryption architecture.

1. If your company ( like mine )  has a service password change policy the...

As long as you have the rights to do it in a remote server, you should be OK. This server should only be a Development Server though!!