I'm not too familar w/ sp_addlinked server.

In regards, i would need to pull this data from 100+ servers.

When create/running this proc, is this only for the session or is that...

Simple example of what I'm doing....

:connect [YourServer]

:r c:\script.sql

:connect [YourServer2]

:r c:\script.sql

Script w/in c:\script.sql

Begin

create table ##Temptable1544

(

SID ...

Just a quick datapull. Simply going to use SQLCMD

:Connect Server1

:r c:\script.sql

:Cnnect Server2

:r c:\script.sql

Thank you very much. I was having issues combining these two...

Silly question of the day (and I don't want to use it this early). How would this wrk on 2000..?

...would this suffice for both...

select a.name, b.name from sysobjects a, sysusers b

where a.uid = b.uid

Then you could simply wrap it up in a proc in comparison w/ the one I...

Absolutely agree. But, to transition everything to domain authentication (AD Groups specifically), the (unfun) cleanup process needs to be completed to the current SQL/direct IDs.

Great. I guess my concern was. If a login was delete on the server level, and recreated later, if the access would be re-established automatically.

sounds like...

As a follow up, here is my final working replacement for sp_helprotect on 2000

select u.name,cast(o.name as varchar(45))as 'object'

,case p.action

...

Silly question, to refer this back to every user, similar to help protect, would you just point that back to sysusers.name..?

database_perms.? I believe that is for only 2005. Is that correct? I'm looking for the wonderful world of 2000.

Thnx

Auhutens, to answer your Question

select b.name,a.action, category =

CASE a.action

WHEN '198' then 'Create Table'

WHEN '203' then 'Create Database'

WHEN '207' then 'Create View'

WHEN '222' then 'Create Procedure'

WHEN '228' then 'Backup Database'

WHEN...

I can see where the info is coming from somewhat..but I'm failing to see a way to tie in everything to display results.

select distinct b.name, a.action

from sysprotects a, sysusers...

Kind of. It simple needs additional info. Or, simple a way to capture more data.

But, if you know a script that is exactly the same as sp_helprotect,...

Yes, and

yes.

I orignally had it write to a file on the server. And, I ran a xp_cmdshell to copy a new file to the share in the script and...