Thanks for the help.

It looks like finally there is an answer which is very close to what i am looking for

Take a look at:http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/c99a2163-025e-424b-82cb-78ae5dd89f44

This is the MSDN posting where i was...

I find that file_guild value is NULL for the master database irrespective of whether it is an upgraded SQL instance or a fresh install of a SQL Server instance.

Help please.

i do remember that.

However when a SQL Server instance is upgraded, the value should be NULL for all databases on the sql instance. That is not the case.

This does not seem to be as documented.

The column file_guid contains a combination of both NULL and non NULL values.

It seems to be identical for both fresh install and an...

Probably you have answered my question.

Let me verify it and let you know.

How reliable is this approach?

Is this going to be the way you have described for all upgrade paths...

I think i finally figured it out. I have a sql login abc which i am attempting to add as member of the sysadmin server role.

When i call the C#...