Try running profiler while VB6 is running script but catch the query execution plans. Then run the query in SSMS and pull query plans. It could be an occurrance of...

Are there any exclusive locks on the server at the time users cannot connect? Any long-running jobs running at the same time that could be causing access issues?

Anything in the error log? Windows application/system logs?

I am no SSRS expert, but it sounds like you would need a separate query to exclude weekends. I am not sure how it could be implemented in the same...

You can look at the Windows Scipting Guide from MSPress for VBScript basics. Also, Don Jones has a good advanced VBScript book. That one is good because it goes over...

Are you saying that the maintence plan jobs fail to send jobs while Exchange servers and DC are having maintenance performed on them or after?

How often does data need to be exchanged? If it is real-time, then it sounds like you would need replication setup, which would require a port opened up on the...

You will have to merge the data from one of the databases to the other and then use that merged database as the publisher.

Otherwise, you will have to setup...

Forgive my ignorance, but aren't those both suggestions to DMVs? That should not be available in SQL 2000, right? Is there an equivalent or similar solution for SQL 2000?

I want to say that I remember hearinb about a bug in SQL 2000 about backing up to a network share, but now I cannot find it. I have thought...

Also while looking for something else..

Does your server domain account have these permissions on the local server:

Setting Required Permissions

To perform its functions, SQL Server Agent must be configured to use...

Did you get an .ldf file as well with the backup, or did you just get an .mdf file? It appears that from the error that either the log file...

Are you saying it is giving you an error when you try to open a .sql file with another program, or is it just that .sql files are defaulting to...

Lookup backups in BOL, specifically, look at the section where you are creating a database from a backup. I believe there is an example in there as well that will...

I would think that you would want to use either the ODBC driver for DB2 or the OLE DB driver for DB2. Both seem to support connectivity to an AIX...