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?

Litespeed is a great product. However I think Red Gate and Idera do object restore as well. Perhaps hyperbac.

I'd go with the identity value or GUID. Not time.

Be sure you are trying to connect to the same server from both places as well. I've had people accidentally connect to the wrong instance, not being aware of it.

Ah, but how many of those people do you want to ride with? That's the rub in the US, at least it's my guess.

Trapped in a car with 3 people...