Viewing 15 posts - 331 through 345 (of 489 total)
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...
April 26, 2002 at 6:38 am
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...
April 15, 2002 at 7:13 am
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
April 4, 2002 at 7:54 am
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...
March 28, 2002 at 6:52 am
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...
March 22, 2002 at 10:20 am
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...
March 21, 2002 at 3:35 pm
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...
March 21, 2002 at 7:14 am
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...
March 15, 2002 at 2:06 pm
Another question comes to mind about this. Can you have a SQL Server 2000 master and SQL Server 7.0 targets?
Robert Marda
March 15, 2002 at 12:42 pm
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...
March 15, 2002 at 3:02 am
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
March 14, 2002 at 1:06 pm
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...
March 13, 2002 at 7:34 am
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...
March 13, 2002 at 6:48 am
Yes it is extremely useful.
Robert Marda
March 12, 2002 at 4:55 pm
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...
March 12, 2002 at 4:38 pm
Viewing 15 posts - 331 through 345 (of 489 total)