Thanks folks for the rapid turnaround on this. I have passed your links to my App/Dev folks so that they can benefit from them before attempting the...
We are going to embark on an upgrade of two separate database that we developed originally by a partner that is no longer on either of our two...
We are migrating a ColdFusion based thin client application with a MSSQL 7.0 backend to MSSQL 2000. Our app/dev team is looking for any...
I am trying to transfer MSSQL Server Agent jobs from a production machine to a test and a dev machine. The orignators of the procedures are not...
Thanks for the suggestion, but I already checked that and it is set that way. Bob
I have a primary database box called VASQL. I had a replication set up to go to a database on a box called VASQLText. I have set up both a push from...
That is the fustrating part. There aren't any metrics that we can agree upon for MSSQL, let alone the application's performance. All I was really...
This is again in regards to my database located in VA. I used the MSSQL Wizard to set up all of the steps associated with replication on this...
We have a server that is supporting several databases connected to the users by a ColdFusion based thin client interface. Several times, the users...
Sorry for not clarifing that earlier. I split out the reindexing and the repairing of data field portions of the complete maintenance plan. After...
Thanks for the help here. It seems that I have been able to set up a configuration that matches all of my requirements. I now have to reverse the...
I had the same problem and found that it was an error with running both jobs together under the same maintenance sequence of events. After I split...
Both machines are logged on using the machine's administrator account which was set up as the same user name and password for each. Also the...
More informatiom.<br /><br />In talking with our partner, the "offending machines" had Enterprise manager up on each of them with a connection using...
I have two servers at a remote site, both runnig MSSQL 7 SP4. One is our production server and one is our on-site test server. To avoid performance...
I am remotely administering a database in an east coast office. It has uses a MSSQL7 database supporting a ColdFusion interface for our users. I...
Separate names with a comma.