Viewing 15 posts - 38,146 through 38,160 (of 39,456 total)
You reinstalled v6.5? Was this on the same OS or was it upgraded? I've seen some funny behavior of v6.5 on W2K and have moved all servers back to NT4.
Steve...
January 31, 2002 at 9:23 am
I believe this is a SQL 2000 item. You might need to upgrade the SQL version.
Steve Jones
January 30, 2002 at 4:48 pm
January 30, 2002 at 12:30 pm
January 30, 2002 at 12:30 pm
In SQL 2000, create the db first with the correct collation. Then detach, copy over and attach.
Steve Jones
January 30, 2002 at 12:29 pm
If you have added extended stored procedures, then you might have an issue if it is not installed on Node B. Keep in mind that there is a real copy...
January 30, 2002 at 10:24 am
I think this is ok, but I am wary of the appending. I always write a new t-Log backup and overwrite so that I have multiple files to restore, but...
January 30, 2002 at 10:20 am
January 30, 2002 at 10:07 am
Not sure about v6.5. There is a replace in v7/2000. check the BOL on v6.5
Steve Jones
January 30, 2002 at 10:05 am
January 30, 2002 at 9:56 am
I've had some issues with the Copy Database Wizard, so I tend to not trust as much, ubt when it works it is slick.
You can shut down the server and...
January 30, 2002 at 9:53 am
The databases mus be defined as the same size with the same number of devices in v6.5. So the new v6.5 master you create must be EXACTLY the same...
January 30, 2002 at 9:35 am
FYI. I'd change that first. Using Sa, as I'm sure most would agree, is a Worst Practice.
Steve Jones
January 29, 2002 at 12:56 pm
January 29, 2002 at 12:54 pm
Not sure what you mean by "density". High selectivity is a poor choice for the clustered index. In other words, a PK is a poor choice. Each item in the...
January 29, 2002 at 12:53 pm
Viewing 15 posts - 38,146 through 38,160 (of 39,456 total)