First you need to post in the appropriate place. Are you having trouble with the SQL or something else?

Second, you haven't described what is wrong, what you've done, or...

You need to post in the appropriate forums for your question. I've moved this to T-SQL, 2005, but if it's not the right place, please let me know.

Someone came up with this forumla for displaying things based on rating, views, age, etc., to try and show the most popular.

It doesn't work.

We're going back to reverse chronology here...

Are they correct on the server or your workstation?

It needs to be on the server.

Can you connect with Query Analyzer?

If not, you need to be sure that the connections work. The easier way is to transfer data from 2005->2000. You can select the data...

Scott,

Honestly I think that this can be handled with allowing them read only access.

They shouldn't "review" a sproc from production, they should get it from source control and review it...

Pushing data is hard, especially disconnected. I think you'd want to pull data when you're connected and then have it available when you're not. be sure you're tracking times here,...

I think it depends on what you are trying to learn. Ss2K5 is so wide, so many parts, that I don't think you can cover the entire product in a...

Chad has the right idea. I'd actually not send email from a trigger as that puts the email inside the transaction, which isn't something you might want to do. Typically...

It will make some difference. Whether it will be noticeable is something else. It depends on your load on the server.

I'd think about moving to a R1 and a R10...

I've run a restore a week with something this large and crossed my fingers it was working the other days. The issue is that often you might not even know...

The issue appears to be in the tag system. It's meant to work with browsers, not as much with the Zune and other devices. We kind of hacked it in...

:), Hugo, it's not often I'd beat you to anything.

I've voted on Connect and please feel free everyone to add a vote (mark the stars in the upper left) and...

I agree with Grant. Make it consistent. Either way can work.

You can't. The compiler will return the scalar value stored in productname. You can't make part of the statement dynamic and part static.

Why not just write the queries you need?