Re: A couple of quick questions about SQL Server 6.5

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/19/04 

Date: Sun, 19 Sep 2004 18:22:50 +0200

Hi John,

To be honest, I'm not 100% certain. But if I'd guess, I'd guess that the proc did exist in 6.5.
Due to a disk crash, I don't have my VM Ware images with 6.5 anymore, so I guess we'll wait until
someone with 6.5 or 6.5 BOL can tell us for certain. :-) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@hotmail.com> wrote in message 
news:ens2aOmnEHA.3392@TK2MSFTNGP15.phx.gbl...
> Hi Tibor
>
> I didn't think that was in 6.5?
>
> John
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
> message news:OwymtcknEHA.3464@tk2msftngp13.phx.gbl...
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>>
>>
>> Or perhaps sp_helprotect?
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
>> news:%230$dreinEHA.3152@TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>> >
>> > 2. I believe this is by design. You may want to look at:
>> > http://tinyurl.com/5yw77
>> >
>> > John
>> >
>> > "Russell" <Russell@discussions.microsoft.com> wrote in message
>> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@microsoft.com...
>> >> I have a couple of quick questions to do with SQL 6.5.
>> >>
>> >> 1.  Is there a stored proc that I can use in conjunction with
>> >> sp_foreachtable to step though all the user tables and list the
>> > permissions
>> >> that the public role has.
>> >>
>> >> 2. When I use the generate SQL Script , to have it script up all the
>> >> logins,users and permissions. I then look at the resulting script and
> it
>> > seem
>> >> to set all the passwords to (Null). Is there a way to have the
> passwords
>> >> intact?
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: A couple of quick questions about SQL Server 6.5
    ... > Hi John, ... > Tibor Karaszi, SQL Server MVP ... >>> Tibor Karaszi, SQL Server MVP ... >>>>> to set all the passwords to. ...
    (microsoft.public.sqlserver.server)
  • Re: yukon beta
    ... Thanks for catching that, John! ... >> The beta is not publicly available. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: tracking database transaction
    ... John. ... Makes me wonder whether they use the Profiler primitives to catch this? ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Transfer local packages from SQL 2000 to SQL 2000
    ... John ... > There's a download (hyperlink about in the middle of the article, ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Status Column in sysobjects table...SQL2000
    ... Please post a sample proc that demonstrates the ... >> Dan Guzman ... >> SQL Server MVP ... even though there are no compilation errors. ...
    (microsoft.public.sqlserver.programming)