There really isn't anything that will show the growth over time - but, you can look at the backup history of the transaction log and see what times are the...

I'm sorry - but what mail interface? You cannot use SQL Mail without installing...

There really isn't a formula for figuring this out, as there can be a lot of factors for how large a transaction log will need to be.

Simply put, the transaction...

phil.curtis (1/26/2010)

---

I need to configure SQL Mail on a Windows 2003 server running SQL Server 2000. I don't want to install Outlook to do this. I've read about...

If you cannot use runas or ShellRunAs - then you are not going to be able to do what you are asking.

Are you sure you are performing transaction log backups every 15 minutes? With a transaction log file that large, and the data file that small - it is hard...

Because SQL Server has the SID - it can use that SID to perform an AD lookup of the username. It gets the actual name from AD and does...

If you get a notification - one of the tasks in that job failed. You then view the history for the maintenance plan (not the agent job) - and...

I will start my comment with the fact that you should change your process to either REINDEX or REORGANIZE - not both.

Now, the reason this plan does not work is...

To select data based upon today's date, you can do the following:

SELECT {columns}

FROM {table}

WHERE YourDateColumn >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

AND YourDateColumn < DATEADD(day, DATEDIFF(day, 0, GETDATE()) + 1, 0);

This...

Nope, sorry - still can't change the fact that you cannot use T-SQL to start SQL Server. You have even more problems though...

1) What are you going to do...

There is a standard report available called Disk Usage that will show the autogrowth events since the last restart of SQL Server.

Those events are stored in the default trace.

With that...

In order to be able to use xp_cmdshell - you have to connect to SQL Server. If SQL Server has been shut down, there is nothing for you to...

You can shutdown SQL Server using T-SQL, look up the SHUTDOWN command in Books Online. Once the service is stopped, you have no way of running any commands when...

BSavoie (1/23/2010)

---

Thanks Phil, this is really not about employees at all. I just thought that might make my example a little easier to explain. This is really about exporting data...