Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 6,104 total)

  • RE: Linked Servers security

    Are you connecting via Windows auth over the linked server connection? If so, are you getting this error coming from a client or from EM on the SQL Server itself...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 1:23 pm

    #465735

  • RE: Help Needed : permission denied on spt_values

    quote:

    Would it be a good idea to add guest to db_denydatawriter role in master database?! I wanted to feel safe with that...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 1:21 pm

    #465734

  • RE: Domain Name Change: What will happen?

    Are they renaming the domain (using the KB article) or are they doing a side-by-side move to a domain with the proper name?

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 12:35 pm

    #465725

  • RE: identity

    quote:

    What would one do if a database started with identity as PK and then years later became larger than expected and ran...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 12:30 pm

    #465724

  • RE: Changing Authentication Modes in SQL Server 2000

    Changing to Windows Authentication Only mode won't affect the databases. For instance, when you set up a SQL Server out of the box with Windows Authentication, master, model, msdb, Northwind,...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 12:25 pm

    #465723

  • RE: xp_cmdshell

    The catch: The problem is, anybody with sysadmin privs can put it back unless you can remove the .DLL, which I don't believe you can. I think some other essential...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 12:16 pm

    #465718

  • RE: poor Question of the day 7_13_2003

    This isn't directed at Chris or anyone in particular. Need to state that up front. My intent isn't to attack anyone else here, but to point out something that I...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 12:01 pm

    #465713

  • RE: poor Question of the day 7_13_2003

    From the OpenHack 4 config and with confirmation of Richard Waymire at Microsoft.

    quote:

    I only know of ONE - the table master..spt_server_info

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 11:51 am

    #465707

  • RE: poor Question of the day 7_13_2003

    quote:

    Right 🙂 But I was doing it as a counter-example. You have a 'valid' login but you cannot login. Hence you cannot...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 8:17 am

    #465674

  • RE: poor Question of the day 7_13_2003

    quote:

    There is also the absolute minimum on permissions described.

    BTW, Brian, have you ever been on http://www.openhack.com ? It seems to be no...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 8:16 am

    #465673

  • RE: How to Encrypt or Decrypt .....

    Look for dSQLSRVD using Google. If you have sysadmin rights to the machine, you can decrypt the stored procedures, triggers, and functions.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL...

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 7:47 am

    #465666

  • RE: poor Question of the day 7_13_2003

    quote:

    put Guest into DB_Role db_denydatareader

    But this means the login still has access to master....

    K. Brian Kelley
    @kbriankelley

    July 16, 2003 at 7:44 am

    #465665

  • RE: XP active directory

    Create a temporary table. Insert into it using EXEC xp_cmdshell as the source. Then you'll have to filter through the temporary table.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL...

    K. Brian Kelley
    @kbriankelley

    July 15, 2003 at 10:35 pm

    #465625

    • Viewing 15 posts - 4,126 through 4,140 (of 6,104 total)