Search results for query: *

Can any one help? I am creating a data base diagram by reverse engineering and would like to show the relationship between the entities I have managed to create connections between the entities when they are all on one page. However if I want to show a relationship between one table on one page...

I think what you need is something like this... INSERT INTO T1 VALUES(CODE, NAME,PRODUCT CODE, CATEGORY CODE) SELECT CODE, NAME, [PRODUCT CODE], (SELECT [CATEGORY CODE] FROM M2 WHERE CATERGORYNAME='TEST1') FROM...

In the end the entering the licence details again stopped the licencing error. After that we lost our tape groups. Recreating the tape groups and leaving the tape to mount, after 5 HOURS! the machine sorted itself out and the backups now work.

Can anybody help please Our backups have stopped working as ARCSERVE, after a server reboot, cannot not see the tape drive which is a Compact Storage Works TL891DLX MiniLibrary. However the problem has varying degrees of seriousness. I.E after a server reboot sometimes the Tape drive can be...

Yes Terry could be right. Have created a new installation package for the clients?.

Could use the BCP utility ie from the DOS prompt BCP [databasename].[owner].tablename in [datafile]/t=' ' You might have to 'fiddle' with the parameters to get it exactly right OR You could use BULK INSERT in SQL Query Manager OR You could use import data by right clicking on the database...

Hi, Had the same problem solved it by reloading MDAC (the setup should be on the SQL Server disk) or you can go to the microsift web site. Note the MDAC we used was 2.0 the latest however is 2.6.

Yes, reloaded mdac and it seems to work correctly. Many, Many thanks.

thread 183-262545 is similiar..

- Problem viewing table data from Enterprise manager when viewing table data. I.E when I 'right click' on a table and select open table I get 'unexpected error'. This occurs on all databases on all SQL Server Groups registered on that machine (even ones on different servers). However in Query...