Search results for query: *

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...

Sorry terry ALTER TABLE "MyTable" NOCHECK CONSTRAINT ALL doesn't allow to truncate table ! another Tips ?

thank you tlbroadbent that is exactly what i need ...

I'm using MSDE I want to delete all datas of a database(60 tables with relations, indexes, contraints...). I can't use truncate table (Relations...), and Delete * from Table1,2,3 ... take a long time. Question ? does it possible to create a SP 1 to get a script with all relations...

I'm a new user. What is the differences beetween OLEDB connection to a SQLSERVER7 database and Native connection to SQLSERVER ? Witch is a best option to create Reports using CRAXDRT in VB6 ?

I'm trying to backup and restore a SQL7 database from a VB program using a SQL commands "BACKUP and RESTORE" via ADODB.connections. To backup it no problems. To restore a database it is necessary NO USER connected to the database. I execute a RESTORE command using a connection to...