Viewing 15 posts - 991 through 1,005 (of 2,387 total)
BCP is much fast to import text file comparing to DTS.
October 9, 2003 at 1:32 pm
What is your Sqlservr.exe version?
October 9, 2003 at 1:31 pm
I guess you got error '605'. Here is the resolution from BOL. Suggest you run the optimization in single-user mode.
"Error 605
Severity Level 21
Message Text
Attempt to fetch logical page %S_PGID...
October 9, 2003 at 1:21 pm
Someone posted similar question few days agao. You may search that.
I have seen this problem in one of my servers and hardware vendor is pointing to possible hardware issues.
October 9, 2003 at 1:16 pm
quote:
1. I tried to run an update query on a tbale with 36 million rows. I removed all indexes and keys...
October 9, 2003 at 1:14 pm
Check SQL Server errorlog for "Performance monitor shared memory setup failed: -1", If you see it, install ms03-031.
October 9, 2003 at 7:44 am
When you installed default instance SRV001, IT was assigned a virtual ip address, 111.111.111.111. When installing named instance, you can create SQL Server virtual server name as SRV002\NM1 and assigned...
October 9, 2003 at 7:36 am
Create new device with command DISK INIT, extend default segment to new device using sp_extendsegment 'default', yournewdevice and expend database to the new device with ALTER Database command.
October 8, 2003 at 2:49 pm
You may have look at http://www.red-gate.com/ and DTS, BCP from BOL.
October 8, 2003 at 2:11 pm
Try download BOL (SP3A version) from Microsoft and install it.
October 8, 2003 at 1:54 pm
What login information do you look for?
Check sysdtspackages table in MSDB.
October 8, 2003 at 1:17 pm
Viewing 15 posts - 991 through 1,005 (of 2,387 total)