By David Wiseman (Administrator)Created 19 Feb 2008
My Rating:
Vote
Rating:
Not Rated
Views:5000
Downloads:36

List the rules within a SQL Server database.

Language:  VBScript

Compatibility

Windows XP Yes Windows 2003 Yes
Windows 2000 Yes Windows NT Unknown
Vista Unknown Windows 2008 Unknown
Description

Sample script that lists the rules within a SQL Server database.

Code

Line Numbers: On  Off      Plain Text
strDBServerName = "."
strDBName = "Northwind"

Set objSQLServer = CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure = True
objSQLServer.Connect strDBServerName

Set objDB = objSQLServer.Databases(strDBName)
Set colRules = objDB.Rules
For Each objRule In colRules
   WScript.Echo "Rule Name: "    & objRule.Name
Next

 


Got a useful script? Click here to upload!


 

  Post Comment
Order By:  
User Comments
      
Marilynlong
Posted On: 7/15/2019 5:03:37 PM [Edited 7/15/2019 5:08:16 PM]

We have to list the rules within a SQL server database those who know they can complete it in very quick way. And other who not have any information about the SQL they never leave any help with essay writing comment on this page. This page is valid for only some people not for everyone.

keria139
Posted On: 7/29/2019 6:31:56 AM [Edited 7/29/2019 6:32:20 AM]

In SQL Server 2000, you can utilize Enterprise Manager's Import/Export highlight to move databases between machines, if they are on a similar system or accident claims UK are both reachable through a similar system. Simply include the two servers in your Database adventurer.

sonia139
Posted On: 7/31/2019 9:50:50 AM

I use SQL server on a large portion of my tasks and mySQL on a large portion of my undertakings. On the off chance that you have the cash I would recommend SQL server as it has a couple of additional highlights you might search for and a more pleasant (as I would like to think) interface to the db for setting up dbs/tables. best schools in Karachi 2018

areatruck
Posted On: 9/10/2019 4:51:09 AM

Download happy wheels 3D

henryjones147
Posted On: 11/19/2019 9:42:51 AM

Thanks for providing this code. I have some problem with this line objSQLServer.Connect strDBServerName Can you elaborate on this here? help with dissertation | dissertation writing help | dissertation consulting


Posted On: 12/20/2019 7:17:52 AM

All moto x3m games for Free!

silly19
Posted On: 12/30/2019 9:59:32 AM

Our academic pursuits, along with a range of extracurricular activities, help in honing a child's skills and ensuring that he/she grows to be a mature and responsible citizen.. best cbse school in greater noida


Posted On: 1/28/2020 1:26:34 AM

The celebrities show their talent and earn a specific name among the people to gain publicity. The fleabag is the one of the great tragedy show mention in 11+ past papers with answers to promote the play. The wining and awarded play f BBC network large number of viewers reviews. The show is the big success in united state.

silly19
Posted On: 2/3/2020 11:48:20 AM

This is a wonderful constrain. I enjoyed the accruement lot. I acquisition scoring this communicator. Thanks for cropped this mensurable nub. apple authorized service center in guwahati

digitinc
Posted On: 2/22/2020 5:50:22 AM

This post is very informative on this topic. I feel strongly that love and read more on this topic. I just tripped upon your blog and wanted to say that I have really enjoyed reading your blog stations. Thanks for sharing. https://toto-connect.com/

silly19
Posted On: 3/9/2020 9:21:39 AM

Welcome to the world of gaming, where life is fast paced and interesting. There is always an adventure waiting for you online. csgo smurf

silly19
Posted On: 3/9/2020 9:25:00 AM

Our approach brings together best-in-class virtualized compute, storage, and networking infrastructure. IT services company in uae and vmware Partner in uae and load balancer in uae and security partner in uae

digitinc
Posted On: 4/8/2020 9:42:02 AM

It is a very excellent blog post. I really really love it. I hope that you continue to do your work like this in the future. Thanks for sharing this with us. https://reeldaiso.com/

kenperkins
Posted On: 4/13/2020 5:18:26 PM

As they say, nobody was born great, they all started from the first step and persevered in their fields to get where they are today. slitherio download pc

dejaolsone
Posted On: 4/25/2020 3:09:54 AM

If one day you feel like letting go of the world, keep in mind that there are many interesting things you haven't discovered yet, that's here. the impossible quiz

1234