Search results for query: *

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

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

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

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.

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

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

I need to Backup and restore a database from a VB application. First to backup a database using BACKUP DATABASE etc... in a stored procedure called from VB, there is no problem. But when I use a command RESTORE DATABASE FROM etc... Error Message: "System admin exclusivity...