no one can help?

at least is it possible?

oh, this post help me a lot

i was going to make a post asking how to resotre a database with a new log file and deleteing the big old one

thanks...

ah ok

big thanks again

the procedure worked just fine, i just had to enable xp_cmdshell by using the Surface Area Configuration tool .

thank u a lot all who helped

one more question why xp_cmdshell  is recommended...

ah ok

but is there any alternative to use it inside a query?

i might want to hold the server name in a declared variable inside an sql query

so i want to...

how can i use that?

cant i use a function or query?

i did some research my own and i fixed the problem 10x all anyway.

i Checked network protocols for SQL Server in the SQL Configuration Manager application. the VIA protocol was enabled so i...

2005-10-30 15:35:44.79 Server      Error: 17182, Severity: 16, State: 1.

2005-10-30 15:35:44.79 Server      TDSSNIClient initialization failed with error 0xd, status code 0x36.

2005-10-30 15:35:44.79 Server      Error: 17182, Severity: 16, State: 1.

2005-10-30...

can i ask where i find those?

sorry didnt know that

here is the error text:

" the request failed or the service did not respond in a timley fashion.Consult the event log or other applicable error  log for...

ye right hehe!!

yes its a transactional replication !

well no triggers and replication is working fine!!!

i didnt find those triggers even i checked the some tables on database B that i know its participating in a replication and i  didint find them.

:S

ok man thanks a lot.