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 |
|
balaram19
Starting Member
9 Posts |
 Posted - 2012-01-24 : 05:25:04
|
| Hi, I want to know how many stored procedures were used nolock in sql server 2005. Do we have any query for this..ivbalaram |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-24 : 05:47:58
|
| do you have the code in a repository? (svn, sourcesafe, whatever)if so then you can use grepCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-01-24 : 05:55:53
|
| Generate the Script of the database and then you can search..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-24 : 05:58:06
|
quote:
Originally posted by senthil_nagore
Generate the Script of the database and then you can search..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008
also -- if you make each object go to it's own file the filename will be the name of the object. so using a search tool (or pattern match like grep) will tell you the name of the object.http://www.wingrep.com/Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
how 2 5nd stored procedures which are used nolock