SQL Server Object Dependency

It’s always hard to make modifications to code or database design especially if you don’t know anything about the business process. In sql server 2005 (or 2008) you can use sp_depends stored procedure to obtain dependency between the objects such as table, view or stored procedure. For example just run ‘sp_depends Users’ script to determine […]

Deadlock Resources

If you encounter a deadlock problem this resources can help to understand and solve the problem. Deadlocking http://msdn.microsoft.com/en-us/library/ms177433.aspx Minimizing Deadlocks http://msdn.microsoft.com/en-us/library/ms191242.aspx Detecting and Ending Deadlocks http://msdn.microsoft.com/en-us/library/ms178104.aspx

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top