I have a blog post for that:

http://spaghettidba.com/2014/09/05/database-free-space-monitoring-the-right-way/

Hope this helps

Is there a particular reason why you're restoring the master database? Wouldn't it be easier if you copied the noncontained objects (logins and the like) with scripts?

I'm afraid it's not available to you unless it's passed in as a parameter from the caller.

drew.allen (9/4/2015)

---

spaghettidba (9/4/2015)

---

Good to hear!

Please note that my form of the query and J Livingston's are the same: the default for the ORDER BY clause in OVER is ROWS BETWEEN...

Possible solutions:

1) Don't log from the stored procedures. Use a different connection from the application.

2) Log to a table variable and dump the logs to the permanent log table at...

Good to hear!

Please note that my form of the query and J Livingston's are the same: the default for the ORDER BY clause in OVER is ROWS BETWEEN UNBOUNDED PRECEDING...

Can you please add more information to your question?

See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidelines.

Great! Just to clarify, the code takes advantage of the OVER clause to perform a running total.

You can read more about it here: http://www.sqlservercentral.com/articles/T-SQL/75466/

If your IDs are not unique, this could work:

SELECT T.ID, SUM(T.amount) OVER (ORDER BY T.ID) - T.amount

FROM (

SELECT ID, SUM(amount) AS amount

FROM #temp

WHERE Type = 1

GROUP BY ID

) AS T

Also,...

IF your IDs are unique, this should do:

SELECT T.ID, SUM(T.amount) OVER (ORDER BY T.ID) - T.amount

FROM #temp AS T

The one you prefer. I would use tempdb to avoid clutter.

If I understand correctly, you have to update the data in AcquiredFrom using the data in source_office on DPROSQL.

In this case, you just need to copy the data of source_office...

Sorry, I hit "post" by mistake and then edited back my answer with more details.

Feel free to ask for clarifications.

The simplest (but somehow not recommended) solution would be to create a linked server to DPROSQL in FS3.

Then you could simply issue this:

UPDATE AF

SET AF.SomeColumn = SO.SomeColumn

FROM [dbo].[AcquiredFrom] AS AF

INNER...

Spam, reported