Browse by Tags

How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

Published 20 May 8 3:12 AM | SSQA.net

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...

Filed under: sql server, backup, table, drop, stored procedure, tsql, best practice, views

TSQL script for deleting backups older than 1 day

Published 10 September 7 4:34 AM | SSQA.net

Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get...

Filed under: sql server, databases, backup, maintenance plan, drop, tsql, forced, older