please provide our inputs on above query

🙁

my reporting server and sql server both are in same machine

I'm unable to view MSDTC setting which is installed on 2000 server.

I think , i have to go and re install the services.

I have enable my MSDTC services too..

but still unable to run the query

i have changed the MSTDC setting by checking allows remote client connection, and checking in-bound and out bound...

hi

I'm too facing the same error

i'm running the below query from source server

INSERT INTO <source_tablename>

exec [destination server name].[master].[dbo].[xp_fixeddrives]

Msg 8501, Level 16, State 3,...

Declare @path Varchar(200)

set @path='xxxx'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'

BACKUP DATABASE [xxxx]

TO DISK = @path

Yes I have done that.

Any idea to remove/consider space while taking backup through maintenance plan?

Yes , got it. There was a space at the end of the database name which was found and creating issue.

Thanks a lot

Hi HanShi,

Thank you for responding..

All the backups are taken to same folder . and also SQL Agent also has the required permission on it .

Thanks,

Sita

I have tried deleting the folder and run agin.. but no luck.

It runs good through T-SQL script

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/839b5c27-9bc5-4467-a9d4-e78f9934a761/264-an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established?forum=sqltools

resolved