See if this works

although I don't see the point of LowerCase 1 XML element (either do it in front-end), or might as well LowerCase the entire XML

UPDATE TABLE

SET XMLcolumn.modify(

'replace value...

There are a lot of scripts out there that kinda does this, might benefit from them (although they seem to work for SQL 2005 and above, not 200)

http://sqlcommunity.com/Default.aspx?tabid=275&id=288

http://blog.sqlauthority.com/2008/03/04/sql-server-2005-a-simple-way-to-defragment-all-indexes-in-a-database-that-is-fragmented-above-a-declared-threshold/

Usually involves sys.dm_db_index_physical_stats...

what's the result of this code?

is it NULL or NOT NULL?

select object_id('[dbo].[SEEKER_DATA_PLUS_OPTOUT]')

does manually dropping the table (without the if condition) works?

DROP TABLE [DBO].[SEEKER_DATA_PLUS_OPTOUT]

If it's permission-related, I am certain you'll receive...

Did you copy your or someone's post word to word?

Anyway, a lot of solutions in there already

Focus on the "scope", or just put ROWNUMBER in the group detail row

http://www.kodyaz.com/articles/article.aspx?articleid=52

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23440459.html

SQL2005 Reporting...

GROUP BY?

in SQL 2005 and above, ROW_NUMBER can be used as well

SELECT

EmpNo

,EmpFName

,EmpLName

,Dept

,Section

,Duplicate = COUNT(1)

FROM Employee

HAVING COUNT(1) > 1 -- to only show duplicates. Comment this out will...

A case of not to rely on Query Hints all the time

by removing the (NOEXPAND), I think the engine decides to go to the tables directly

http://www.realworldsql.com/post/2008/01/NOEXPAND-query-hint-for-an-indexed-view.aspx

If you have an indexed...

The more the better (and more $$ too)

For SQL Server 2005 minimum requirements

http://www.microsoft.com/Sqlserver/2005/en/us/system-requirements.aspx

I suppose it's just a choice by Microsoft, which I am okay with

If you want to enforce valid XML, either throw in a tag or add a schema (CREATE XML...

Books Online is one of my favorites (online or local), I personally don't think there's any harm in it

It is unfortunate SSMS doesn't have great IntelliSense (even in SSMS 2008),...

I would think Microsoft would certify Microsoft SQL Server 2005 on Windows 2008

but I recalled reading that SQL 2008 actually perform betters on Windows 2008 (not surprisingly)

White Paper: Running SQL...

Google may return a lot of results for what you want

To check disk space, you can run

EXEC master.dbo.xp_fixeddrives

Results

DATEPART Books Online

You can use YEAR(datefield) and MONTH(datefield) such as

SELECT id FROM transactions WHERE YEAR(trandate) = 2008 AND MONTH(trandate) BETWEEN 1 AND 3

YEAR is just DATEPART(year, ___), MONTH is DATEPART(month,...

I can't think of an easy way (like SSRS 2008 Tablix)

because the SSRS 2005 really gives you only horizontal grouping (say Country, Salesperson, Date)

I am curious to know a solution...

This should do the trick

"My Parameter: " + Parameters!MyParam.Value

I had this issue too, trying to find where I found the solution 🙁

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

To fix...