Today I learned an tip from my colleague about finding the last executed statement for a process in SQL Server. [code] DBCC INPUTBUFFER (52) [/code] Here 52 is the SPID, that we want to check last executed statement

Inorder to change the owner of the table to dbo, we can do like this. [code] sp_changeobjectowner '<tablename>', 'dbo' GO [/code]

Suppose you are maintaining some notes in a notepad on a daily basis and you want to add current date and time whenever you finish so that you can keep track of when notes are added. While working in a notead, Press F5 and it will insert current date and t

This very simple statement allows you to count how many times a certain character appears in a string. [code] Select Len('///xxx') - Len(Replace('///xxx', '/', '')) [/code]