Archives for: "December 2006"

Listing all databases backup

Are you sure, that you make your db backups? CREATE VIEW ViewLastBackup AS SELECT AS 'DataBase', Backup_Date, Days_since_last_Backup FROM master.dbo.sysdatabases AS a LEFT JOIN (SELECT database_name,MAX(backup_finish_date) AS Backup_Date,… more »

Listing a specified field in a database

Sometimes you know the field name, but forget about in which table it is. This small procedure will help you ;). USE AdventureWorks --- the database must be specified GO CREATE PROCEDURE procAllTableswithField(@columnname nvarchar(400)='%') AS… more »