Hi Robert,

I am using MS-SQL Server 2000 installed SP4 and using TCP/IP for connectivity. Still i did not get the solution why this problem occures.

from

killer

Hi Shajan,

If i understand u need to check the connection string of the appilcation and see what username u used to connect the sql server database or check the dsn...

Hi Arun,

Is ur source server is in local location then the fastest way is create the table using linked server.

Or u can use BCP Utility to transfer the data. U can...

Thanx,

I  already set the SET IMPLICIT_TRANSACTIONS ON but if we work on QA without using commit or rollback commands then how can we rollback the transaction.

As per BOL we can...

You can change the column scale to 2

from

killer

Dear Sir,

Thanx for ur reply. But i want help that how sql server uses the user defined log file.How sql server comes to know that now it has to use the second...

Thanx Andrew,

I understand what u said , now i am facing another problem

i used this code for rollback

begin transaction tl

delete from table

commit transaction tl

rollback transaction tl

sql show message the...

Hi,

Can u create linked server respective to ur databases.

from

killer

Hi,

Ok, so we can't rollback the transaction.But can u explain the machenism how rollback work. As i gone though BOL but did not find much information.

But by tlog information in...

u r right Kelley,

Microsoft will refuse to support for that.But somewhere sufian's solution strikes in my mind.

Kelley personally is that right sufian tried to show as i am not much experinced...

No we should not go again.

But we should stop using unfair language on the forum.

We should support others by knowledge but not by unfair langauage.

from

killer

thanx  Gila for ur information

from

killer

Hi,

Thanx Mr Chandra for ur reply

But i think i had mentioned that i dont have any transaction savepoint , not even transaction name

so i think this is enough to...

Hi sushila,

I think u all should not comment to anyone like this. As this is a professional site and we all are professional.

Secondly Sushila as u are pointing to someone and...

do u know how many server are there and path of the file then

 yes then u can use xp_cmd shell to copy file from all the server.

hope it helps u

from

killer