-- 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%'
Wednesday, 10 March 2010
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'
ALTER LOGIN sa ENABLE
Changing Password:
ALTER LOGIN [sa] WITH PASSWORD=N'pass@123'
Subscribe to:
Comments (Atom)