check the url in my previous reply.

it has the info.

You should first check your original column for "non convertable" content.

check http://www.sqlservercentral.com/Forums/Topic533291-5-1.aspx#bm533528

I've tested DB-mirroring using 2 dev-editions (primary / mirror) and an express edition for witness.

Just make sure the service accounts can connect to one another !

What I did was using...

strange, now it finds 5999 rows where newcol is null.

So the update statement should have target rows to modify.

update yourtable

set newcol = oldcol

where newcol is null

As Steve replied, it will work on insert and update.

One little remark:

You only perform the extra update if the column is updated, meaning it is mentioned in the insert or...

Did you test the exact example code I posted ?

Can you post the results of this query ?

select count(*) as newcol_NULL_count

from yourtable

where newcol is null ;

Inspect your data !

Your example works perfect as shown next.

create table #mytb1 (col1 nvarchar(50) not null);

insert into #mytb1

Select '500910000000000000'

union all Select '500903000000000000'

union all Select '500909000000000000'

union all Select '500903000000000000'

union all...

nvarchar to bigint requires your nvarchar content to be convertable to numbers !

check your nvarchar columns content for non numeric content or special characters, ...

- Did you design your unit of work for each operation ?

- try to keep your transactions aligned to a single unit of work and commit or rollback as soon...

No. They use the a single...

Maxer (8/22/2008)

---

Sorry, I wasn't clear.

Rights to view all data tables for reporting purposes.

So they can't change anything, but they sure as heck could open up Access or Excel or whatever,...

hengert (8/20/2008)

---

Hi,

I want to add two columns, VARCHAR and DATETIME, to an existing table with data, that are NOT NULL columns.

ALTER TABLE ADDRESS

ADD DATE_LAST_UPDATED DATETIME DEFAULT ??? NOT NULL,

USER_LAST_UPDATED VARCHAR(8)...

"hard coded with week password ... " sounds familiar :sick:

Most of the time, the installers just don't know it is stored in an ini-file or a reg.key.

Search "program files" and...

You can still go multiple instance, but in that case, you may want to have a look at Windows System Resource Manager (WSRM) to avoid one instance starving you server.

For...

I just came across this post which might put some light in the darkness...

http://www.mssqltips.com/tip.asp?tip=1567

http://www.mssqltips.com/tip.asp?tip=1557