:::: MENU ::::

Search within Store Procedure Text !

Recently Needs to find  ‘/’ character in Sql store procedure body and replace with ‘\’ Now Having about 100 Procs and its really boring job to open each proc and have check for it ! .. so find out small handy sql query so that it will give me list of procs contains specific string […]

SQL Server Database Diagram Creation Error

Recent database backup restore come-up with new error while tried to create database diagram “Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a […]

PIMPL (the beauty marks you will want your libray to have :) )

Private-Implementation is a Software Engineering paradigm which allows us to enhance encapsulation, reduce compilation times and retain binary compatibility. The idea here to add another layer of abstraction between the library and the user code. The Story Consider that you are create a library which you will be shipping to customers when done. Since Software […]

String Contains Method with StringComparison

if a string contains another string ignoring the case, there is no method available for string with ignore case we can create extension to string using following ! public static bool Contains(this string original, string value, StringComparison comparisionType) { return original.IndexOf(value, comparisionType) >= 0; } Happy coding !

Export File Name in SSRS Report Viewer

In Sql Server Reporting Services ReportViewer control, if one needs to setup default file name for Export then in page_load or other appropriate event following line of code will workout setting up the file name ! ReportViewerControl.ServerReport.DisplayName = “YOUR DESIRED NAME”

Report Viewer Page Height and Browser

When Reportviewer page viewed in Firefox or Google Chrome ( Non IE Browsers) sometime it doesn’t load properly , that is just because of DOCTYPE Tag of aspx Page <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> Remove DOCTYPE Tag and add following property to Reportviewer will solve the issue of page height For some […]