Also this is sqlserver 2000.

Thanks

hi ramses2nd

I checked the data, the nesting can go upto 4/5 levels. So the I need to have as many inner select distinct.

Here is the schema and sample data:

usrGrps

id           int

Name         char(1000)

member       char(1000)

1   telecom    chan1

2   telecom    gp1

3   telecom    gp2

4   gp1        ell1

5   gp1        gp3

Id is unique

All I wanted to see was the underlying tables ...

On the open db prompt , I get a security warning message with 3 options:

cancel open MoreInfo

I say Shift+Open, the  I...

The following work around works for now, in case anybody is interested.

cnn="Driver={SQL Server}; Server=IPaddress;Address=serverIP,portNumber;Network=DBMSSOCN;Database=mydb;Uid=sqllogin;Pwd=pwd"

I am not sure why SERVER\Instance name stopped working: the networking people say that nothing changed.

-ch

Nothing as changed.

I can create a dsn from the web server to the sqlserver, connect --> works !!

I am running out of options.

All the jobs fail.

Only model and my test db are set to full recovery.

All others are set to simple.

very strange.

-chr

This is a brand new instance with master/model/msdb/tempdb databases.

I have one user database which is not live yet.

The following maintenance plans are in this instance:

Backup system dbs

Backup user dbs

The following...

Hi Norman,

This does not work. I now get the following message:

Microsoft OLE DB Provider for SQL Server error '80004005'