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.
| Author |
Topic |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2010-01-05 : 05:09:58
|
| Hi,We are having one stored procedue that is calling from front end (application).. But some time it is not executing..like i can go in to database and check for updated values..new values were not there.Developers are saying ..from application they are calling it ..But database saying someting else..How can we track a stored procedure ..that it was executed or not ..time ..ect ..like a log file..? one more question ....Can we get all failed sql queries in the database ...like in a view..or log file or... how can we check which query was failed ...? any idea ...? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-05 : 05:20:35
|
| can you run profiler trace in db and then try executing sp from application? |
 |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-01-07 : 00:49:18
|
| The database is on which this stored procedure is on database mirroring ..like this is a principal database of the database mirroring .. can this be a problem ...? |
|
|
|
|
|
|
Stored procedure