Recent content by 3615

I need to use a SCRIPT SQL to change IDENTIIY column to IDENTITY NOT FOR REPLICATION on multiples Tables. The original column values must be the same after changing property column. This change can be done manually using SQL Entreprise Manager but i need a SCRIPT to change 100 tables on 10...

how to change IDENTIY column to IDENTITY NOT FOR REPLICATION using script. (I need to keep same column values) Thanks.

Exportmodeller.dll and crtslv.dll are necessary and registered .

SQL7 on Windows98. when i start the install replication wizzard, the first step "distributor" sems ok, but in second step "distribution db" the program stop whithout error and i must kill sqlManager using Ctrl+alt+sup. if i use stored procedures to do this job...

when i export a compiled report to any format (.xls, .doc., rtf etc...) i get a blank file (O ko). Exporting a same reports on Win me, 95, 98 works fine. ExportModeller.dll, crtslv.dll , U2...dll are existing and registred. Help Please !!!

ALL export formats get empty files 0ko

Any report exports from CR8 gets empty file (0 ko) using XP. all is ok in other MS OS. Please Help

Easy, short , fast !!! THANKS A LOT DangerPower...

I have the same problem without answer

i have the same problem without answer....

No message SQL manager fail and i can't do anything else. I must use Ctrl + alt + sup to stop it and restart !

I can't transfer datas beetween 2 databases located on a same server. When i use a data importation wizzard from SQL MANAGER(7) SQL MANAGER failed... Do i need a special license to do this job.

Now it's allright ! Before, i must generate a script to keep all existing contraints, then i use sp_MSdroparticleconstraints for all tables, i can delete tables, and after rebuild all contraints using the script... Thanks Terry

Hi terry here is my problem -The tables TABLEA IDA int Lib varchar(10) TABLEB IDB int IDA int FirstName varchar(20) Adress varchar(50) - first i do this ALTER TABLE TABLEA NOCHECK CONSTRAINT ALL - second i do this alter TABLE TABLEB NOCHECK CONSTRAINT ALL -third i try this truncate...

I'm using a VB6 program to execute a DTS Package (SQL7) this is my code Private WithEvents mobjPackage As DTS.Package Set mobjPackage = New DTS.Package private MySub() mobjPackage.LoadFromStorageFile "C:\...\MySql.dts", "" mobjPackage.Execute end sub() I can...