Posts

Showing posts from February, 2013

Codesmith template to create the entity from Sql Server View

http://dbvt.com/blog/post/CodeSmith-Template-to-generate-Business-Objects-from-Views-Step-by-Step.aspx

SQL Sever create a user with rights only to view a particular View or to execute only a particular stored procedure.

SQL Sever create a user with rights only to view a particular View or to execute only a particular stored procedure. CREATE LOGIN user1 WITH PASSWORD = 'abc@123' GO CREATE USER user1 GO CREATE ROLE AccessMonitoringViewRole ; GO EXECUTE sp_addrolemember AccessMonitoringViewRole , user1 GO --GRANT EXECUTE ON dbo.sproc1 TO execRole --this line is for granting execute on stored procedure --below line is for granting view on a view GRANT SELECT ON [dbo] . [vAccessMonitoringView] TO AccessMonitoringViewRole GO

Install Cisco System VPN Client on Win 7 64 bit

http://weblogs.asp.net/bhouse/archive/2009/01/15/how-to-successfully-install-cisco-vpn-client-on-windows-7.aspx

Realtime WPF/Asp.net client updates from Sql server database

Hi I was searching good way to implement client side update in WPF App and showing it into Dashboad whenever data in the Database gets updated. Below is the link for the same. http://www.codeproject.com/Articles/144344/Query-Notification-using-SqlDependency-and-SqlCach#heading0007 Regards, Sam