Best answer, dont use dynamic SQL.

Doing a quote twice will imply to sqlserver that you need the value of quote.

Consider this statement

select ''''

You will have to modify the value held...

Cross Post

http://www.sqlservercentral.com/Forums/FindPost928060.aspx

Please keep to one thread.

As pointed out , a high number of pages could cause performance issues, but without evidence to the contrary , ie Query performance metrics, that it actually is, i...

Try using sql express, i could be wrong but SSIS is included (at least the run time component)

As stated a backup of 2008 cant be restored on 2000. If it were me , i would investigate using SSIS (taking an incremental difference or the tables) or...

UK Summer came and went yesterday.

Still waiting for FULL DDL and execution plan

Can you show us the code you have so far ?

This is a cross post from

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e433ad80-c1d7-4fa6-bdf4-c6e471ceeb91

Seems like a job for a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Although , at the back of my mind , i didnt think i could be done, i could well be wrong 🙂

If BOL states its supported ,then it is.

Right now...

I dont think that you can upgrade , backup your database , do a side by side install and restore your database into that.

Or by using a case sensitive collation

SELECT CHARINDEX('x' collate SQL_Latin1_General_CP1_CS_AS, 'X' collate SQL_Latin1_General_CP1_CS_AS)

Time is intrinsic to the date time type. Please read this... http://www.karaszi.com/SQLServer/info_datetime.asp

Could be a wide range of things...

Triggers , foreign key lookups, index updates .....

Can you post the execution plan ?