Tuesday, June 9, 2009

Enterprise Manager related

Executing query on EM: Timeout expired
execute using Query Analyzer instead
* to empty table with million of records, use these commands (may have to repeat a few times):

SET ROWCOUNT 100000
DELETE FROM Table


EM shows "No items" under Databases folder:
Re-register the SQL Server in question.

No comments:

Post a Comment