have you been granted usage rights of the proxy ?

if your rollback takes abnormaly long (and should have completed according to your workload knoledge) , best is to stop/start the instance :crazy:

Your db will only be back online when...

It is not considered a good practice to have sqlserver and analysis server on the same physical box.

Exactly for the reasons you see.

They are different by nature and will compete...

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)...