master.dbo.xp_fixeddrives

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

Date: Tue, 31 Aug 2004 19:23:11 -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.server)
  • 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)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)