Developers always want to have a list of modified tables or stored procedures while check-in the code or wrapping up the development at the end of the day. some usually keep this list in text file and they update this file every time they modify any table or stored procedure. Here are some handy SQL snippets which can provide you list of the tables, or stored procedure modified in specific duration.

-- tables modified today
SELECT [name],create_date,modify_date
FROM sys.objects
WHERE modify_date>DATEADD(day,-1,GETDATE())
AND type='U'

-- stored procedures modified today
SELECT [name],create_date,modify_date
FROM sys.objects
WHERE modify_date>DATEADD(day,-1,GETDATE())
AND type='P'

You can further modify above queries to get list with objects modified in last 7 days.

-- tables modified in last 7 days
SELECT [name],create_date,modify_date
FROM sys.objects
WHERE modify_date>DATEADD(day,-7,GETDATE())
AND type='U'

Ok, so now it’s possible to add your yahoo friends in Window Live Messenger. You just require adding yahoo email address of your friend in your Live messenger and you can see status of your yahoo friend in WLM itself. You can even send or receive online/offline messages across both messengers. No need to install any plug-in to make your Live messenger communicate with your Yahoo friend.

While creating word documents, another most laborious task is setting same kind of style like font face, font size, font color etc. for desired text block of the document (to give some more professional look to document). Some expert word users may define text style and then use that across page, but most people specifically set font setting on each selected text block. And when they have to use same text style to another text bock, then they will select that text and again set style through using font face/size dropdown and color dropdown to that block as well.

Here is the great tip for those people. You can simply use hotkey Ctrl+Shift+C to copy style of the selected text and Ctrl+Shift+V to paste copied style to selected text. It will keep your text as it is and will only applying style to the selected text block.

So next time, when you have already set font style of header of first paragraph and you want to apply same style for rest of paragraph headers, you know how to do that fast.

Ok, so whenever you have to copy anything in command window, you first require to set command window in mark mode (right click > Mark), and then you can select any content in window.

How about allowing command window to select any content by default without setting it in Mark mode?? You just need to make small modification in your registry.
1. Open your Registry
2. Under [HKEY_CURRENT_USER\Console], find DWORD Value with name QuickEdit.
4. Now double-click this DWORD Value to modify it, which will pop up a dialog box showing Value data as “0″.
5. Modify this value to “1″ and click on “Ok” button to accept this change.

Now open command window and try selecting content by mouse. To copy the selected content, press “Enter” key. For pasting copied content, simply right click on command window, and you are done!

Disclaimer: Modifying the registry can cause serious problems that may require you to reinstall your operating system. I cannot guarantee that problems resulting from modifications to the registry can be solved. Use the information provided at your own risk.

Here is an announcement from .NET Valley posted at their homepage. You probably wonder why they have so clean interface with no content at all. You will get answer if you read their recent announcement at right block of homepage.

Lesson Learned: Always take backup of your data!!!