did you also have a look at this article ?

http://sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx

You can off course always make a comment to the article, so Frederik can reply himself.

sanjeev_krs2004 (9/1/2008)

---

Hi,

I have two tables namely account and invoice.

I want to update one field in account table when there is A NEW RECORD inserted in invoice table. I want to...

- look for implicit conversions (show xml execution plan)

- how is your sqlservers memory doing (pressure ?)

WayneS (8/31/2008)

---

I just upgraded a sql server 2000 instance to 2005.

One of the databases has some views that use :

select top 100 percent <columns to retrieve)

order by columna, etc.

the view...

one should provide index for FKs by default.

Except when it hurts your databases performance.

Keep in mind the in SQLServer 2005 you can disable an index and only build it if...

Here's an example that can be executed using your sql management studio in SQLCMD mode.

first of all ... from BOL 2005 :

[ @password = ] { encrypt N'password' }

Is the password required to activate the application role. password is sysname, with no default....

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