Alvin Ramard (3/31/2010)

---

CirquedeSQLeil (3/31/2010)

---

Steve Jones - Editor (3/31/2010)

---

I'm sure I missed a few things while I was gone. I'll try to get through this thread, once I remove about 600...

The port number that you manually assigned to it.

If you are going the table variable route, I would create a stored procedure and then call the stored procedure from .Net.

Other Options would be a CTE.

Grant Fritchey (3/31/2010)

---

CirquedeSQLeil (3/31/2010)

---

Jeff Moden (3/31/2010)

---

Grant Fritchey (3/31/2010)

---

dma-669038 (3/31/2010)

---

Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the...

Steve Jones - Editor (3/31/2010)

---

I'm sure I missed a few things while I was gone. I'll try to get through this thread, once I remove about 600 messages from my...

I am not sure the Browser service works that way. If there are multiple...

You are welcome.

The same result occurs if you eliminate the >= '1%'.

If you do it this way though, it will work.

Declare @var1varchar(10)

,@var2varchar(10)

Select @var1 = '1%',@var2 = Number

From Example

where Number like...

Are you able to connect if you specify the port number?

Are there any other error messages along with that message?

Check out this article:

http://jasonbrimhall.info/?p=391

Try this

http://www.eventid.net/display.asp?eventid=100&eventno=4016&source=MSSQLServerADHelper&phase=1

Lynn Pettis (3/31/2010)

---

Jeff Moden (3/31/2010)

---

Lynn Pettis (3/31/2010)

---

Gift Peddie (3/31/2010)

---

Thanks Jeff I...

I have taken this script provided by Wilfred and updated it to SQL 2005.

If interested, you can read about it at:

http://jasonbrimhall.info/?p=407

It was lunch time.

We will get back on track. Need time to digest the information...