PaulB-TheOneAndOnly (11/29/2010)

---

Joseph Fallon (11/29/2010)

---

Hi Pablo,

Thanks for the post.

I'm not too worried about the VB side of things ... all I need is for the Expression that I use for my...

Hi Pablo,

Thanks for the post.

I'm not too worried about the VB side of things ... all I need is for the Expression that I use for my variable to be...

Sorry to thread-jack but I've been getting the same error message recently.

Nothing is being written to the output file I've added.

The Event Log isn't telling me much either

Was running fine...

I could kiss this forum ... seriously 🙂

Changing the permissions seems to have done the trick.

Is this a new "feature" in 2008 I wonder ?

Thanks people - you're the best...

Thanks for the replies folks.

The SQL Service user is in the Admin group on the server so should have ample rights ?

I can't attach the mdf to run any dbcc...

I think you're right there on that.

The Idera Compliance Manager product seems good - anybody have any experience with it ?

Anyways, I've made my recommendations now so we'll see what...

Thanks Lowell, that's mighty - I like it a lot !

I think my boss is keen on something that will work offline, reading the TRN logs.

Anyone know of any such...

GilaMonster (6/11/2009)

---

Is the index really covering for SELECT...

Right ...

When I don't use "SELECT * FROM " the query always uses the covering index. Thanks for the tip Mr Stobbs.

When I DO use "SELECT * FROM " then...

GilaMonster (1/6/2008)

---

I don't...

IIRC so did I 😉

Thanks very much folks.

Looks like I have a renegade "backup and rename" merchant somewhere in the building.

Thanks for the replies.

I know you have to specifically script the indexes from EM, it's not that.

I'm just wondering how the indexes could become divorced from the tables.

Renaming the table...

Thanks for the Reply Jack

I am an idiot sometimes.

What I really wanted was a "Report Header" so I just moved the offending banner to the Report body and hey presto...

Thanks for the post.

I've followed the instructions too but no joy.

One thing I've noticed - when I select the Alert System Properties (Mail Session enabled by the way), I...