I resolved this by installing SQL2005 sp3

That script works beautifully well!  Thanks!

My tables do not have same numbers of columns.  So most likely I will need to do the text merge.

Any idea where I can find the script to merge the...

Does it matter if I use the Matrix? or Table?  Do I set the visibility of these field int he report property?

thanks!!!

Peter, The info Schema view will only tell me the max stroage capacity of a particular data type. 

For example:

Ntext -->2147483646

varchar --> 255

My requirement is the follow:  Our team...

I agree with ChrisMoix.  Log shipping is more than having a warm standby... Our read-only reporting jobs are taking away resources on our production box.  Lots of our analyst also use...

Understood, but why do they have "Terminate users" option for the Standby option?

From many technical paper, it seems to suggest that even Read-only copy, user will get booted off if...

Thanks,

I guess there is a bug in the Wizard that we need to add this additional step to our restore job.  I got a better script for you!

CREATE PROCEDURE sp_dba_Kill_users

AS

       ...

Thank you thank you!!! Indeed it doesn't clear out the log and I was being able to log ship the transactions to secondary server!!!! and apply the logs successfully.

Nevertheless, I...

Thanks guys,

I do have requirement of not to Lock the table while exporting the data.  Can I be able to do BCP in...

bnordber  Do you know which hot fix did you apply?

My @@version is 8.00.847 July 31, 2003

Thanks, I will talk to the SAN...

SA24, I agree with you regarding to the Maxdop can be set to 1 or 2.  Our default is 0, so it will uses all the processors.  Again, The processor...

I agree with you.  We can do a lot of improvement on making the query more efficient.  But that is not the only query that caused the ERROR 17883 problem. ...

Thanks for all of your responses!  You guys are awesome!

Anyway, I had made my database log property to be simple.  Use set Rowcount = 100000, Delete based on my critieria. ...

Thanks a lot!! that works!  But I thought even if I put the recovery mode to simple.  It will log all the delete as well!  Do you have any idea...