Script All the Stored Procedures, Views, Triggers and Functions from The Database

In my previous post I have show you how to generate database script using Wizard. In this article I will show you how to generate script for database object programmatically or using query In SQL Server 2005/2008 Management studio you can script all the database object using ‘SQL Server...

SQL Server – 2008 – Generate Script of Database, Generate script to copy whole database schemas and All other object in database, like Tables with data, SPs, Views, Triggers, Functions, Database constraints etc.

Check how to create a script using T-SQL While we are working on any project and uses SQL Server as a database, we often need to copy database schema either with data or without data to create database on other server. So it inspires me to write down the blog post about ‘how to generate SQL script...

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.  The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.  (provider: SQL Network Interfaces,...

How to display Image in Repeater Control from folder?

Download full project   Recently I was working on a project where I needed to dispaly an images into Repeater control from Folder. So I thought let me create a blog post for that and share it with my reader. It is very simple to display an image into repeater control from folder just like below. In...

How to make Firefox the default browser?

If you have more then one browser like IE, FF, Safari or Chrome then windows or any other operating system needs to know which browser to use by default? This article will show you the step how to set firefox as default browser.From the menu bar select on Tools → Options and it will open following...

Table and Stored Procedure helptext using Keyboard - SQL Server Keyboard Shortcut

In the world of programming keyboard shortcuts are very useful for fast developing either in SQL server, DotNet or any programming language or any database.In my project I always use SQL Server for backend and for editing or viewing SP or Database Table structure I used right click on Database object...

How to Exclude your Own Visits From Blogger Stats?

When we are developing any blog or website then normally we want to watch the traffic on our site or blog. There are lots of traffic source tracker sites and tools are available on the net, but I found 2 more effective tools where we can check our traffic stat very easily. 1 is Google Analytic and second...

How to Prevent or disable copy content of your blog/site

If you want that visitor will not be able to copy your content from web page then it's easy using JavaScript.It's not full proof way there are other alternate they can copy but it will not be easy way for them to copy content by just selecting required content, right click and click on copy.Just add...

Generating a random number in JavaScript

Today I was working in a DayPilot project it was something like Google or outlook calender. In that project when I was creating or editing event, it was using java script popup. But it was showing old value rather than new or updated value when popup open. This was happening due to JavaScript because...

The New Google Analytics Available to Everyone

The New Google Analytics Available to EveryoneHey Google has recently launched the newer version of the Google Analytic to track the site or blog traffic. I am very happy after seeing the newer version of Google Analytics and Google has announced that it is in beta stage and available to every user...

List of All Built-In / System SQL Server Stored Procedures

Hey today I was searching for some system procedures to get system data and I found that on MSDN there is a list of all the native/system procedures with explanation. It took some time for me to get the exact stored procedure what I was searching for so I thought it will help others as well so...

Disable Back Button in Browser using JavaScript

 While we are developing any web application then some times it's necessary to disable the back button effect from the browser. This is common in banking websites and other sites where security is major concern. User may hit the back button from the browser and forget to log out from the site. There...