A few comments:

- since you're talking about involving 3 machines, I'm assuming you're talking 2 active and 1 passive, right? If so - you need to make sure...

Xander - I'm not getting any PM's (I actually never have, so I don't know if I'm set up to receive them).

It's probably better to just post it here. ...

Try posting what you have so far, and what you're trying to accomplish (specifically). Someone should be able to point you in the right direction, or point out why...

You have to mark the calculated column as persisted (the results must also be deterministic).

actually - SHE's the woman...:) But I'm sure she'll appreciate the feedback...

You've got two somewhat different things going on here:

- The first one is trying to capture the return code of a Stored Procedure into a variable for later use.

...

Why restrict yourself to the easiest part of the process? Testing the restore of a single user DB, you'ev bypassed all sorts of fun and challenging things that will...

The only other way to do that without a temporary table would be a correlated sub-query, which is going to kill your performance. If your adjustments table is big...

Try something like this:

select

so.name tablename,

sc.name columnname,

sc.colorder columnorder,

sc.length columnsize

from syscolumns sc

inner join sysobjects so on sc.id=so.id

where so.xtype='u'

the transaction log tracks what is being changed during a given operation. In simple mode, once the operation/transaction is completed and gets committed, the space in the transaction log...

If sounds like you're setting up something I refer to as "cursor hell" since this seems to be a snippet from something I can only imagine is being called from...

Here's an example using somethig approximating your data. You weren't really clear on the table layout, etc... so it's going to be tough to know.

Anyway - see if this...

Try changing that to a varchar so that you don't get the etc blank spaces....

@SitusParam VARCHAR(40)

if you called your code as it is now it queries for

...

WHERE (SITUS like...

The catch is - it's YOUR career, so it's what you would do. That's a purely individual question that can only be answered by you.

that being said - you're...

Aah... different issue. This can be fixed with a small tally table.

try this on

--perhaps make smalltally or Tally a permanent addition to the tool kit!

create table smalltally (n...