If changing the Rights doesn't work, you might want to try creating a named shared instead of using the hidden C$ share.

I've only been here a short time now, but some of the questions I see are just painful to read.

From the answers I've seen, there are a lot of very...

Sumanta Roy (6/4/2009)

I tried with the above solution but not getting the solution. Can you tell if any IIS setting is required or entry required in SMTP server to send...

You can still use SQL Mail in 2005. There is legacy support for it. When I did my converstion from 2K to 2K5, I actually found it easier...

I use this Windows help file frequently when referencing SQL commands: tsqlref.chm

You should be able to find it amongst your SQL installs.

Is there any reason you can't drop the flat table, and then recreate it using the select into everytime you want to update it?

There is also the OSQL command that you could call from a BATCH file. Here's an example below:

osql -E -n-1 -q "Select * From SERVER.DB.DBO.Table"

Google / Knowledge base search...

If you have DB_Mail setup, then yes.

EXEC msdb.dbo.sp_send_dbmail

@profile_name =...

If I understand this correctly you can use a Task in the DTS package.

In the Package Designer click the drop down menu "Task" then select "Execute SQL Task"

This will give...

Don't forget to check over any DTS/SSIS packages you might have. It is very easy to hardcode a server name in those and not even realize it.

I don't agree with ripping other people's work off, but haven't you ever heard of Google?

If you already have a TSQL script created, and easy fix would to put this line at the top:

USE [DatabaseName]

And then your code. If you need to run for...

Thanks! You saved the bacon.