In the past, I've typically done a "drop table", "create table" to handle things like this. The wizard is designed for the basics. If you need this to work more...

refresh?

If the service is running (is this the same instance), it should be there. Try running a job and see if it works.

Don't think so, but perhaps there's a workaround. You could potentially have all reports run the same query to get "variables" from a table. Something like

create table ReportVars

( vartype varchar(10)

...

not that I know of. It's a type of "forward compatability", translating things so that they work on a 2000 type system. Not intended to emulate 2000 completely.

What does the code do? Perhaps we have another solution.

Watch disk space if you have these regularly scheduled.

What's the problem you're solving? Drill down could be a lot. What is the data and how is it used/queried?

Personally, if a person is referring to books then I'm very impressed. I've worked with too many people who were convinced they knew everything they needed and refused to pick...

Could these disks be very slow as well? Or slower?

There is no guarantee that the ports will be the same on a restart. That's why your clients contact the server on 1434 and then get the port for that...

Do you mean you have two sets of tables and you are replicating both to a single table on the subscriber?

If you're turning replication on and off, you might lose...

Two versions tend to be tested/supported on the OS. So I'd expect SS2K5 and SS2k8 were tested on W2K8.

I'd actually look at 2008 as a more stable version of 2005....

You can find deals as well. I got TechNet a few years ago when I took an exam. I got MSDN with my MVP award.

The Express editions will get...

It would seem that they don't know a lot of T-SQL, but that doesn't necessarily mean they can't learn it or aren't a good DBA. plenty of people use the...

Interesting question. Posters in the last year is about 20k, not a lot. But that's the nature of the Internet. Most people lurk or read and don't participate. I've got...