For my users, they would expect the same answer either way. One way to handle that would be that if the @Fromdate is greater than the @Todate, simply switch the...

I see your point. But the end-user would be confused by the output.

In reality if I were deploying this I would likely disallow the user from inputting a @Fromdate...

Sure, here are the results of 2 calls using your posted code:

Select [dbo].[fn_TotaltimeBetweendates] ('06/13/1990', '08/18/2014') -- Returns 24 Years :2 Months :5 Days

Select [dbo].[fn_TotaltimeBetweendates] ('08/18/2014', '06/13/1990') -- Returns -25 Years...

Thanks for taking the time to create and share your code. I found that when the @FromDate was more recent than the @ToDate the returned answer was incorrect. I simplified...

Daniel,

Thanks for taking the time to share this script. I have a question though.

Wouldn't your transaction logs backups that are performed AFTER you shrink the logs and return to...

Patrick,

Thanks for taking the time and effort to make this script available to us. I find it very useful.

However, the first section will not work in SQL 2012. The...

Thanks for taking the time and effort to share this code. Very useful. I did run into one problem though. I received this error but ONLY on a single...

David,

Excellent script. Thanks for posting.

One small point though; the size for tempdb that is found in master.sys.master_files is the NOT the actual size. It is the size that tempdb...

Greg, Thanks for taking the time to create and share this script. I ran into a few issues though.

1. The existence check: IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE...

Look in BOL:

"EVENTDATA returns data only when referenced directly inside of a DDL or logon trigger. EVENTDATA returns null if it is called by other routines, even if those routines...

A very handy script. Thanks for taking the time to share it. I did however run into two cases where the CREATE USER portion did not return anything:

01. If the...

Makes sense. Thanks again. This is a very useful query.

Lee

Jason,

Thanks for taking the time to post this article. One question though: What is the purpose of the WHERE clause:

WHERE st1.text like '%sys.sql_modules%'

Thanks again,

Lee

I also get the same error.

Lee

Thank you Sean.