Thanks . It worked.

Thanks. I will try it.

Actually the Gail's response worked.

Thank you

Any idea?

Thanks Lynn, It worked.

Merci Beaucoup

Thanks.

Faye

Thanks

Faye

Thank you so much Gail.

Faye

I appears that the job owner is sa. However, sa can not open up a particular databas to carry out the task of 'Check Database Growth'.

Does anyone know the...

Actually upon further reading I realised that sql 2005 does not allow connection to linked servers via integrated security. A sql server login needs to be created on both servers...

I ran this code putting the correct server name and a login and a password for the remote access:

EXEC master.dbo.sp_addlinkedserver @server = 'SQLServername, @srvproduct='SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname='servername',@useself=N'False',@locallogin=NULL,@rmtuser='remotelogin',@rmtpassword='########'

Then I right...

Thanks I will try it later today and will let you know if it worked.

Faye

How about using openrowset?

First I tried to establish linked server, but I keep getting the message:

SQL Server 2005: “Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'”.

I searched the internet how to...

Thanks for the reply.

suppose I don't install anything more than I already have on my SQL server which are SSMS, business Inteligence, and SSRS SSAS. Can I run a...

Thanks. I figured it out. I put the text file on my computer then when building the SSIS package instead of using SQL Server connection I used OLE DB connection...