ALZDBA (2/10/2009)

---

- abbreviated -

As always, adding default values for columns is something that depends on the needs of your data model !

If your DA agreed on only having defaults...

larry Hennig (2/9/2009)

---

Ol'SureHand,

You probably have Cumulative Update 2 or higher on top of SP2. Prior to that update, the SSMS maintenance cleanup task - and the corresponding...

Kris (2/3/2009)

---

When a maintenance plan is run it drops a .txt file in the directory. The clean up maintenance plan is set to delete this files after a week...

thank you, Vince!

==============

I used the "new version" embedded in the article even though I am planning on keeping the system log files in the same folder to be on the...

GilaMonster (1/15/2009)

---

Why do you need to shrink the log?

Please read through this - Managing Transaction Logs[/url]

Create the maint plan to back the log up regularly. Shrinking the log on a...

-- I do the following in a Maintenance Plan (SQL2005)

Inserted a T-SQL task after the successful backup and DBCC integrity check jobs.

This goes thru the "simple" recovery_model databases I have...

SSIS Fresher (10/20/2008)

---

Hi all ,,,

I need to use dtexec to execute my job and need to pass a variable to the package...I am using this command but it's giving me...

My (working) solution goes like this - a bit convoluted and scary security-wise,

but I have not been able to find a better way yet.

That is because - to run...