2 Tim 3:16 (2/17/2009)

---

Just a shot in the dark.... if you have any kind of system level backup you can get your .mdf and .ldf files from...... you...

Thanks Alvin

I got the impression that they were talking of release timescales more in line with 36 months, hence why I thought 2008 -> 2010 (factoring in the Microsoft delay...

K. Brian Kelley (2/17/2009)

---

There's been no official announcement beyond the BI upgrades, so far as I am aware. However, the updates such as Policy Management are certainly worth the upgrade...

That error message usually means the network's gone wobbly when we get it where I work

Have a look at this article:

http://www.dbazine.com/sql/sql-articles/larsen8

It's not quite what you're after, as it only looks for connection names, but it could point you in the right direction

Thanks for the heads-up and the link, Greg.

The sql server instance these packages reside on is used purely to host these packages and the SqAgent jobs that run them, so...

That's very nice Gianluca

I'll be looking to do some sort of cleanup in the near future (our stored procedure population seems to grow at a rabbit rate...), and this will...

Gianluca,

I'd be interested to hear a bit more about the VB project you wrote.

Did it use SQLDMO (or whatever it's called these days), and append text to the StoredProcedure object's...

true, but I suppose at least you could eliminate a lot of SPs from the list of those that need further investigation!

Ah.

Ignore me,...

You could create an SSIS package, using SQL Tasks to execute the SPs.

Then you could use a proxy to execute the SSIS Package job step type (which does accept proxies)

Beyond altering your SPs to include some sort of logging statement, I don't think there's anything simple you can do.

You could set up a Profiler trace to run over a...

Try

HAVING EV.ExtraValueID IN(24699,24701,24706,24707,24710,24713,24734,24779,24740,64346,64350,24760) OR EV.ExtraValueID IS NULL

Thanks folks

I am in the process of adding clustered indexes now.

As I'm deleting/inserting nightly, I expect that these indexes will start getting fragmented again soon.

The database is pretty small, and...

To reword my question (so that it hopefully makes more sense...):

Would a Windows account that's set up in msdb as SqlAgentOperator need explicit permissions to be able to perform all...