this is solved

If SQL.RecordCount > 0 Then

If SQL.SQLDS.Tables.Count >...

you are correct sorry.

Hi again,

sorry for a late answer,

I want to present each query in each column in a datagridview

I have no...

I have tested that I recieve exactly same error message.

elmnas (10/14/2015)

---

anthony.green (10/14/2015)

---

The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.

Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been...

anthony.green (10/14/2015)

---

The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.

Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been updated...

the issue was with the dns..

I meant I don't want to change any table in the database I just want to collect data and I modify the data.

ScottPletcher (9/30/2015)

---

From a performance standpoint, do this, get rid of the functions against the column in the WHERE clause to allow max possible use of all indexes. Always avoid...

Thank you in advance mate

Hello again

I didn't know that...

I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server

I believe the hard part for...