i am trying to transfer my onyx database from one sql 6.5 server to another. i was able to complete the transfer once but when i applied the service pack to sql i lost my dtc applet. when this happened i had to uninstall and start from stratch. now when i run the transfer i get about 25% of the way through it and then it will error out saying that my login failed. anybody have any thoughts or ideas about this?
View 1 RepliesIs is possible to insert into a databse table values from a table having the same format that resides in another database/table ??
I have tried :
xx = database a (source), yy=database b (Target)
select * into yy.dbo.target_Table from xx.dbo.source_table where.......
this does not seem to work.. any suggestions ???
I have tried several times to transfer a table from one server to another and can not. Tried transfering ind. table and a full object transfer but table will not come over. Any suggestions?
View 1 Replies View RelatedWe have an information retrieval application in which there is a single connection to a database followed by multiple table open, read, and close commands. Response time is consistantly less than 1 second on a LAN.
When Internet connected (not VPN), the first table read is typically fast, but the response time becomes slower and slower after multiple table open, read, and close commands. There seems to be a considerable amount of handshaking based on monitoring of the router's status lights.
Apologies if this post doesn't belong here.
We are in the process of moving steps from a large SQL job to a web portal. The intent here is to allow the user to manually trigger the jobs to run. The problem I am having is in determining a way to run these job steps in the background, thus allowing the browser to take control while the step runs. These jobs can take enough time that forcing the browser to wait is not an option.The steps have been consolidated into stored procedures so in order to run a step, one would call the sproc. What I would like to do is run this in a separate thread and let that thread end on its own while the server transfers back to the client. Is something like this possible? My understanding is that the thread would be orphaned once the browser takes control again. Thanks in advance for any advice.