Archives for: "December 2006"
Listing all databases backup
Dec 14th
Are you sure, that you make your db backups?
CREATE VIEW ViewLastBackup
AS
SELECT a.name 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
Dec 14th
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 »