SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

Your database may get damaged due to several reasons. A backup will help you to restore the database lost in case of disasters and problems, like hardware failure, virus attack, or others. How To ...