Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2001-05-17 : 02:19:00
|
| The title explains the problem. Now as to when it happens. Up until this evening DTS has worked just fine. Now the past few times I've tried to use it it crashes. The only place it happens is when I choose to 'copy objects' and then I go to select only the objects I want. As soon as I hit that button, I get a 'memory could not be read' error in Win2K(this is using MSSQL2K). This of course poses a bit of a problem when I want to upload stored procedures and what not. Do I need to reinstall, or maybe just scandisk and defrag?On a side note. This is done while connecting to a massively shared SQL Server at the web host. In DTS, when I enter their server, the list of available databases pops up within a few seconds. When I go to view my database via EM, it takes it on the order of 5-10 minutes to come up. When I connect, it insists on displaying *all* of the DBs on the server, is there a way to only get the one I have there? Or is there a way to make it work faster, like it does when I use DTS? |
|
|
|
|
|
Keeeeeeeerash!