I assume you mean multiple instances of SQL server on the same system?

If this is the case, there should be no issues just make sure you use the full...

You may also want to look at your database settings. For example changing from full logged to bulk logged or simple - this will have reprocutions on your backup, but...

CDOSYS is a com object for windows 2000, CDONTS came with the NT 4 option pack. I would recommend you use CDOSYS.

Here's a good article on why http://orcsweb.com/articles/cdosys_cdonts.aspx

also here is...

I found this kb article, hope it helps

http://support.microsoft.com/?kbid=815431

If I move to an ADP I lose some functionality (easily making cross tab...) As well I need to make it Access 97 compatible.

I believe that MS SQL Exec will create script create and insert queries based on your data. Its a freebee here at http://www.sqlservercentral.com/products/#freeware Under tools and generate SQL script you...

What about using a VPN, then terminal servicing in?

One of my most favorite undocumented things in query analyzer is the object browser, and the fact that if you drill down to the table or view and drag and...

tcuscino your a genius! That was it, I was starting to have some goofy problems all around and unhiding the servers (back to 1433) took care the sqlmgr error as...

Assuming 1 raid 5, I completely disagree with having 1 big partition. for 1 huge reason. Recovery. If your os fails, reload it and your apps to the one partition...

I tried each even looked at MTU's. When I look at the switch there is no activity between the server and the TS box. However when I run the same...

I have the exact problem on 2 instances of sql server 2000. Both instances are windows 2000 sp3. Both instances had all services stopped before I loaded the patch. Both...

I would highly recommend that you test your setup. We migrated our PeopleSoft from DB2 to Oracle and PeopleSoft was also very tight lipped. And we ran into huge problems,...

Also look at the web browser in the Sql Server 2000 resource kit or on the web at http://groups.msn.com/OLAPServicesDevelopersForum/web.msnw?action=get_message&mview=0&ID_Message=45&LastModified=4675405111138581414

I have found with any open source system, you will typically make up any difference in cost through employee hours in making the system work. For example, MySQL does not...