Newbie Question

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

From: Jeremy Byrski (Jeremy.Byrski_at_nospam.CentralR.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 13:24:14 -0000

Hi,

Could anyone point me to a link or post the code to do the following??

I would like a script that lists all the tables within a database, but only
the tables that have one or more rows.

And then the opposite... A script that displays only the tables in a
database that have no rows.

Thanks in advance,

Kind regards,
Jeremy Byrski

Relevant Pages

  • Re: Getting a list of list permissions for WSS
    ... this on a backup copy of the database so you're not hitting the live DB. ... Now when you run the script and refresh the SPS Event List which this ... my departmental Event Lists roll-up flawlessly to a single Portal list. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Get custom database properties from an Access database
    ... It doesn't matter if the VBScript process drags, since it is an independent process and so will have no effect on the user's interaction with the database. ... The user can skip merrily along, doing whatever he needs while the script invisibly figures out the current situation in the background and decides what to do about it. ... It does, but I've run into issues other places on this same network, where users needed a drive letter to a server. ...
    (microsoft.public.scripting.vbscript)
  • Re: Get custom database properties from an Access database
    ... write the script to look for an available letter, ... If you're concerned about another drive letter causing ... will have no effect on the user's interaction with the database. ... As for the server, yes, that would definitely be the way to go. ...
    (microsoft.public.scripting.vbscript)
  • Re: Sending mail to many recipients issue.
    ... not already on any lists. ... You can't legally "recode" to get around the ISP's limitations. ... Your host can set the maximum time a script is allowed to run; normally is is around 30 seconds. ... A better way to handle it would be to store the info in a database then kick off a batch job to send the mail. ...
    (comp.lang.php)
  • Re: Get custom database properties from an Access database
    ... will write the script to look for an available letter, ... If you're concerned about another drive letter causing ... will have no effect on the user's interaction with the database. ... As for the server, yes, that would definitely be the way to go. ...
    (microsoft.public.scripting.vbscript)