As tables contain data in a random order (as we are always told) wouldn't ROW_NUMBER return random values anyway!

I use a staging table to hold the filename and modified date which is populated via a stored procedure.  I then use a Query to order the filenames to feed another...

How are you downloading the file from the ftp server?

Something along these lines?

http://www.databasejournal.com/features/mssql/article.php/1459691

If you bracket "everything" does it work?

= IIF(((Fields!Hazard.Value >=19 AND Fields!Hazard.Value <=76)

AND

(Fields!Complience.Value <=11)),"Excellent", "OOH OOH")

Isn't that the basic understanding: If you can't trust your DBA with your data who can you trust?

Does the SQL Agent account have the correct permissions?

Our car is a 1.9TDi that gets approx. 38mpg commuting to and from work (urban).  On the motorways we can easily top 60mpg.  The fuel is dearer over here so it...

Don't forget about the security issues as well

But this works.

USE

AdventureWorks;

;

DECLARE

@MyMsg VARCHAR(50)

SELECT

@MyMsg =

Have you tried ; (semi colon)

The master database can only be backed up using a complete backup and as such is usually in SIMPLE mode.  As the msdb is in SIMPLE mode no logs are...

According to the link for Adaptec's site read performance is the same but write performance suffers.

Hate to think how much coffee and hair pulling it took to weed this out

Just register a new server and connect to the MSDE on server1