Google will be your friend on that one, I have not yet had the need to make a report update a databases, but know it can be done via external...

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

scottsnyder55 (1/17/2013)

---

I need to load only changed (delta) data from 3000 databases into a staging environment that will then be loaded into a data warehouse. The SQL Server versions include...

carlecot88ssn (1/18/2013)

---

The fabric upper will provide good protection and soft touching feeling for its wearer. While the thickened Onitsuka Tiger Tokidoki Mex Lo collar and the additional small piece of...

carlecot88ssn (1/18/2013)

---

Diverse fashion principles can be recognized with different designers. Various people also think of it as the typical vintage style dragged from the early 70s. These explanations are correct...

You will need to give it some sort of ordering sequence that is the order you want.

VARCHAR is ordered left to right so 1/15 and 1/8 are orderd 1,...

What troubleshooting have you done?

That bit of information would have been nice to have on the original post so we knew what had changed.

Can the SQL server ping the cloud...

You can use your SQLServerCentral login on Ask.SQLServerCentral but the two need to be linked.

I had trouble linking mine together, so have two accounts, same name same password, but cant...

Yes if the query it calls is an update / insert / delete proc.

If you want to make it user controlled via a report object then you will need to...

How many steps does the job have?

If 1, you could look at changing the advanced properties of the step to have a retry attempts value of 2 and a retry...

Why use a cursor?

You already have what you want to insert into the table, so just wrap the select into an insert statement, unless I am missing something in your...

You will need to do a link from sys.objects for the object in question to sys.columns link that back to sys.types and pull out any string based columns.

Then write a...

Check the execution plans of the queries, each one will be different in some way

There are many different ways to get to the output.

You could look at ranking functions like...

Ensure you have setup SQL Mail, set the alert system of the Agent to use SQL Mail and the profile, restart the Agent.

That should resolve your problems.

Dependency information is not created or maintained for rules, defaults, temporary tables, temporary stored procedures, or system objects.

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