Viewing 15 posts - 7,426 through 7,440 (of 7,470 total)
If you don't like bulk-insert, you can minimize logging with simple-recovery-setting (sql2k) or truncate-log-on-checkpoint (sql7) when using small transactions. This means you have to chop up your input in chuncks...
March 10, 2003 at 1:08 am
Take a look at sqlserver books online (BOL).
db_datawriter can update all tables in the databasen, except is that user has been denied write rights. look at BOL.
March 5, 2003 at 12:57 am
I know it's primitive, but it works.
set nocount on
go
create table Ttest (id char(29) not null, info varchar(20) not null)
go
insert into Ttest values('10069905,7/31/2002,2020705358','380214 196145 0000')
go
insert into Ttest values('10069905,7/31/2002,2020705358','380214 197183 0000')
go
insert into...
March 5, 2003 at 12:41 am
If nothing found in the KB then I'd go for the working solution. Upgrade to sp2 move the 6.5 dbs and afterwards upgrade to sp3.
February 20, 2003 at 5:46 am
I've installed sql2ksp3 with success, but DTS gave me headaches. All worked but those connecting to DB2 UDB V7.2 (rtm version). Contacted pss and it took a couple of days...
February 20, 2003 at 12:46 am
I've installed sql2ksp3 with success, but DTS gave me headaches. All worked but those connecting to DB2 UDB V7.2 (rtm version). Contacted pss and it took a couple of days...
February 20, 2003 at 12:37 am
that goes also for those using a comma as decimal point (user setting!).
February 20, 2003 at 12:14 am
Must have been for Valintines day :))
I've got a sp3-dts problem in a transfert from db2os390 to sqlserver(local). Still working on it with MS. I'll keep you informed.
February 17, 2003 at 1:04 am
February 14, 2003 at 2:15 am
I too have an xp_sendmail problem. This occurs on a w2k-sp2 clustered server (i know mail is not supported on a cluster, but anyway) Every once in a while it...
February 14, 2003 at 12:38 am
take a look at : Microsoft Knowledge Base Article - 814064 BUG: SQLBrowseConnect May Cause an Access Violation in the Client Application.
February 10, 2003 at 12:31 am
try this :
Setup.exe /upgradesp SQLRUN INSTANCENAME=MSSQLSERVER SECURITYMODE=Sql UPGRADEUSER=sa UPGRADEPWD=<sa pwd>
February 5, 2003 at 12:27 am
what if that original node is gone ?
February 5, 2003 at 12:14 am
Great article. Especialy the conclusion, wich IMO should be put en a red colour and an extra bold font.
January 27, 2003 at 3:26 am
Viewing 15 posts - 7,426 through 7,440 (of 7,470 total)