I can't substantiate it but I think it is possible.. I'm guessing though that you have a CPU bottleneck for 1 or more processes..

CEWII

Input column should be defined as character in the data source. Using a derived column component in the data flow you will build an expression to test for numeric,...

Fuzzy is only allowed to be used in Enterprise and Developer versions.. And allows imprecise lookup operations where the text of a name "Rosie" might be matched to "Rose",...

I think steps 1-4 are a bit paranoid.. And this coming from a paranoid techie... The database will be a mirror of the 2000 with some underlying updated...

SQL Server 2005 BOL (Nov 2008)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm

32767 is the max number however there may be limitations imposed on express versions, can't remember..

CEWII

I can see 2 possibles for an out-of-memory, the first is that SQL is squeezing it out, I ahve seem this occur on a machine where there was not enough...

Are there other files there? If not then there might be a permissions issue on that file alone.

I can't remember is an ending \ on the dir was required:

xp_cmdshell...

My very first thought was WOW, there sure are a lot of sub-selects in that..

I think you are trying to accomplish too much in a single query, you have like...

Also, SP1 is availabe.. You might install that..

CEWII

You probably will have to query on of the reportserver db tables to find out about the last run status of the job. I don't think there is another...

All I can say is User Access Control (UAC) in Windows 2008 (and Vista) just KILLS me I get way too many windows for it to provide me any real...

Sounds like we are back to transactional replication again..

CEWII

do an:

xp_cmdshell 'DIR \\remoteServer\public'

Does it return the directory or does it error out with an access denied message?

I think there is also a /SKUUPGRADE switch.. It might just be in 2008..

Lets start with terms..

SQL Login = account that allows you to access the server, but not really any databases.

Database User = a user account in a database tied to a...