Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

How to find all instances of a procedure (or function) in SQL Server 2005/2008 -


i modified procedure , takes greater number of parameters. how can find every place procedure called can update number of arguments proc passed?

i tried this:

select * syscomments text '%modified-procedure-name%' 

but i'm still finding other places proc called query did not return.

use sys.sql_modules:

select     object_schema_name(m.object_id) + '.' + object_name(m.object_id)     sys.sql_modules  m     m.definition '%whatever%' 

sys.sql_modules.definition nvarchar(max). other similar views have nvarchar(4000) columns, text split on multiple rows.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -