Try removing the begin tran and commit tran - every time you run your update, the same rows are selected because the update hasn't actually committed the changes yet.

If you...

Verify the connection string for the maintenance plan - do you have another instance of SQL Server that this plan could be accessing and running the backups on?

Use...

fawwad (9/26/2010)

---

I have even tried Maintainance clean up task but no effect.

when i am going to...

Craig Farrell (9/23/2010)

---

LA drivers are nuts. If there's anything remotely faster by 0.1 second, they'll be squeezing into it, even if the last 1/4" of your bumper's in the...

Bad driving? Try driving anywhere in southern california when it sprinkles. If you haven't had the pleasure, imagine watching multiple vehicles performing 360's on the freeway at 80...

Sorry - but no, there is no option available for marking space inside a file as reusable.

Your best option is going to be using a separate file for each transaction...

To copy the data, you might want to try SQL Data Compare. You can download a fully functional trial edition from Redgate.

When you perform the comparison, it will generate...

Another thing to note is that you don't need or want to run DBCC CHECKDB ... WITH DATA_PURITY all the time. In fact, according to BOL - you do...

Okay, I see what you are saying. But, if that was required you could always use the execute sql task.

So, yes there are issues where certain built in tasks...

sqlbuddy123 (9/15/2010)

---

Shrink Database Task doesn't have the reorganize option avialable in SSMS and TSQL. It has only TRUNCATE ONLY and NO TRUNCATE options.

...

Steve Jones - Editor (9/15/2010)

---

The maintenance plan is going to run the same things T-SQL scripts will run. The only difference is it's compiled.

I would be interested to hear why...

Yes, you can install x86 on your x64 system - but why do you think you need to do that? There are a few known issues where you would...

Start up Profiler and trace the login event -...

JC-3113 (9/14/2010)

---

Hi derrick

well I must be having a really bad day as i cannot see it

i canot open up the task that does the backup as that gete ther min-max...