Also asked here: http://www.sqlservercentral.com/Forums/Topic774795-146-1.aspx

No more replies to this thread please.

Would you mind please moving...

Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?

http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx

http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx

My home file server (domain controller, sharepoint server) is running Server 2003 and has 4 drives in a RAID 5 config. Served me very well earlier this year when one...

Not structure. If a table's design changes, all procs dependent on it are automatically marked for recompile....

Edit: Nevermind, the post above (and the one below) is spam.

One problem, one thread. Having multiple threads for the same problem just wastes people's time as they answer stuff already answered.

Please post table definitions, sample data and desired output, also the full definition of the proc and the parameters that you're calling it with. Read this to see the best...

This doen't look like it has anything to do with the system tables, and it's also asked here: http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx

No more replies here unless they're related to the system tables please.

That's nothing to do with networking...

Silverfox (8/21/2009)

---

Can I moan about the activity monitor in 2008 then, the fact that you cannot easily resize the columns in the views or the fact that I find it...

Using the DAC doesn't allow you to modify the system tables. Even on SQL 2000 (iirc)...

You can't change the collation of system tables. In fact, you can't change system tables.

I see you're changing collation, what specific problems/concerns do you have that you want/need to change...

I don't see anything to do with system tables in that thread.

The proc's execution plan will never be cached and a new one will be generated each time the proc runs. Good for procs that have no single optimal plan or...