thank you for replying me..now...i tried doing what u said but gave me some error..like for one of the db im the db owner domainame\xyz...i went to the db and...

i was actually had the same doubt...i understand that when we migrate i think we get the option of saving either to sql server or path ..when u save to...

may be the way i framed the question was wrong...i looked at the steps and we were using BCP..some how i figured out to use..i agree it is definitely time...

this forum has helped me a lot...i am here to learn and i don't think so you have the right to judge anyone with their expertise in SQL..i am sure...

thank you for replying...but i do not see sql server or agent for 2000 in services.msc....is there any expiration for developer edition?....the login worked fine until few hours before it...

thanks for replying..we might not want to spend money for another instance of 2000..like Steve said scripting out jobs and other stuff could be possible..but does he means to go...

i had a similar issue like this few days back and there was someone else fromt hsi forum who had the issue...my guess is try changing the port no from...

ok we did a trace and it worked out..thanks...FYI..we just want to find which procs are hitting the db ..thanks..

thanks again for being prompt...do u mean to say that i will need to filter the events so that i do not get the text data...and then transfer into a...

thank you...there are like more than 24k rows in the trace file..how can i conclude that so and so SP is taking more time?...should i go through the entire list?..and...

thank you for taking time and replying to my posts...so you mean to say that schemas in 2000 means tables,views only..

thank you for your suggestion...i really dnt know whether i have SSMS installed on that box to connect to the 2000 server...just curious to know...when he said schema..does it means...

well he told me to copy the schema..he said he doesnt need the data....

regarding your timeout error i can only guess that your query is taking too long to execute...i had the same problem for some other purpose..you can increase the timeout duration...

thanks...let me try once..