master.dbo.xp_fixeddrives

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: payyans (payyans_at_discussions.microsoft.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 05:11:01 -0700

SQL Server 2000
--------------------
master.dbo.xp_fixeddrives stored procedure is reporting different values
when executed by 'sa' and a regular user.
Results:
(When executed by 'sa')
drive MB free
----- -----------
C 18432
D 118784
E 16384

(3 row(s) affected)

(When executed by 'UserA')
drive MB free
----- -----------
C 8192
D 68608
E 3072

(3 row(s) affected)

Is there any reason for this difference?
Thanks,
--payyans

Relevant Pages

  • master.dbo.xp_fixeddrives
    ... SQL Server 2000 ... master.dbo.xp_fixeddrives stored procedure is reporting different values ... when executed by 'sa' and a regular user. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL lokaler Report. Beispiele gesucht
    ... Im "Client/Local-Mode" werden KEINE Reporting Services und kein IIS und kein SQL Server 2005 benötigt. ... Dazu ist weder ein SQL Server noch ein IIS notwendig. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)