Can you see the SPID related to these transactions? You should be able to see what the update statment was, even if all you do is a DBCC INPUTBUFFER(spid_no).

Also what...

I recommend you do some basic SQL courses. Some one may have time to answer these sorts of questions, but if you read the SQL BOL (books on line) or...

I would check the build was done correctly, particularly that all the databases are on shared resources.

Leo

There are 10 types of people in the world.

Those who understand binary and and...

You would need to copy the ldf file as well to do the job properly.

Leo

I wonder if your original DROP Table command is still rolling back. Could be.

How big is the log file?

Leo

There are 10 types of people in the world.

Those who understand binary...

In a new query window run SP_WHO2 to see if the truncate is blocked by another spid.

Leo

There are 10 types of people in the world.

Those who understand binary and and...

Indianrock (5/24/2010)

---

CV? I raised objections when backups etc were moved to Systems -- don't feel any need ( or use ) in going further with that. As I...

I'd hardly call stopping a production server a "spur of the moment" thing, but it would work. But how do the users feel about the database going off line for...

Round about now I would start dusting off my CV.

Good practice has always been to do SQL Native backups to DISK, then copy to tape. I know some 3rd party...

You may also want to consider adding some database optimisation jobs. Consider rebuilding indexes over the weekend.

Leo

There are 10 types of people in the world.

Those who understand binary and and...

Is this a new build? Has the failover worked before or did this suddenly start happening?

Can you give a little bit of history here.

Leo

There are 10 types of people in...

Working as a consultant I see it all, and many of the companies that call for my service do so because they didn't have the money or feel the need...

sanketahir1985 (5/23/2010)

---

exactly Leo, i do agree with that

i already told them to use temp table approach to resolve deadlock problem

but developers are not convinced with that,so i was looking for...

This is interesting. I know you can (and I have had to) Slipstream the SQL 2008 RTM and SP1 media so the installs are done as one, but I've never...

sanketahir1985 (5/21/2010)

---

but let me tell u my scenario

actually SP_ClientBPS runs after every 5 sec. thru console program

while Sp_IEActiveScreen gets fired randomly by users avg freq is 5-10 hits per...