- consider an "on delete" trigger to perform your insert into tableB

- On insert in tableA, you could also use an "insert" trigger to fetch the available missing data from...

I haven't performed such an action (edition upgrade) from 2005 to 2008 myself but

wouldn't such an action need a setup from the commandline using /ACTION=editionupgrade ?

Just some feedback ...

I use 2 clocks ( mainly for myself ! ):

1) single beep notification: to drink a bit of water. Prevention measure no1.

...

Must have confused me.

Did the upgrade succeed or didn't it ?

I've seen the same behaviour.

You'll have to alter the dblevel yourself if desired (even for system db)

That's one of the reasons why I don't upgrade an instance, but prefer...

george sibbald (5/20/2011)

---

you would create competing resources for memory so may have a slight degradation there.

On the other hand you would have to have sperate disk resources for the new...

John Mitchell-245523 (5/20/2011)

---

You're quite right - I said active-passive but I meant to say active-active. I'll...

colin.Leversuch-Roberts (5/20/2011)

---

log shipping didn't work for reporting because sadly all our reports need to issue writes ( don't ask ) to the data during generation - so I can only...

I...

concerning the number of active connections ... that is not a problem because you'll have to stop and restart the sqlinstance anyway to actually have it using your tempdb files...

Mind me asking why would you want to your instance to be in single user mode ?

Couldn't a user db in restricted user mode serve you well enough ?

This is what I would propose:

As last step of your JobA just run a ISQL script connecting to your ServerB and raising an alert at that sql instance and have...

Good job, Koen.

😎

dito.

Never seen it being used that way, never been pointed to this "feature" at any course followed and so we just never used it that way, but this opens a...

AFAIK the scope of a returned result set is the calling proc, unless you store it in a table...