You are adding a column "DescriptionManual", yet in your queries referencing "ManualDescription" - am I missing something or this just a typo?

Your update should look something like:

UPDATE [Core.Projects]

SET ManualDescription= [Whatever...

You're getting duplicates because you're only looking at ItemCode...

select ROW_NUMBER()

over

(

partition by td.itemCode

order by td.itemCode

) as Seq, You might want to partition on [Bin Label] as well (depends on what you're...

Undo whatever you did so you can run the code below to get a baseline (as Gail and Jeff stated, your keylookup may not be a bad thing - you...

Please post your actual update statement that you are "binding" from the application - we may be able to better help...

Thanks Jeff! Unfortunately like Sean's solution, it works great for smaller tables - the one I'm looking at has 127,170,878 rows of data and has a data footprint of 532,771...

You said users couldn't update the Description field, so you were adding a new column to the table named Description1. Correct?

So...in order to successfully use an update statement, you...

Thanks for the code Sean. I let it run for about 20 mins and killed it...

These tables are rather large :crazy:

Going to do some creative "googling" and see what...

Is the profile set to public or private?

You could try: ALTER TABLE [YOURTABLE] ADD [Description1] varchar(255) NULL

And something simple like:UPDATE [YOURTABLE]

SET Description1 = 'Your new description text'

WHERE ContactID = @ContactID

Then to get the proper description field:SELECT...

You can set the "Reply Email" and "Display Name" attribute in the DB Configuration Wizard, you can also override these settings during the sp_send_mail execution

I've actually never had an issue with the SSIS task, from my perspective it works perfectly. What kinds of issues have you encountered sqlBuddy?

I set up the task:

LoginsToTransfer =...

Not everyone "enjoys" using it, but it is pretty powerful - and I guess you could tell by my tone that I'm not particularly fond of it 😀

You would need...

In your admin for the dell RAID controllers, have you checked to see if the batteries are showing warnings? I've seen issues in the past with Dell servers getting slow...

If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep the...

Also look in the actual report server logs (should be located in ..\MSSQLSERVER\Reporting Services\LogFiles) and post if anything is amiss there