wow thanks all for the help!

one last question, do you know how to use SP_HELPTEXT, say I want to get the content of a stored procedure in ServerB by running it in ServerA?

i tried SP_HELPTEXT...

thanks muthukkumaran..

i tried this SELECT * FROM ServerB.master.dbo.sysdatabases

it worked! 🙂

I already have a linked server. I just don't know how the list of Server B's databases. 🙂

Executing sp_databases in Server A returns only the databases of Server A.

Parthi,

Running the query below in Server A gives me an "Invalid Object Name" error...:-)

SELECT * FROM ServerB.sysobjects

Hi parthi,

Upon checking, we already have a linked server for Server B, that's why I can query successfully from Server B. My apologies.

So, my question now is, how can I...

thanks for the immediate response! 🙂

actually we're not allowed to create a linked server. 🙁 but i can execute a query successfully in Server A. This query runs successfully when...

Ok..Don't be sorry dude.. In fact u tried to help me...thanks for that. Ok, i'll try the bcp command. Thanks again! 😀

Cool. Thanks for that. Btw, the BCP that you gave me, should I run it in SQL QA? 😀

TYPE does not exist also in SQL 2000. But thanks for the help. :D. I'll take a look at the BOL and try to apply it on my query. I'll...

hmm i'm using SQL 2000. I think PATH is not recognized. Btw, do you know any way on how to put this in a file? Let's say C:\Sample.xml? Thanks.

Ok. Here is the sample data that I'm trying to display in the XML.

USE pubs

SELECT TOP 15

ti.type, a.au_lname + ' ' + a.au_fname as Author,

a.phone, a.address, a.city,

ti.title_id, ti.title, ti.price

FROM...

Ok. Thanks for that. I tried it, but the tags seemed disorganized. Btw, I used BCP to write the XML file (the problem is, I got an error and the...