Re: Get all tables in sql server instance - C# Discussion Boards

make richtextbox transparent

21-Apr-08 8:13

J4amieC wrote:
A LAN connection does not mean that LAN has access to the internet!

I know that, what I meant is the solution's draw back was that it assumes that if there is an active LAN connection then there is Internet connectivity.

kamalesh574321-Apr-08 0:11

kamalesh5743

21-Apr-08 0:11

Hi all..
How can set richtextbox transparent..?
Thank you..

%#&kmpYrlHSGYG5@#($_+!@!(*JASnjshdk,cm_0ashjhdbn@#$!48mkhfbchsh))^%#W%&@YW7wsdfjw789';'][]\`~JKJQ4$!@#~)-HSKS^&*1)JK12@#@$~!1`DFGkqp][]\]?Zas;EWRG%!@~)(^&BVAG

Re: make richtextbox transparent

Blue_Boy21-Apr-08 0:36

Blue_Boy

21-Apr-08 0:36

make google search[^] frist my friend Poke tongue | ;-P

I Love T-SQL

Get all tables in sql server instance

hdv21220-Apr-08 23:57

20-Apr-08 23:57

hi how to get list of all tables that exist in my sql server instance ?
i'm using this scrpit :
select * from sys.tables
but this command return only tables that exist in Current Database.
thanks

Mustafa Ismail Mustafa21-Apr-08 0:06

21-Apr-08 0:06

How about posting here? http://www.codeproject.com/script/Forums/View.aspx?fid=1725

Blue_Boy21-Apr-08 0:19

Blue_Boy

21-Apr-08 0:19

check this

use databasename<br />
select * from information_schema.tables

or this

SELECT *<br />
FROM dbo.sysobjects

or for more information check this...[^]

I Love T-SQL

hdv21221-Apr-08 0:41

21-Apr-08 0:41

thanks for reply
this is statements is very useful for me :
select * from information_schema.columns
but this scrpit only get information from current database while i want for all databases in server.

Colin Angus Mackay21-Apr-08 1:21

Colin Angus Mackay

21-Apr-08 1:21

Then iterate over each of the databases performing the same query.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2)

My website | Blog

hdv21221-Apr-08 1:22

21-Apr-08 1:22

yes, of course.
but how to iterate through each database ?

Pete O'Hanlon21-Apr-08 1:51

Pete O'Hanlon

21-Apr-08 1:51

To identify all user defined tables on a particular instance, you would use select name from master.sys.databases where owner_sid != 0x01

Deja View - the feeling that you've seen this post before.

My blog | My articles

hdv21221-Apr-08 1:57

21-Apr-08 1:57

select name from master.sys.databases where owner_sid != 0x01
this script only list 3 database name for me :
ReportServer
ReportServerTempDB
AdventureWorks

Pete O'Hanlon21-Apr-08 2:03

Pete O'Hanlon

21-Apr-08 2:03

hdv212 wrote:
this script only list 3 database name for me :
ReportServer
ReportServerTempDB
AdventureWorks

And? How am I supposed to know what databases you have? I did state that this was per database instance so, if you think you are missing some, you need to check to see that you are hitting the right instance. For instance, you may find that one instance is running as (local) and the other as (local)\SQLExpress.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Blue_Boy21-Apr-08 3:52

Blue_Boy

21-Apr-08 3:52

enumerate list of databases by:

use master<br />
SELECT name<br />
FROM sysdatabases

I Love T-SQL

LibUsbDotNet read write USB Port

Ashfield21-Apr-08 4:50

Ashfield

21-Apr-08 4:50

IF you are using SQL Server 2005 (it doesn't work on any other)

exec sp_MSForEachDB<br />
@command1 = "use ? select '?',name,type from sysobjects where type = 'U'  "

and please post sql questions in the sql forum.

Bob
Ashfield Consultants Ltd

mihai12320-Apr-08 23:29

mihai123

20-Apr-08 23:29

Hello guys,
I am struggling for 3 days now with the problem of reading and writing form/to an usb port. For this I tried to use LibUsbDotNet. The library has a very nice and at first I though useful documentation. My problem is that I cannot reference the UsbDevice object that I want to use.
I tried to iterate through the UsbDeviceList but have no success because the List is empty (I cannot understand why) . I tried with different sticks and card reader device and the result is the same the DeviceList is empty obviosly I doing something wrong but I cannot figure what .

<br />
UsbDeviceList usbDeviceList = new UsbDeviceList();<br />
IEnumerator<usbdevice> enumerator = usbDeviceList.GetEnumerator();<br />
            while (enumerator.MoveNext())<br />
            {<br />
                usbDevice = enumerator.Current;<br />
                if (usbDevice.Info.IdVendor == infoDevice.IdVendor)<br />
                    break;<br />
            }<br />
</usbdevice>

LibUsbDotNew Library[^]

Hope some of you worked with this library and cam help me with some useful tips.

Thanks

Mustafa Ismail Mustafa21-Apr-08 0:04

21-Apr-08 0:04

Try this: http://www.icsharpcode.net/OpenSource/SharpUSBLib/default.aspx[^] but it will need this installed: http://libusb-win32.sourceforge.net/[^]

I've tried it in 2 previous projects and it works like a charm.

I haven't tried LibUsbDotNet so I can't help you with that one, sorry.

mihai12321-Apr-08 1:10

mihai123

21-Apr-08 1:10

First I did not wnat to use that library but seems that I have no other sollution.

The problem with that library is that I didn't find a decent documentation and that it isn't maintained anymore.
Also you need to install the LibUSBwin 32 first ...

If you have some documentation or if you know a link please send a reply
Thanks.

Mustafa Ismail Mustafa21-Apr-08 1:32

21-Apr-08 1:32

Sadly, no. The projects were accomplished by looking at the samples that came with the download, that gave me an idea of what to do. Their object model isn't convoluted at all from what I remember.