Roy Ernest (10/19/2010)

---

Winash, The connect item was put in long time back and the work around provided was by Bill if I am not mistaken. He was working with me...

You need to provide a column name/alias for the ORDER BY clause to work - the CASE statement won't work there. From BOL

[ ORDER BY

{

...

There's a connect item on this. The workaround to this issue is to change the upload schedule - maybe that helps?

Maybe you need to set the default schema of the user - the user seems to be mapped to the "dbo" schema after your upgrade?

From this link:

A query such as...

Might be related to this? -> http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx

From the article:

The error cause is related to a depleted system resource (non-paged pool, paged pool ,...). These issues have to be tracked down...

You can check this article for information on schemas. There's good information about synonyms in BOL - is there anything specific about synonyms outside of this information that you're looking...

Don't know if this is a SQL 2000 to SQL 2005 replication issue - but what we do is something similar to what you've already done. However we either use...

This document talks about replication and database mirroring (including information on trace flag 1448 which allows the log reader to replicate changes regardless of the mirroring state):

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

I'm assuming...

It is encrypted.

TDE performs a real time encryption and decryption of data at the page level. Data is encrypted before it is written into the page and decrypted and...

Some information available here

There's a section on partitioning in this document - not too much information though and the recommendations there will need a whole bunch of testing and trade...

You've probably already followed the method of transferring data to a new table but here is another approach that uses the MOVE clause to alter the table to use a...

I think the "green arrow" shows up only if the account you're connecting with has rights to start/stop the service. If you right click on the server name in object...

Well - it could very well be that I'm wrong then...:hehe:

This works only for the default instance - not for a named instance. Best way to go about renaming named instances...