Viewing 15 posts - 331 through 345 (of 348 total)
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
July 28, 2005 at 8:55 pm
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...
July 28, 2005 at 12:06 am
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...
July 27, 2005 at 8:01 pm
You can change the column scale to 2
from
killer
July 27, 2005 at 3:10 am
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...
July 26, 2005 at 8:38 pm
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...
July 26, 2005 at 8:30 pm
Hi,
Can u create linked server respective to ur databases.
from
killer
July 26, 2005 at 1:52 am
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...
July 26, 2005 at 1:37 am
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...
July 25, 2005 at 8:19 am
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
July 25, 2005 at 4:25 am
thanx Gila for ur information
from
killer
July 25, 2005 at 4:17 am
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...
July 25, 2005 at 4:14 am
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...
July 25, 2005 at 1:54 am
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
July 25, 2005 at 1:33 am
Viewing 15 posts - 331 through 345 (of 348 total)