Here is the script. It errors when it cannot connect to the database b/c, say it is in READ ONLY or restoring.... I just need to skip it...

Ah, recieving an error "incorrect syntax near 'catch'. I'm guessing this is a 2005 function. 99% of the servers will be for 2000.

Right. But what is the benefit to make the IDs different? Example could be, I have a Login on the Server as 'TOPHER'. Within a database, I...

What I need to do is grab users from sp_helpuser for the 'lgoinname' field. this is incorrect in sysusers as for some reason it drops the domain prefix.

Understood. So, if you have three nodes w/in your Cluster, where is the data actually being stored? Obviously, it could not be stored on one of the nodes...

I recieve an error.....

RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

Msg 22001, Level 1, State 1

How about Domain? 🙂 ?? We easily have 10+ domains and for scripting purposes, this infomation needs to be pulled for reporting. Hopefuly it is as simple as...

That view did not give me really the information I was looking for...

Also, any know of my first two Q's?

Thanks Again

Topher.

I'm still confused on how to grab the message. Obviously it can't be in the rs.value.... And, I do not have the ability to create tables as some can...

Some simple SP that displays a message rather than result. Say, sp_addlogin. That wold be a good example.

Also, from a previous post, I have used tsql...

..would you happen to have an example or able to explain. The script above I wrote fairly quickly and haven't had too much time to play with it. ...

I'm not concerned about the output of a stored procedure that provides results. I need the output of ones that do not.

Example would be, I need to...

No go. When I simple run this exec sp_grantdbaccess 'cbtestdbo';select @@error 'error', no results are displayed.

I can see it try to display somethign when I test this in query,...

Right. And this method would be created a new SP which is a DBA function which I would not have the ability to do.

Steve,

I'm kind of confused on how I would go about doing so...? I apologize for my confusion!!!!

I appreciate the help!!!!!!!