There are countless scripts out there for this, what specifically are you wanting to track?

Try this link 🙂

Did the suggestion help or did you go another route?

Looks good!

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...