Thanks Satya, Yes, this is an access issue. As described above, I am able to connect to AS 2005 from the website and run reports, when I am using my...
Thnaks Dinesh, I had gone through that link, however things are not very clear in that article. If anyone could clearly explain the following...
Hi All, I have a ASP.NET/C# application, that was running on AS 2000 cube. Now, i have migrated our cubes to AS 2005. I did all my changes in the...
1) The windows authentication would not allow your application to connect to SQL Server across different domains. If you need to connect across...
Is the method of collecting time info by inserting INSERT statement before and after the SP correct? Any better ideas?
Queries with either IN or EXISTS is taking similar time. Why? I have following 2 queries:declare @ProductID as varchar(5) set @ProductID = 'DS'IF...
I need to improve performance of an SP. This SP calls another SP which is consuming 80% of time. I collected this info by inserting INSERT statement...
Separate names with a comma.