Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Stored procedure

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2005-08-08 : 14:43:17
is there anyway to check the log at what time the stored procedure to get executed.

and is there anyway that if we r using linked server , and to find out the status of the linked server, suppose if we r having any server issues for that linked server

any help will be a great help for me;

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-08 : 14:54:39
1. You would need a third party tool for this, such as Lumigent's Log Explorer; if you were running SQL Profiler, then it would have this information if you selected the correct events
2. The only way to find the status is to try a query using it.

Tara
Go to Top of Page
   

- Advertisement -