Posts tagged Server
Endeca – “Unknown Host Exception using eaccmd”
01 year ago
in Endeca
Earlier today, one of the database servers that I manage wasn’t responding. This turned out to be due to a Windows Update that caused the server to restart, but the server didn’t come back properly. We restarted the server again and it seemed OK.
Because this happened in the middle of an Endeca [...]
Transfer Logins and Passwords to a new server
01 year ago
If you need to transfer the logins and passwords from one server or instance to another server or instance, please refer to this very useful article from Microsoft:
How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Generate a list of tables for all databases on a server
02 years ago
in Transact-SQL
The following Transact-SQL can be used to generate a list of tables for all the databases on a server:
USE master
GO
DECLARE @dbID INT
DECLARE @name VARCHAR(500)
DECLARE @sql VARCHAR(1000)
CREATE TABLE #databasetables
( DatabaseID INT,
DatabaseName VARCHAR(100),
TableID INT,
TableName [...]
