Sorry for the delay. This one was covered by new emails in my inbox and I am just getting to it. I did not try piping the output to a...

If you right-clicked the script in SSMS Object Explorer and clicked Modify then it would have scripted the proc to a new Query Window as an ALTER PROC script. After...

Very cool, thanks for sharing *adds to rss reader* It looks like they've fallen a little behind though. No new posts since...

You're welcome. I would let Ola's script handle the updating of stats using @UpdateStatistics = ALL, @OnlyModifiedStatistics = Y and @StatisticsSample = 100. Note these settings will do a full...

This can go into your Execute T-SQL Statement Task:

EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @LogToTable = 'Y'

You can just call the SQL directly, no need to use sqlcmd there.

If you pull that EXEC into a T-SQL Statement Task in your MP that will get it to...

lawson2305 (9/5/2012)

---

I do not see an execute package task in sql 2005 options for maintenance plans.

How can I execute these jobs so that the plan waits?

Is there a way to...

Scott Newman-212556 (9/5/2012)

---

You need to change the provider when the job runs. It's running under the sqlserver:/ provider. Just do a cd c: at the top of your...

You're most welcome.

I have to admin, I have very little experience with SQL Server admin as it relates to SharePoint (not since 2007 and only a very small install). You...

lawson2305 (9/5/2012)

---

Ok I think I almost have everything up to snuff finally but a few last questions. I want to use these provided index and integrity check operations from...

I setup a recurring Outlook Task to remind me to check for new versions every two weeks. I will typically plan to roll out relevant updates to a Dev server...

tamil.selvanmca (9/5/2012)

---

hi,

I've been working on sql server.

I want to protect the mdf file with password.

I develop a windows application with sql server back end, i install into a client system,...

Correct to what end? What are you trying to figure?

For next time, know that you posted in a SQL Server 2008 forum. There is a SQL 2000 forum on this site as well.

OK, this was a known issue in...

What build of SQL Server?

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel;

Have you...