Never mind....this is resolved.

I run this code but it did not tell me the name of the table and column where match is found.

this is not giving correct output.

Yes, you need to create a script for all logins on the source instance. Next step is to execute the generated script on the target instance so the logins are...

I find it hard to understand....this looks a bit difficult process that other databases like mysql and oracle.

I am stuck because of the following reasons

Could you please tell

1....

I want somthing smaller like this..

SELECT Employees.Name, Orders.Product

FROM Employees, Orders

WHERE Employees.Employee_ID=Orders.Employee_ID

AND Employee_ID='100'

may be something like this...i am not sure whether this will work or not in my situation.

i have...

I need SQL query for ORACLE DB though.

...plz see my above post to know what exactly i am looking at .

"..Do you want to find all the records that say have emp_ID = 100.."

YES

so, you mean i need to use 50 times UNION and 50 times select query !

However, the...

Hi Holger

....this works perfectly man.

after downloading and installing the version you suggested everything worked fine!!

But, i still dont understand why did you suggest SQL2000-KB884525-SP4-x86-ENU.EXE 66.9 MB

How did you...

>What version of SQL Server 2000 are you running,

ok...you tell me what command i need to trigger in my console to get your answer....i will post the result you...

i am connecting it via WEbsphere and getting that error in the websphere server console.

the reason i want it is , i am getting an error

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"

i am already in the...

before reading your post , i downloaded SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

and it did nothing.

http://imgfly.com/files/101006_104408/web.JPG

thats my SQL Server 2000 version.

can you please tell me , what i need to download ?

please provide me the download link

its DB2

someone please help.

do you think..i am making mistake in password ?

do i need to reinstall ?

is there any way to recover password (i dont think i am putting wrong password...