Thanks for the replys

I will go throw this thoroughly.

Thanks for the replies Dudes.

the above link is not working it seems it is throwing error like

Server Error in '/' Application.

Hi friends

i my self resolved this FTP issue in below the query

exec s_ftp_PutFile

@FTPServer = 'X.X.X.X' ,

@FTPUser = 'abcuser' ,

@FTPPWD = 'abc123' ,

@FTPPath = '' ,...

hi friends

Instead of ftp can we use Replication if we can use what type of replication is applicable for the task

i read in the the google It is possible in...

Thank you very much all

I will go through the above links

No body responded till

Please reply

Thank you very much for your reply i will try today and let you know ,

Any other suggestions will be highly appreciated,

Thanks in advance

Thanks for the reply, i checked that link

Is there any setting need to be change in database sideor level for reset_connection timeout (sid) or for to avoid spid blocking...

please reply

if i configure datbase mail iam getting another error

error:

ate 5/19/2010 12:13:49 PM

Log Database Mail (Database Mail Log)

Log ID 125

Process ID 5072

Last Modified 5/19/2010 12:13:49 PM

Last Modified By NT AUTHORITY\SYSTEM

Message

1) Exception Information

===================

Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: Could not...

i configured database mail in sql 2005 after configuring when i send a test mail throwing error loke

The mail could not be sent to the recipients because of the mail...

Hi Thanks for replies

i have checked database mail services has been enabled

checked the settings in Surface Area configuration - features

Iam using Sql server 2005 Sp2 Dev Edition

Any other...

Hi,

I tried this got sucess please try run below quries

EXEC sp_resetstatus 'yourDBname';

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb('yourDBname')

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET...

This task Now we r planning to go new server(DELL R410)for Sql 2005 Enterprise Edition with Win server 2003 enterprise edition.

so migration is not in the same server it on...

Thank for reply

Any further valuable suggestions please.

Thanks in advance