thanks, I think my little understanding of programming languages lets me down on this.

i've only ever had exposure to T-SQL as I'm a DBA, never been a developer so think...

BCP will work, get it to output the query into a flat file then upload the flat file to second server.

SSIS is very flexable, what do they mean by not...

can we see the agent alert system screen then and the operators details?

thanks thats the alerts and errors checking out fine, but can we see the rest, dont need to see email addresses etc so you can blank them out its more...

What is the reasoning behind not being able to use SSIS?

There are a couple of others like BCP and bulk insert what you could use, but I would challenge why...

can you attach screen shots of the alerts/operators/sql agent alert system/db mail accounts & profiles/errors in the error log so that we can invesitgate the configuration.

Is this for homework or interview by any chance?

Has this server sent mail before successfully? If not might be AV blocking mass mail worm or something blocking port 25 for SMTP or something along them lines

If it...

duplicate post

replies here please

please see this link

http://msdn.microsoft.com/en-us/library/ms143506%28SQL.105%29.aspx/

DBA at heart, but I do all things SQL related so development of DB objects and SSIS/RS/AS stuff as well as well as everything DBA

you would want to take a look at the action tab on the chart properties

http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx

Around half way down is this sub heading "7. Add a drill-through action on the sales...

Has DBMail been configured, SQL Agent Alert system set to use a mail profile and SQL Agent been restarted to take the changes into account?

Perry Whittle (3/12/2012)

---

anthony.green (3/12/2012)

---

I dont believe this is true anymore, as you can install LiteSpeed in restore only mode which doesnt ask for a licence key as your not using...

MysteryJimbo (3/12/2012)

---

Assuming you fulfill licence requirements for source and destination, you can use litespeed for logshipping.

If you dont you can still logship but you will need to either perform a...