Here is the link to my post on CM Crossroads.
Saturday, December 25, 2010
I came across this problem of backing up all the databases on my SQL servers (and there were 70 of them). I didn't want to back them up using the SQL Server GUI. While searching on the internet I got my hands on this script.
Friday, December 24, 2010
Want to get rid of the SQL Jobs in your SQL Server? All of them are stored in msdb. You would need to run the following queries to remove them. If there is a scheduled time that this job runs at, you would need to first remove that.
Tuesday, December 21, 2010
I've been into positions multiple times where I've to delete the databases in my SQL Server environment to clean up the QA environment or my local machine where I accumulate these test DBs over a period of time. If you are looking for one such situation here is the script that can come as a help -
Wednesday, July 21, 2010
Friday, April 30, 2010
Delete and Truncate are both commands in SQL to remove data from a table. But why do we have two commands? Are there any differences? YES! There are differences although the result is same. Both of them delete the data.
Monday, April 19, 2010
As we have already discussed in the previous post, OOPS characterizes objects by their class. So, if you only know the name of the class, you can name some of the characteristics of an object, such as even if you don't know what a BMW is, if someone tells you that it belongs to the class car, you would know the basic characteristics.