Get Blocked Objects

Hi All,
Whenever there is a timeout occured from Application which was connected to
SQL Server.
I tried to get the Blocking objects from SysProcesses table of master DB.
But most of the time it will clear very soon so i couldnt able to find the
actual objects which is Blocking.
Could any one suggests some ways to get the blocking objects.
Thanks in advance...
Regards,
Herbert R.SQL Server Profiler may help, but be reminded to log only the required
information as logging eats up resources.
References
- SQL Server 2000 Administrator's Pocket Consultant: Profiling and
Monitoring (Solving Performance Problems with Profiler)
http://www.microsoft.com/technet/pr...s/c10ppcsq.mspx
Martin C K Poon
Senior Analyst Programmer
====================================
"Herbert" <Herbert@.discussions.microsoft.com> bl
news:1E649539-6330-4D18-878C-276251E4F915@.microsoft.com g...
> Hi All,
> Whenever there is a timeout occured from Application which was connected
to
> SQL Server.
> I tried to get the Blocking objects from SysProcesses table of master DB.
> But most of the time it will clear very soon so i couldnt able to find the
> actual objects which is Blocking.
> Could any one suggests some ways to get the blocking objects.
> Thanks in advance...
> Regards,
> Herbert R.|||Check out http://support.microsoft.com/kb/271509/ for a script that can help
monitor blocking and record the objects involved.
Hope this helps.
Dan Guzman
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:1E649539-6330-4D18-878C-276251E4F915@.microsoft.com...
> Hi All,
> Whenever there is a timeout occured from Application which was connected
> to
> SQL Server.
> I tried to get the Blocking objects from SysProcesses table of master DB.
> But most of the time it will clear very soon so i couldnt able to find the
> actual objects which is Blocking.
> Could any one suggests some ways to get the blocking objects.
> Thanks in advance...
> Regards,
> Herbert R.

Get "Do you want to save this file?" when trying to launch Report Builder

This may be a simple setup issue on my XP client, but whenever I click "Report Builder" I get a "Do you want to save this file?" dialog box and nothing happens.

I believe Reporting Services is installed correctly on my Win Server 2003 because when I click "Report Builder" on the server itself it does the proper click-once stuff (checks to see if the app is there and downloads it if isn't) and launched Report Builder. Also, all other Reporting Services functions are working fine on both the server and XP clients - its just launching "Report Builder" on the client that is wierd.

So is there anything special I have to do for an XP client? It does have SP2. Its also probably worth noting that the server is not in our corporate domain - it is it's own test workgroup. I have set up anonymous access to the server for the Windows XP clients to access for testing, and that seems to be working fine for running all other types of reports.

Any suggestions appreciated. Thanks!Do you have the .NET framework 2.0 installed on the client machine? The ClickOnce technology that report builder uses is installed as part of it.

Thanks
Tudor|||DOH! That did it! Thanks!!!

I was under the (mistaken) understanding that .net 2.0 was auto-installed on a client as part of the click-once process.