I have similar setup I am trying to get it to work.

I have CMS registered with windows authenticated id that is running sql agent, it has sysadmin permissions.

I have powershell...

Where did you get the installation scripts for YUKON ?

Its like this, say this trigger is in PROD database

create trigger my_tr

...

..

insert into prod1.dbo.work

values (..)

go

etc

end

go

SO when I restore this database over dev this trigger will still have reference to...

Yes, restoring prod to prod1 and dev to dev1 is not a issue, the problem is prod has hard coded triggers that point to prod1 but after restore from prod...

That won't work, customers can have multiple databases on same instance, you cannot have 2 databases with the same name , right ?

If one is PROD and the other is...

no this doesn't work either, what I want to is combine 2 updates, they have same where clause... those work individually, but when I combine those, they don't

I want to...

this one does not work too

Update mwebWorkCalcs

set mwebWorkCalcs.WorkCalcs_Actual_Hrs=SumTasks.Actual_Hrs,WorkCalcs_Expenses= SumTasks.Expenses

From (select isnull(sum(TASK.WorkCalcs_Actual_Hrs),0.0) as Actual_Hrs,

isnull(sum(TASK.WorkCalcs_Expenses),0.0) as Expenses

from MWEBWORK, MWEBWORKCALCS TASK, mwebWorkCalcs Proj

where TASK.WORKCALCS_WORK_ID = WORK_ID AND...

thanks, it looks scary... I will try to find out some more info. before doing this.

Thanks

Sonali

I read that article but that does not say if I can change the server collation after the installation.

Thanks

Sonali

So how do I add user to db_owner role ??

thanks

Wow, tons of thanks....

This is one of our customer - Text datatype can take only 2000 characters they want to increase it to 2048 and thats why need to change text to varchar(2048).

...