Thanks a lot. That worked..

Thanks, but how do i use different databases in " use" statement.

Sorry i meant to say what if i want to get data for week before the current week.

Thanks

Thanks so much. How about getting the data for last wk ? TIA

One more thing. Is it possible for the views to use the indexes if tables are on different database and views are on different database.

Just to make sure does views use only clustered index or even non clustered index. is there any link which would give bit mroe deratil about it.

Thanks, but we have windows 2000 on it. How is it that the connecetion becomes a problem only if the Pc is booted i not everything works fine.

Thanks for the response. But can you be a bit more specific how sql server 2000 helps in determining the best mem configuration

Its strange that the same query takes 20 secs to return the results when linked to a diff server but with test1server it goes on for a long time.

...

sql version is 2000, will that make any difference? please advise

Here it is. Also this on the source server takes few secs only

SELECT

DISTINCT

PROD_KEY,

CAST(1 AS BIT) AS...

I tried the same but it comes with an Error

---------------------------

Transaction cannot start while in firehose mode.

If i have a DB with 2 files on 2 diff filegroup and i need to alter the DB to have 2nd file point to 1st filegroupname. Is this the...

the filegroup is empty but still deleting it from enterprise manager doesnt work. if i delete the .ndf file from HD it shows a sharing violation although there arent any...

Thanks soo much that really helped and indeed there was a row which wasnt there in the referenced table.

thanks again