Tagged: Commands

How to transfer user logins between to SQL Servers

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 more »

DBREINDEX and INDEXDEFRAG example

If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.

Read more »

Some usefull SQL Commands

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.

Read more »