This query will give you the file growth time, size and duration

Customize it as per your need and you have to have the trace file available on server for that...

+1 to jeff

Start->All programs->Microsoft SQL Server 2012-> SQL Server Management Studio

or

Start-> run-> SSMS

give sa and its password or through windows authentication if you have configured .

does NT AUTHORITY\NETWORK SERVICE has access to msdb with all sqlagent permissions.

To display structure sp_help 'table_name'

MichaelDep (8/7/2013)

---

I have two Windows 2012/SQL 2012 failover clusters that seem to go to sleep at night. I can connect to then with no issues all day long, but...

if you look at services in which account SQL Agent is running under?

greg.celentano (7/3/2013)

---

If you have production environment that is a fail over cluster is it a best practice to have your development environment be the same configuration for testing reasons? I...

if it is...

Does he want to track suspecting other users/team running the SP or not?

First one to find job schedule and second and UDF to give schedule details in proper format.

SELECT dbo.sysjobs.name, CAST(dbo.sysschedules.active_start_time / 10000 AS VARCHAR(10))

+ ':' + RIGHT('00' +...

Is it followed as per the below.

http://msdn.microsoft.com/en-us/library/ms345408(v=sql.100).aspx

Is it referring to proper path

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = 1

This is a 3 year old thread please dont post on this.

can you post the error which you recieved last, check in services sql default service is started or not .

SQListic (7/31/2013)

---

Hi Experts,

We do custom logging into a table. The requirement is that the developers should receive email immediately whenever there is specific data in that column

Any Input is Appreciated

Thanks...