1
vote
2answers
223 views

SQL Server disk space sizing

I have 8 SQL Server installations (on 8 separate servers). I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making ...
0
votes
3answers
4k views

How can I give a SQL Server user permission to run one stored procedure and nothing else?

I need to be able to remotely monitor the disk space on a SQL 2005 server. To do this I need to give a sql server user the ability to run the following stored procedure: EXEC xp_fixeddrives; ...
0
votes
2answers
2k views

How can I find the amount of free disk space only using SQL Server?

I have a SQL (2005) server for which I need to monitor the amount of free disk space. It is not currently running a web server so a normal ASP/.Net monitor page won't work in this case. Is there any ...
1
vote
3answers
399 views

Opening Trace in SQL Server Profiler Using Disk Space

I've got a server set up with a smaller c: drive for applications and a huge d: for storage. I've recently run a SQL Server trace using SQL Server Profiler and stored the results to file on the d: ...