Here is a way to get a list of the db.

It will only display dbs the user has access to

SELECT name

FROM master.dbo.sysdatabases

WHERE

               has_dbaccess(name) = 1

               AND...

You can contact me at support@mylittletools.net if you need more info about myLittleAdmin.

Do not hesitate to download the trial version and to test the live demo (http://www.mylittletools.net/livedemo/mla_sql)

As a...

Hi

I am the author of myLittleAdmin : so yes ! it is worth installing it ! 🙂

I just drop these couple of lines to remind you there 3 licences of...

Hi

You can try

SELECT TOP 1 NEWID(), * FROM yourTble ORDER BY 1

hth

el.c.

myLittleTools.net :: web-based applications

http://www.mylittletools.net

Hi

Try to put brackets [ and ] around your table name. If the name contains spaces or is a special word, this error may occur.

INSERT INTO [dstTable] (col1, col2, ...)...

You can try

SELECT name FROM master.dbo.sysdatabases WHERE has_dbaccess(name) = 1 ORDER BY name;

Regards

el.c. (http://www.mylittletools.net)

myLittleTools.net :: web-based applications