Hi thanks for the reply,

the KB says it is applicable to 2003 OS and AWE enabled.

Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)

Microsoft Windows Server 2003, Datacenter Edition (32-bit...

zombi (2/23/2009)

---

Hi All,

Main question i want to ask is do i have to migrate the system database as well? If i want to migrate all of the above things.

Thank...

DDL Changes were increasing the column length

We had setup Transactional replication,

Today we have done the below changes

We supposed to do DDL Changes to the replicated tables so

1. Instead of removing the replication we

...

okay,

Thanks for the tips... I do not do it next time....

By mistake I did it 🙂

data is not in sync between publisher and subscriber, please sync the data.

hey the query you are using is wrong it is running only on master database

I just copied and ran in query analyzer I am getting the errors and I...

I think this might be the problem of software versions.

I believe still your backup file is in use

1) Try to take the backup to different location to make sure there is no problem from sql server side.

2) Delete...

CSS SQL Server Engineers post is very useful

Yes that will kill the processes

The_SQL_DBA is right..

What Megistal is telling is right..

:hehe: Your manager is interesting........... 🙂

There is another difference

In SQL Server 2005 you can have one backup job and multiple copy and restore jobs to different servers. ie. One-to-Many (One Backup job --> Many...

yulichka (2/4/2009)

---

I am writing a code, but before I run this code, I need to check if anyone is using that db, if yes kill that user? Is anyone know...

Hi,

This is a known bug that is fixed with SP1.

Find the below URL for more info....

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/5924074f-5f1c-444a-bd09-fc3e999f2637/

and

http://www.sqlservercentral.com/Forums/Topic359308-338-1.aspx#bm361850