Showing posts from January, 2011

SQL Server useful system stored procedures

sp_helprotect [object_name]
Returns a report with information about user permissions for an object, or statement permissions, in the current database.

sp_helptext [view_name]
Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, computed column, or view.

Full list of System Stored Procedures

How to set Microsoft IIS to 32bit on 64bit server

go to %systemdrive%\Inetpub\AdminScriptsrun cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1go to  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727run IIS installer aspnet_regiis.exe -iAllow 'ASP.NET v2.0.50727 (32-bit)' under Internet Information Services/Web Service ExtensionsDisable 'ASP.NET v2.0' if exists (this is 64bit version)Restart IIS

Model-View-ViewModel in WPF