http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

That is probably the most common on the net today.

If you are using the same session you are probably using the same account. You didn't use a runas in the shortcut for bids or ssms did you?

You're welcome.

When you attempt to run this in BIDS, are you using the same account that you use to run SSMS?

Many people use different accounts to launch SSMS versus to launch...

You can do this.

SET DATEFORMAT YDM

declare @mindate datetime='2014-25-03 01:02:03'

declare @maxdate datetime='2014-26-03 02:03:04'

select cast(

(cast(cast(@maxDate as float) - cast(@minDate as float) as int) * 24) /* hours over 24 */

+ datepart(hh, @maxDate...

Don't poke the bear. Or...

skanker (3/26/2014)

---

While I can understand companies not keeping up with latest software versions running a website like this on 11 year old technology must be a big risk. Perhaps...

Thanks Andy. I enjoy this style of questions you have been doing.

I can imagine the fun that could be had. :ermm:

Dove

You are welcome.

hmbtx (3/20/2014)

---

Jason:

Pardon my ignorance on this but I just want to make certain I understand you.

Are you saying that I can do the following:

Using SSMS connect to the remote SQL...

No.

You just add the sql agent job to execute each of your required scripts.

That should work.

I have installed EM on Win7 in the past and gotten it to work.

Another option would be to convert those MPs to script based routines.

The maintenance plans between versions are significantly different.

You won't be able to create those plans in that way.