If all you want is to order the result set by the price, do that, not use the row_number() function.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=371677

Check that thread out, might give you some ideas.

Most systems I have seen that needs images, have used SQL to store the location on the file system where the images are stored, not to store the images themselves.

If you look in the SQL Error log there should be some more details.  Like the Severity and the State.  If you look up 18456 in Books Online it will...

Maybe I am missing something... but why even have that order by in there?

In most cases yes.  There are some issues that I have found with some versions of Access and Excel if they are used to connect to SQL 2005.  As always,...

What does that step do?

So this bugged me, had to be a better way.

exec

master.dbo.xp_msver

Index = 4 is for the platform, in mine says...

At least my question got you to look at the right screen!  Good information to know for anyone else out there doing an upgrade from 7.0.

What type of maintenance plan?  If you are trying to do transaction log backups only those databases that are in Full Recovery mode will show up.

Dynamic SQL.

declare

@sql varchar(2000)

select

June 12, 2007 at 7:56 am