It is same as the initial snapshot.

Schema changes are replicated by transactional replication.

set identity insert on

dba_neo (6/10/2010)

---

Friends,

when iam transfering data from one db to another db in two different servers using DTS wizard,the error message DTS throws is destination table contains readonly column and...

I would recommend moving tempdb data file from the last drive; as heavy tempdb activity could slow down the log write of other user databases.

Right click on the maintenance plan. Select Modify

Above the maintenance plan name there is bar with few icons.

Click on the icon with tip Reporting and Logging. It is next to...

On a single server, mirroring works between two instances.

If you drop and recreate an object, you have to grant all the permissions again to the users.

If you alter an object, all the existing permissions will be remain.

Timothy.Cloud (4/23/2010)

---

I have been asked if I can setup replication to get those 2 servers identical in case we need to fall back to the physical vs. the VM.

Can this...

Insert/Update/Deletes cause index fragmentation.

Alter index rebuild/reorganize is used to defragment index.

Your stored procedure has only one task or many?

Use WAITFOR between tasks inside the stored proc.

How many CPU's are there in the server?

You can limit the number of CPU's...

There is a script in BOL to rebuild/reorganize indexes.

Icon does get updated automatically. You need to refresh.

venkatreddy.bashi (4/15/2010)

---

The size of the log file is not reducing even I took the transactonal log backup.

I am sure the the log file has no active transactions, because when i...

Any plans to upgrade to SQL Server 2008 Enterprise Edition?

It has native backup compression option.

Another third party tool for SQL Server 2005 is Idera's SQLSafe.