Are you able to see any performance info when querying:

select * from sys.dm_os_performance_counters

?

I have had luck with making sure the variable is read/write on the script object properties. Then in the later task, assign it using an expression.

Have you tried extracting the ISO out to harddisk and then trying the install?

WayneS (2/9/2010)

---

CirquedeSQLeil (2/9/2010)

---

Those two tables, no. They are tweener tables. They were technically shipped with...

You have a composite key as your primary key in Dim_Blog and don't use half the key.

If you add

And A.BlogTransID = 1

To your where clause, then a clustered index seek...

Lynn - no.

Brian and Gail (and others) have made excellent points. Gails points are thought provoking in that, a local admin really can do quite a bit on the server -...

Alvin Ramard (2/9/2010)

---

CirquedeSQLeil (2/9/2010)

---

Not sure I want to post this in that thread.

From http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic13791.aspx, Kalen Delaney brings up the stored proc that can changed the ObjectProperty 'IsMSShipped' to a value...

Not sure I want to post this in that thread.

From http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic13791.aspx, Kalen Delaney brings up the stored proc that can changed the ObjectProperty 'IsMSShipped' to a value of 1. ...

GSquared (2/9/2010)

---

That...

Those two tables, no. They are tweener tables. They were technically shipped with SQL Server,...

BaldingLoopMan (2/9/2010)

---

...

However I would never ever withhold my help because someone did not conform to my professional standards or called me mean names. I find that shallow and conceded....

I think the only method to exclude those two tables (sysdiagrams and dtproperties) is to hard code them into the query. Anybody else have any other ideas?

I am testing it. So far, both your query and my query return the exact same results. I also found another extended property on which to limit the...

Yes, this is a very interesting question.