This has been running since 2006 in 2005 environment. This particular error message appeared for the first time today. This was on SQL 2005 with SP3. We'll...

I don't think...

so it does turn out it was because of the nulls which started to appear after a recent development deploy...great...

thanks for helping out.

Luk (10/28/2010)

---

Ok, so I have two simple queries, one returns rows, and the other one does not

--this returns one row

select

top 10 *

from table1 with (nolock)

where filter1 >...

rew-370421 (10/28/2010)

---

I know I can use SSMS to script DB Objects. However, is there a command line utility or version? I need something where I can script out certain Views...

Yes I did, and this is even more confusing because according to different posts I have gone through my query shouldn't work at all.

So basically the way it looks like...

Did you change server names at any point and time?

But the number of rows to be inserted was 0, so the question is why the rollback ran for so many hours. I can understand that the join might...

The rollback just finished, it took about 3.5 hours to complete.

Thanks for the tip. I already did. I'll look at it again tomorrow.

tlogs are on raid1 (2 disks), and the data files reside on raid5 (6disks). BCP files are on raid1. I'm able to push 100s of thousands of rows...

The distributor db along with the snapshot folder are on seperate disks. For the time being I changed these tables to be replicated via snapshot once a day. ...

We had this problem some time ago. It was being caused by one of the CLR procs written by another company. We are now in the process of...

no it doesn't. it gets created and then deleted when the transaction is rolled back.

I did, but it still deletes the file.