Lynn Pettis (5/8/2009)

---

Florian Reischl (5/8/2009)

---

Bob Hovious (5/8/2009)

---

Flo, I'm really looking forward to your article... errr articles... errrr book.... I just hope it doesn't turn into your life's...

The (first) article is...

Hi

Usually you should use a linked server. Other approaches are OPENROWSET or OPENDATASOURCE but the best (simplest) way should be a linked server.

Greets

Flo

Hi Roy

Just to ensure, did you check:

* Network traffic?

* Network card vs. switch configuration (half/full duplex)?

Greets

Flo

Hi Jamie

I think we talk at cross-purposes.

You are correct a SELECT will not lock the table and you can get errors if you INSERT data later in your procedure.

But if...

Always welcome! 🙂

Here 🙂

... at work. Had a busy day since now. Many planning for next projects.

Hi

Your initial sample data:

sl_no Initial_date Log_Time Description

245 4/9/2009 13:00 4/9/2009 15:51 This is a description

245 4/9/2009 13:00 4/11/2009 13:45 This is...

Hi

I don't know what you want to say with this. The...

Err... You cannot directly select from your remote server without any registration or using an ad-hoc query method.

* One way (as Ramesh showed) is create a linked server. Search BOL...

Hi

Use SCOPE_IDENTITY() after inserting the record into Table1 and Table3 to get the new identity values (your autonumber). After this INSERT both IDs into your Table2. Sure your Table2 needs...

Hi

Did you try to connect to remote server via IP instead of the name?

Greets

Flo

As we wrote, it depends on the specific SELECT statements. If the database should be more optimized for queries instead of data manipulations you should use a higher FILLFACTOR.

Sorry for...

I usually take CHAR(0) to ensure a character which should never appear in any GUI text. I know sounds ugly but works.

Hi

It depends on your select statements. If you are selecting by your "Article" column you should reconsider if it really needs NVARCHAR(1000) because this exceeds the maximal key length.

Greets

Flo