With 90% certainty, no you cannot be garanteed that it'll work without retesting the whole thing (or getting approval letters from the vendors).

Another question here... why not go to sql...

I don't have any machine to test this out but it's quite easy to test.

Build a new empty db and put 1 mb in the log and 1 mb increment.

Add...

Make sure you can ping it from the "linking from" server. It's most likely a switch or firewall problem.

I've also foun one that using the ip adress was working...

One more important detail. The SAME page can be read multiple times in that total. So even if the whole table has only 5 pages, the total reads...

Of course, I was just having fun with the tempdb thingie.

Yes, but only when running the code in tempdb, that's why I was having a little fun with it in the code snippe with a bunch of usings.

Tx, I used...

Craig Farrell (11/2/2010)

---

Hmmmm....

CREATE TABLE...

That version works. Not using PK but same effect.

CREATE TABLE #Table1

(

TeacherID BIGINT

, StudentID BIGINT

)

CREATE UNIQUE CLUSTERED INDEX #IX_Tbl1 on #Table1 (TeacherID, StudentID)

CREATE TABLE #Table2

(

TeacherID BIGINT

,StudentID BIGINT

) ON...

Even if it makes no difference here, it should read : IF Object_id('tempdb..#tmp') IS NOT NULL

With tempdb.. missing you'll never have a hit on that id.

Craig Farrell (11/2/2010)

---

Yeah, even this doesn't work:

CREATE TABLE #tmp (tID INT);

IF Object_id('#tmp') IS NOT NULL

BEGIN

DROP TABLE #tmp

END;

IF Object_id('#tmp') IS NULL

BEGIN

CREATE TABLE #tmp(tID INT, tTxt VARCHAR(50))

END;

So, I'm going to go with...

I do that in prod no problem. Can you post the create table and index scripts you are using?

Craig Farrell (11/1/2010)

---

Of course to make my life interesting, this gets grumpy too and I can't remember how to get it to behave offhand. Maybe someone else remembers how...

Jeff Moden (11/1/2010)

---

Craig Farrell (11/1/2010)

---

Of course to make my life interesting, this gets grumpy too and I can't remember how to get it to behave offhand. Maybe someone else...

Grant Fritchey (11/2/2010)

---

Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size a...