aruram (1/8/2009)

---

The very first search always take longer irrespective of how small the resultset and then the subsequent searches are a lot faster even if the resultset is huge.

...

Is...

What authentication/access is the app using? Is it different from what the users are using?

Heh, that was going to be my next question too...

Just to clarify: Are you saying the the SELECT * at the end of the proc is showing the data, but a SELECT * anywhere else after that is...

Well said. All o' youse guys. 🙂

Heh. Sorry Michael, if I had know that it was...

Afraid that I do not know.

Heh, good point. Likewise, Since there can be more than one foreign key on a table, you could get multiplication from your last join (that's why I put it...

Use your local Node\Instance name, even if it doesn't show it to you.

This should help:

SELECT c.TABLE_SCHEMA

, c.TABLE_NAME

, c.COLUMN_NAME

, c.DATA_TYPE

, CASE When pk.CONSTRAINT_TYPE = 'PRIMARY KEY'

Then 'YES' Else 'NO' End as [Primary Key]

, Case When Exists(Select *

From INFORMATION_SCHEMA.TABLE_CONSTRAINTS fk

Where fk.CONSTRAINT_TYPE = 'FOREIGN...

Script the metadata from 2005, apply the scripts on the 2000 server. Then BCP out the data from each of the tables, then BCP them in to SQL 2000.

Me too. Fair enough.

Read the links, post your table definitions, tell us what you want to do with the data. I doubt that you need cursors and I am certain that you...

Personally, I think that it is some kind of psychological "blind spot" that makes them think that they know what this is before they read the whole description, and then...

FYI, don't forget, you will need to change the DataAdapter to use the *_SQL methods of the BO.