Accelerating into the Future with Wisdom about Technology! Ingrid Byllemos
Hi !
If you are installing a new SQL Server and would like to transfer the logins from an old SQL Server, without doing a SQL restore, then you can do it with a script.
Take a look on this article How to transfer logins and passwords between instances of SQL Server; here Microsoft describes how to do it. Read the rest of this entry »
If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.
If you are a SQL Server administrator or just working with it, these commands would be use full for you.
ALTER INDEX
Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.