The triggers run most of the time, this is an exception that the tiggers cannot run.

The asp code is not messing with the schema, but it has has a...

This is what I found:

Schema stability (Sch-S) locks are used when compiling queries.

I think because our select query is embedded in asp, so it gets compiled each time it...

So when I add (nolock) to the tables, each of them get a sch-s lock?

Oops! I guess they are in-compatible.

Thanks Gail!

I am running profiler to capture the deadlock chains and deadlock graphs.

One of the processes selects bunch of columns from joined tables, each of them has (nolock) as...

We made the change this morning, both log shipping and replication worked fine, as expected.

We made the change this morning, both log shipping and replication worked fine, as expected.

Thanks for reading. It is working now. I restarted the job again and it succeeded.

Hi, Steve, thanks for the reply. Here is what I am thinking:

For transactional replication, in our settings, the publisher (which will have a new IP) is also the distributor. The...

Thanks, Steve, I think it makes sense.

We kept the trigger disabled for a almost a day, and in the meantime, we exprienced some slowness, do you think the disabled...

The error was, 'Transaction (Process ID 893) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. '. Since I could...

I just tried to first create a database in dev with the exact same name and location as the standby database, then shut down the sql sever service, copied the...

Do you mean backing up the database on standby server? I dont think you can back up a standby database.

The error I got is from attaching the database using the...

Restoring from tape could work, but then its like additional service we have to request from the hosting company.

Thanks for helping.

Thanks for the response. Sorry I was not quite clear earlier. The standby server is actually local. The pipe can handle log transfers fine. It was a long time ago that...