RE: help! report users permission on a SQL 2000 server

From: Fany Vargas [MSFT] (fanyv_at_online.microsoft.com)
Date: 11/22/04

  • Next message: DylanM: "RE: MSDB Permissions Error" 
    Date: Mon, 22 Nov 2004 06:37:07 GMT

    If you need to get this info for each database then you will indeed need to
    loop through each database. So using a cursor to loop through each database
    is a good option.

    Fany Vargas
    Microsoft Corporation
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Are you secure? For information about the Strategic Technology Protection
    Program and to order your FREE Security Tool Kit, please visit
    http://www.microsoft.com/security.

    Microsoft highly recommends that users with Internet access update their
    Microsoft software to better protect against viruses and security
    vulnerabilities. The easiest way to do this is to visit the following
    websites:
    http://www.microsoft.com/protect
    http://www.microsoft.com/security/guidance/default.mspx

  • Next message: DylanM: "RE: MSDB Permissions Error"

    Relevant Pages

    • RE: Number of databases on a virtual server
      ... The limits for standalone SQL Server holds true for virtual SQL Server. ... Database size --> 1,048,516 TB ... For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, ... Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. ...
      (microsoft.public.sqlserver.clustering)
    • Re: MS Access DAO -> ADO.NET Migration
      ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Database Connectivity
      ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
      (comp.lang.python)
    • Performance optimization vs satisficing (was Language Oriented Programming)
      ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
      (comp.object)
    • RE: ESENT Logging
      ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)