NO SP1 is installed on the server .

SQL server 2012

Windows Server 2008R2

Any help from the other members!

It cant be possible to set unlimited growth.

So, that is the reason, I am looking for some thing that will help us.

I am that confident on creating my own.

Can one please help me providing some documention how to implement it.

Good Post AQLAJ,

It give information on Drive Spaces at certain threshold.

But, I am looking at a threshold alerts when the database (files MDF & LDF) reaching the MAX...

Thanks SQLAJ

yes i mean by alerts..sorry misspelled.

when the files are nearing max sizes. how to implement it.

If there is any good blog post, how to set up please forward...

First created the Table. And then running the DECLARE InSERT into statement to load into the table DatabaseFileUsage.

My understanding is the statement is loads in to the table...

Anthony,

it execute good, But gives an error on the table. below is the error message.

I have created the table in one of the user databases

Msg 208, Level...

Thanks Anthony

When I try to execute, I am getting errors, Copied below.

Will it work for SQL server 2012 release?

DECLARE @sql NVARCHAR(MAX)

SELECT @sql...

Thanks for the replay Ed,

But my concern is, I need the Current TIME STAMP into.

I ok with any good post available, Please post the links.

Thanks GSquared!!

I was able to get /* USE Database*/ it as comment section box.

The use of this SP is to ScriptoutPermissions for a database.

example:

EXEC dbo.UD_GetListDBAccess ...

Thanks for all your help..

1)I am not looking databases_files in the Out put.

Example:

DBA_Databasename_Data

DBA_Databasename_Log

2)I am looking for "Use Database" in the our put.

Example:

USE DBA_Databasename

Thanks for your replay GSquared 🙂

Trying to insert the statement "Use Database" into a temp table?

Thanks for your reply Alan

I tried couple of ways, It did not work out

create table ##permission_info (id int primary key identity, information varchar(8000))

insert into...