kd11,

Your "new query" contains this restriction - where a.wvgroup != 'TIMENTRY'

I don't see this in the "old query". Do you get the same results when this is either...

While the heading of this document is "SQL Server 2000", it applies to server consolidations, in general. I found this helpful as a starting point, but created my own...

Great question - still got it wrong, but learned a lot in doing so...

Cindy

I can't say from experience, as I use Enterprise Edition, but the link indicates it should work with Standard as well.

Cindy

Just an off-handed comment. I'm personally not a fan of in-place upgrades. If feasible, I prefer to install the new instance, then migrate from the old instance to...

There are more folks on this forum who know more about memory config than I do, but here's how I would approach it assuming that the server is hosting only...

<whining>

Got it wrong because of the syntax error. Last week, I got the QoD wrong because I fixed a syntax error that I shouldn't have fixed. The question...

Same version that I have. Does SSMS crash when you script it as create or alter, or just when it's opened in design? Can you post the code...

Does this happen with every database, or just views in one particular database? I haven't experienced this error either.

Cindy

BOL is always helpful in these situations...

http://technet.microsoft.com/en-us/library/ms191545.aspx

http://technet.microsoft.com/en-us/library/ee915054(SQL.100).aspx

Cindy

For SQL Server 2005, you just need to apply the SP to the primary node. I've always applied it to the same node where SQL Server was originally installed....

You know that "rock" and "hard place"? Guess where I am. SQL Server is the new-kid-on-the-block in a predominately Oracle shop. I'm tasked with using the SQL...

I would love to hear other approaches as well. I can tell you how it was designed where I was, but I don't highly recommend the approach for the...

You can find out if it's set by running select @@options

then reference this link: http://www.mssqltips.com/tip.asp?tip=1415

The link has a "readable result" query for all of the user...

Here's a useful link that should help you.

http://www.sqlservercentral.com/Forums/Topic914723-391-1.aspx

Cindy