Nice!

Thank's Chris

I was ultimately able to do what I wanted from the following link

http://sqlblog.com/blogs/tibor_karaszi/archive/2009/05/14/sp-altermessage-is-back-in-business.aspx

Cheers!

Thanks Clare

Could it be something to do with the fact that you migrated from SQL Server 2005 (Enterprise) to SQL Server 2008 R2 (Standard)?

For e.g. Index rebuilds with ONLINE are only...

Thank you Gail.

Regarding the first point u made, I was going to break the mirror before switching to bulk-logged for log shipping. Since mirror is on a LAN restoring and...

Nice! Thanks Ninja

Yes it is Enterprise edition...

and I am rebuilding non-clustered indexes online no issues

Just trying to figure out the mechanics of how a Clustered index can be built online considering that...

Thanks GSquared you are absolutely right!

For now I have figured out another method to get what I want

Thanks again for your response.

Anish

Hello Folks!

Thank you for your responses. I managed to also solve the issue with the log shipping problem.

Since, there were a lot of VLF's in my Tran Log, the log...

Hello Gail

Thanks for your help on this issue. So, I followed the instructions from the following link:

http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

And shrunk the log file of the said DB and then grew...

Hi! Pavan

This solution worked....thank you very much!

Anish

SQLFrenzy

That did not work!

Regards

Anish

Thanks ALZDBA 😉

ALZDBA (10/27/2010)

---

do you also need to "decrypt" these columns ?

If you answer is "No" or "I don't care rubbish is published", just put blancs or NULL in your...

Hi Lowell

The hashing is just being used to obscure the data. So, I will not be doing any string matches....

Anything that needs to use the customers personal details will be...

Hello Folks!

So, taking suggestions from here, I am trying to update the customers table which has over 66 columns and almost a million rows. We have decided to use the...

I would like to avoid changing the datasize as far as possible. The issue is that it is a 3rd party app which we maintain....so, if we break the app.....we...