This sounds interesting and we certainly have enough spare monitors around. We probably have extra video cards too.

How do you move from one screen to the other? How...

I use maintenance plans as much as possible and had planned to start using MultiServer Administration until I ran into a possible complication with clustered servers. In any case...

If you start finding ways (or think your finding ways) to block less experienced people with sa priveleges from performing tasks just to see if you can stump them.

Robert Marda

If I add an event and then the date for the event changes or the event is cancelled will I be able to make these changes or do I have...

If you have a way of reading the transaction log file then you might be able to. As far as I know this will require a tool not provided...

If you want to look into system tables you should be able to compare them between the two servers to find the differences using a query or stored procedure.

The way...

For performance and security the static SQL is likely the best choice. For development time the dynamic SQL would take less time. After that, the maintenance time required...

If you search on alerts, automatic administration and in BOL you'll see that this seems to indicate that it is not limited to jobs but can also be applied to...

Another question comes to mind about this. Can you have a SQL Server 2000 master and SQL Server 7.0 targets?

Robert Marda

If it would work for SQL Server 7.0 I would try it. I currently use a dos version of pkzip so that I can use the command line and...

Yes the way tmorton suggested is certainly better. I got too caught up with using DATEPART and failed to find a simpler way.

Robert Marda

Hmmm... It never occured to me that I could access the information in SourceSafe and generate scripts from there.

What we have been doing is forcing the developers to place changes...

We began using SourceSafe in Oct 2001. However, we only use it for stored procedures and for rollout scripts. I use the difference feature to analyze differences and...

Yes it is extremely useful.

Robert Marda

Yes, what you have now won't give you an error.

Make sure when you sort by the date column that it is sorting it in the order you want. I...