Sorry should have mentioned earlier. i am using 64-bit SQL 2005.

thanks for the answer.

thanks for the answer.

to answer, how the data is copied. it's basically doing like a full copy of one table from X database to Y database through SSIS package. sure...

Perry/Roy,

You guys are awesome. Thanks a million. now i am able to monitor the specific table.

Thanks again. owe both of you a lunch

This query is coming from Analysis server on a hourly bases. I checked the server and dont have any blocking going.

Dont know why its taking so long.

Thanks for the answer.

Yes positive this is the query taking that long time. How am i capturing these results? Well I have put filtered conditions on profiler to capture anything...

Thanks for providing the info. it was very helpful and solved my purpose.

Thanks for sharing the thread.

Thanks for the feedback.

Is it possible we create SQL Server Alias? First will it even work like DNS? If yes, appreciated if someone please share the reference on this.

Thanks,

Thanks for the contribution.

Barryoung - here's the requested info.

DevboardProddboDB.TaskTransaction BASE TABLE

DevboardProddboHoursExtractView ...

well guess what? It worked. all what i did was:

select * from dbo.[DB.Documents] -- Yes changed the DB.D to Upper case --- thats how the table is defined and it...

Lenny - Ran your code and no luck.

select * from dbo.[db.documents]

Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.db.documents'.

same error message.

I am 200% sure - I am running against the correct database. I even ran the following statement:

select * from dbo.db.document --- This too failed.

what's the other alternative? There...

i am running the select from SA. Also it says, invalid object which according to me is not permissions but object problem.