List the System names has sql Server installed

hi,
I need to display the system names which has sql Server installed. How it can be done in vb.net.
Help me plz
regards
Somu

All things System are in the Master Database, spend some time with there are almost 1000 stored procedures in it, those and the tables are Microsoft Property try not to use them. Hope this helps.

List table names in a database having a particular column.

Can anybody tell me how to find out whether a particular column exists in any of the tables of a database and if it does, display the table names?

Thanks

Check INFORMATION_SCHEMA.COLUMNS view in your BOL.

AMB

|||Thanks!

List of Database Users

In certain applications, it would be useful to be able to display to an
'ordinary' user, a list of other accessors of a particular database. Any
ideas how this can be done?
--
John AustinJohn
Lookup sysusers system table in the BOL
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
> In certain applications, it would be useful to be able to display to an
> 'ordinary' user, a list of other accessors of a particular database. Any
> ideas how this can be done?
> --
> John Austin|||To add on to Uri's response, other methods include executing sp_helpuser or
using DMO.
Hope this helps.
Dan Guzman
SQL Server MVP
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
> In certain applications, it would be useful to be able to display to an
> 'ordinary' user, a list of other accessors of a particular database. Any
> ideas how this can be done?
> --
> John Austin|||sysusers and sp_helpuser seem to show all the users set up for the database
-
I really want to know about those with an open connection such as can be see
n
in Enterprise Manager in 'Management', 'Current Activity', 'Process Info'
Thanks
--
John Austin
"Dan Guzman" wrote:

> To add on to Uri's response, other methods include executing sp_helpuser o
r
> using DMO.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "John Austin" <John.Austin@.nospam.nospam> wrote in message
> news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
>
>|||sp_who, for instance
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:D8EE51EF-3662-4ED7-A311-F6A26EE6F08B@.microsoft.com...
> sysusers and sp_helpuser seem to show all the users set up for the databas
e -
> I really want to know about those with an open connection such as can be s
een
> in Enterprise Manager in 'Management', 'Current Activity', 'Process Info'
> Thanks
> --
> John Austin
>
> "Dan Guzman" wrote:
>

List CRM entity attributes and data types

Hi,

I am using CRM 3.0 and have a requirement to list all the the tables, attributes names and display names and datatypes. Is there any easy way to export this information from the CRM tool or prepare a SQL query that will list the information?

You are kind of in the wrong neck of the woods, but I will try to give you a bit of help (there is a page here to go to the Microsoft Dynamics newsgroups http://www.microsoft.com/dynamics/community/newsgrouplanding.mspx)

Most of this information is available in the METABASE database in the entity and attribute tables. Not 100% sure if the display names are exactly right. They might actually be maintained in an ugly XML document.

|||Use CRM Meta Webservices. You can use the CRM SDK to get info on methods that would do this.

List Control Properties

I saw this posting below, and I just want to be clear. I have a data
set with one Column, but many rows. I would like the data to display
horizontaly, then wrap to the next line. My data is actually displayed
in through Image controls. Im pulling the images from an external
path, on the web (http://hostname/images/image.jpg)
Am I understanding correctly, I cannot do that? Is there another
control that I can use instead? If there is can someone point me in
the direction on the properties I need to use?
Thanks,
rwiethorn
*************************************************************
From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
Subject: Re: List Control Shortcomings?
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Date: 2004-05-31 12:29:15 PST
No. You can make the entire report multiple columns but you can't make
a
list repeat horizontally.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> I have a data set bound to a list control. Is there any way to configure the list control to output horizontally aswell as vertially?
>
> e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5 in
another column.
----http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0407301045.6cd21b18@.posting.google.com...
> I saw this posting below, and I just want to be clear. I have a data
> set with one Column, but many rows. I would like the data to display
> horizontaly, then wrap to the next line. My data is actually displayed
> in through Image controls. Im pulling the images from an external
> path, on the web (http://hostname/images/image.jpg)
> Am I understanding correctly, I cannot do that? Is there another
> control that I can use instead? If there is can someone point me in
> the direction on the properties I need to use?
> Thanks,
> rwiethorn
> *************************************************************
> From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
> Subject: Re: List Control Shortcomings?
> View: Complete Thread (2 articles)
> Original Format
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Date: 2004-05-31 12:29:15 PST
>
> No. You can make the entire report multiple columns but you can't make
> a
> list repeat horizontally.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Mark" <anonymous@.discussions.microsoft.com> wrote in message
> news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> > I have a data set bound to a list control. Is there any way to configure
the list control to output horizontally aswell as vertially?
> >
> > e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5
in
> another column.
>
> ----
--

List Box Page Number

Hello,

I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".

I want to be able to place the list box number next to the question, so that I will see something like:

1. Name

2. Category

3. Age

Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.

Thanks,

Michael

Hi,

Are you using any Grouping inside the list? If you are, I believe you can get the number within each list using the following expression:

=RunningValue((<Your List Grouping Field>),CountDistinct,"DataSet1") where "DataSet1" would be the name of your dataset.

If you do not have any grouping for the list, you could try using 'question id' in the expression instead.

Hope it helps.

-Aayush

|||

Aayush,

Thank You! That was exactly what I needed! Worked like a charm!

Michael