From the thread on this issue on MSDN forum (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=544902&SiteID=1) I understand you must have added a second backup name in the destination list. If you do this, SQL2000...

If I wasn't sure what George Bush's middle name was.

Wasn't it George "Wanker" Bush?

But that's counted without the functional analists. For these guys, you don't enter a value if a field is not applicable to a certain record

At least we seem to share thoughts here  (or better )

Now on-topic,

You say we use NULL for the 'known unknowns', yet in some cases we don't. We can also use NULL for the 'not applicables'.

Say you have //silly example

Maybe a little off-topic, but you started the quote :

"As we know,

There are known knowns.

There are things we know we know.

We also know

There are known unknowns....

Thanks, Happy,

that's exactly how I did it

No, not your bad, my bad.

I only found out it wasn't the system tables after my post.

What I thought would be interesting was relating to the system tables.

In our case,...

Simon,

that was easy, not 🙂 Unfortunately, the job is not inserted by the procedure that tries to retrieve its id On the contrary,...

Notice the nice constatation that 100.000 = 1000, and 1.000 = 100...

--DROP TABLE t_1

--DROP TABLE t_2

 create table t_1

(int1 int, int2 int constraint pk_1 primary key clustered (int1,int2), int3 int)

 create table t_2

(int1 int, int2 int constraint pk_2 primary key clustered (int1,int2), int3...

I have a similar problem.

We base a calculation performed by a set of stored procs, on a set of input record tables.

Recently, we've been asked to implement the possibility...

OK, despite the fact I still think it wrong the US acted against/without a UN mandate, you are probably right about the fact that removing Saddam made things moving. Remains the...

I think it hard to remember 'war heroes' from wars you didn't agree upon. No problem for me to honour my old grandfather who fought the German invasion of 1940....

Well, maybe, but for us this is not an option, as our process is a consecutive chain of stored procedures, which are 'stand-alone'.

I think the way we deal with it...