Here's how I have set it up (with thanks to whoever provided the original code)
1. Create table for CheckDB results
2. Create store proc to apply CheckDB to...

SELECT 'c:\Programmefiles\Dicument\file1.txt' AS txt INTO #temp

UNION ALL SELECT

'c:\Programmefiles\Dicument\Subdocument\file1.txt'

UNION ALL SELECT

'c:\Programmefiles\Dicument\Image\file1.txt'

UNION ALL SELECT

'c:\Programmefiles\Dicument\Text\file1.txt'

SELECT REVERSE(SUBSTRING((SUBSTRING(REVERSE(txt),CHARINDEX('\',REVERSE(txt))+1,LEN(REVERSE(txt)))),1,CHARINDEX('\',(SUBSTRING(REVERSE(txt),CHARINDEX('\',REVERSE(txt))+1,LEN(REVERSE(txt)))))-1))

FROM #temp

DROP TABLE #temp

I use the following code (inside a scheduled job) to extract the data and email it in HTML table format:

(disclaimer - this is my version of similar code that was...

re

You need to include the schema as well:

grant select on [ServerN].DataBaseD.mySchema.Table to userM

just to take the shrink / don't shrink discussion a little further, how about the following scenario:

You have a mirrored database that is reindexed say once per week, and the...

Here's what i use to monitor scheduled jobs. The following code runs every morning in a scheduled job step and emails me the last run status of all scheduled jobs...

just a suggestion....this is the type of syntax that i would use for a report query of this kind (i.e. when there are parameters that may or may not be...

For some reason, when I ran this query in it's original form, it returned NULL rather than the name of the latest .bak file

I changed the last line of the...

an old thread i know....but I had a similar problem trying to do a select into over a linked server. To solve the problem, I ran the following query from...

I discovered the model log growth in a similar way - I had been tracking database (data and log) growth and created a report similar to the one above. That...

I have the same issue - the model database log file grows occasionally. This happens on all our SQL servers. On one instance, the model data file has grown as...

@AndrewJacksonZA - the Rick Astley pie chart made me laugh out loud....the 'glider' avatar indicates you are obviously a Conway's Game of Life fan too 🙂

did you try the code in my previous post?

here is a slighly modified version - it seems to meet your requirements:

DECLARE @openDate DATETIME

DECLARE @closedDate DATETIME

SET @openDate = '4/19/2010'

SET @closedDate...

This will return the number of days between two dates excluding weekends (i.e. Sat and Sun)

It doesn't take account of holidays / other non-working days though:

-- get number of days...

Did you know that 600GB 3.5" 15k SAS drives are available? If the fixed drives are older, chances are you can buy a replacement that is both larger and faster....