Wednesday, 10 March 2010

Searching table name against all databases

-- to hold the all table names
DECLARE @TableDetail TABLE ( TableName VARCHAR(128)
, DBName VARCHAR(128)
)
-- inserting the each table from each database
INSERT @TableDetail(TableName
, DBName
)
EXEC sp_MSforeachdb @command1='use [?]; SELECT name ,''[?]'' FROM sys.tables'
--search specific table name
SELECT TableName
, DBName
FROM @TableDetail WHERE TableName LIKE '%SalesHistory%'

Tuesday, 2 February 2010

Changing SA Password in SQL Server 2005

For Enabling Sa Account:
ALTER LOGIN sa ENABLE
Changing Password:
ALTER LOGIN [sa] WITH PASSWORD=N'pass@123'