sp_helpfile if you want it file by file, instead of just a total DB size which sp_spaceused gives.

sanket kokane (11/22/2012)

---

that isn't like you...

vikingDBA (11/21/2012)

---

Unfortunately, I have a food court server with several databases for almost as many applications. Some vendors have access to their databases. Also unfortunately, some have db_owner...

This is the code that I use.

USE [DBA]

GO

CREATE TABLE [DB].[DatabaseFileUsage](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[DatabaseName] [sysname] NOT NULL,

[FileID] [int] NULL,

[FileSizeMB] [decimal](18, 2) NULL,

[SpaceUsedMB] [decimal](18, 2) NULL,

[FreeSpaceMB] [decimal](18, 2) NULL,

[LogicalName] [sysname] NOT...

You will need to ensure that you have CIFS ports open so that the file copies can take place, ports 135,137,138,139,445 also the SQL ports need to be open. ...

On the notifications area of the job, you have set it to email a operator if the job fails, correct?

If so you will need to ensure that you have enabled...

You will not be able to stop people who are sysadmins from looking at the database, people who are sysadmins have full control to do what they want when they...

Remember that Google (or other search engines you prefer) are your friend, all the information you have asked for can be found by a few searches on the internet.

1 -...

If it can be done set based do it set based.

Cursors have their place but getting the information you want here isn't one of them in my opinion.

I wouldn't use a cursor that's just asking for trouble.

I will attach the copy of the script I use tomorrow which utilises the above script and inserts to a table.

Just watch out for using undocumented features like sp_msforeachdb if you have special characters in your db name it can cause problems

Yes you are, your xp_sendmail maps to sp_send_dbmail so you need to ensure you have database mail enabled and configured

Have you enabled and configured database mail?

Well if you use that procedure and pass in the parameters do you get an email from it?

EXEC msdb.dbo.sp_send_dbmail

@profile_name = '',

@recipients = '',

@body = '',

@subject = '' ;

http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/