Viewing 15 posts - 16 through 30 (of 46 total)
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...
July 16, 2008 at 10:45 am
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 ...
July 16, 2008 at 10:36 am
Just a quick datapull. Simply going to use SQLCMD
:Connect Server1
:r c:\script.sql
:Cnnect Server2
:r c:\script.sql
July 16, 2008 at 10:23 am
Thank you very much. I was having issues combining these two...
July 11, 2008 at 9:58 am
Silly question of the day (and I don't want to use it this early). How would this wrk on 2000..?
July 11, 2008 at 8:55 am
...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...
July 10, 2008 at 3:34 pm
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.
June 20, 2008 at 12:59 pm
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...
June 20, 2008 at 12:27 pm
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
...
May 14, 2008 at 9:37 am
Silly question, to refer this back to every user, similar to help protect, would you just point that back to sysusers.name..?
May 13, 2008 at 1:03 pm
database_perms.? I believe that is for only 2005. Is that correct? I'm looking for the wonderful world of 2000.
Thnx
May 12, 2008 at 3:56 pm
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...
May 12, 2008 at 12:35 pm
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...
May 12, 2008 at 12:06 pm
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,...
May 12, 2008 at 12:04 pm
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...
May 1, 2008 at 1:04 pm
Viewing 15 posts - 16 through 30 (of 46 total)