Wrong question.

You should be fixing (tuning) the procedure so that it doesn't...

Please note, 6 year old thread

(and the error's not caused by insufficient free space, but rather by a limit on the size of sparse files)

The instructions look clear enough? What's the problem?

A path is only needed if you want the file written somewhere other than the directory you run the command from (by default...

Can someone familiar with SQL to SQL linked servers help out please

http://www.sqlservercentral.com/Forums/Topic1817509-2799-1.aspx

Msg 7202, Level 11, State 2, Procedure Vw_DBSize, Line 3

Could not find server 'targetserver' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure...

No.

If you switch to bulk-logged, you'll have to take log backups, that's the only difference.

The view has the correct information and you just obfuscated it for the forum?

Hugo already...

If you run just the select statement, does it return results?

Do you really have a linked server named "LinkedserverName,Portnumber"??? If so, why?

And what type of database is it?

ChrisM@Work (9/14/2016)

---

Eirikur Eiriksson (9/14/2016)

---

Makes you wonder what the purpose is and English certainly...

Optimal, maybe. Secure, very likely not.

Mike Scalise (9/14/2016)

---

In other words, from a technical perspective, would it be breaking the log chain to not have that file? Wouldn't step e) forward account for anything that would...

Pages (which are 8kb in size). Most reads/writes shown by SQL, unless specified as in kb or bytes, will be in pages

Try

COUNT(*) OVER (PARTITION BY edata.dbo.e_ClientCases.Client)

sys.dm_tran_database_transactions gives information about how much log space was used for a transaction.

Extended events writes should give you total writes, if the correct events are selected (sql vs sp), sys.dm_io_virtual_file_stats...