That is probably why you are not able to do data export over the network. I am not sure about it though but for the first handshake, I think it...

Do you say kapeesh??:hehe:

I hope he is not trying everything in the script folder on production ... 🙂

This is what scared me most...

If the cook is good, you should try the Biriyani or Kerala Fish Curry/fry. They are very good. 🙂 We use real spices to make the spicy, not Chilli powder...

I do not know if this is a joke... :unsure:

I am keeping away from it...

Born and educated in Kerala, India (Southern tip of India). Our state is known as Gods own paradise because of its beauty. Back waters, Mountains, forests, beaches and historical monuments....

What account is your SQL service running on both machines?

ooops.... Thanks for the correction Paul. I thought the OP wanted to delete all records from table1 when there is no corresponding email in table2.

Great catch...

delete from table1

where email not in (Select email from table2)

This will delete all records that does not have any corresponding email address in the second table.

When you are trying to retrieve the history, try to find out what is happening. Try sp_who2. Also try to get the history using T-SQl by joining sysjobhistory and sysjobs...

It could be because you are keeping the history of Jobs for a very long time. You can limit this by changing the values in the properties of SQL Server...

You can write power shell scripts to read from event log using WMI. There are samples out there and you can search for them

The columns shown are sortable. Just click on the column you...

I havent tried it yet. I will try it next time... :hehe: