Found this great UDF in case anybody else requires:

http://www.novicksoftware.com/coding-in-sql/Vol3/cis-v3-N14-performannce-of-dot-net-code-sql-server-2005.htm

Thanks John,

I restored the db: was looking at the wrong spot.

Yes, these are the backup files: to be precise the backup of the MDF: dbname_datetime.BAK.

I copied the .BAK file across and am trying to restore to a newly created db...

As I have to move the files across the network. Will copy the .BAK, create blank db abd attach the file. I'll see how this goes. The backup is about...

Here is what I did:

Used the same SP with a temp table having an identity field.

Populate data from both the cursors.

Read temp table order by the identity field.

Typo:

EXECUTE showAdminsXML @gpMember

s/be execute showMembersXML @gpMember

The local works fine: tests also came up as expected. I am not sure if this is the right way:

I am trying to output an XML that I will import...

Mine is sqlserver 2000: so the cursor is local be default.

In my case : this being a qtrly report, and data is hierarchal: I think I have no other options...

I have these set to same: full backup:daily. So I would nto worry too much: jult remove the transaction backup job.

thanks ripq1011

Found this out: simple dbs having transaction log backed up does not make sense:

Do I need to have system dbs: master/model/msdb  set to full recovery?

These can...

I mean the database logs as this instance has many databases:

On SQLSERVER enterprise manager:

expand the Management:

expand the SQL Server Logs

Current log: this is 1GB+.

I would like to recycle this log...

The db options are set to simple, so I will  not worry about this.

I need to read the SQLSERVER logs.

Appreciate your time Brian, I knew this was a challange.

Found a great article, my data and requirements are similar:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q248915

If a user/member does not have users within itself than this is a group.