How many jobs does this affect?  How long do they run before you get the error?  What SQL runs to cause the error?  Does this happen intermittently, or every time...

Not getting what percentages?  To find the percentage of free space in a file, divide the free space by the file size and multiply by 100.

John

Probably the best way is to split it into individual rows using a splitter function, which will also give you the row number, then reconcatenate with a

Are you looking for four separate rows, or a single row with three line breaks in it?

John

Not sure what your question actually is, but why don't you use a sequence?

John

Yes, this is wrong, for the following reasons:
(1) It is resource-intensive and thus can cause sever performance problems;
(2) It can expose details that may be confidential;
(3) It's...

Your SQL Server monitor should give plenty of interesting information, such as wait stats, from which you may be able to work out what was causing your query to run...

Those were rhetorical questions, meant to make you think about what you actually require, rather than just answer yes.  Never mind - I'll take you at your word.  The query...

What do you mean by read-only access?  Do you mean members of db_datareader?  How about users with VIEW ANY DEFINITION permission?  What about those who have SELECT permission on some...

"750 Euro" and "150 Euro" are text values, so you can't add them up.  You'll need to separate the numbers from the words before you can do a sum.

https://blogs.msdn.microsoft.com/sqlserverfaq/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication/

John

First, that's going to fail if you insert more than one row at a time.  Second, have you considered a foreign key constraint instead of a trigger?

John