thats kool..thanks again..

made some changes..tables permissions were missing..lets see if that fixes the issue..will update..thanks

user did try running the application by disabling the triggers...same error...my colleague ran the trace before said he cdnt find any helpfull information..ill try once again..thanks...

it is just updating with "0: as the data...it works fine from query analyzer..the error is only seen from doing from the application..thanks.

perfect....thanks again everyone for suggesting me..i did not use it..that is why i wanted to make sure from experienced people here..i just wanted to use for practice..but since it...

thanks..i understand that it cannot be used as a production server...i was just wondering if someone has the files for dev edition can i just copy and install..making sure that...

i did had couple of issues on migrating to windows 2003 64 bit server. Like oracle drivers, Jet OLE db connections. I did get a work around for it. But...

so krishna..should i first execute sys.dm_db_index_physical_stats view and the look at the fragmentation level...and if the avg percentage is mroe than 30 % i will rebuild using "EXEC sp_MSforeachtable @command1="print...

thank you krishna for your response..i did run the view ..i see for couple fo tables it is more than 30%..then i ran the following statement:

EXEC sp_MSforeachtable @command1="print '?' DBCC...

not sure about 2008..

will it give any problem if the data is already there while using REd Gate.thanks everyone

i just downloaded data compare..may i will try..just curious to know?..does it disable the fks..i mean did u have any pbms with thr fks while using data compare?..thanks..

hello try with port no 26.. worked for me all the time..i did suggest to couple other people here on this forum and it worked for them..thanks,

thanks..

yes you are right..on a 64 bit sql server..u will need 64 bit 10g client to connect linked servers..and if your SSIS or DTS packages are using open query to...