Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 9,725 total)

  • RE: Who Watches the Watchers?

    Grant Fritchey (12/3/2009)

    Excellent editorial. The link seems to be missing to the T-Mobile story in the UK. Any chance of posting it?

    Sorry about that. This is the same link Steve...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 3, 2009 at 6:08 am

    #1087020

  • RE: Stored procedure ignores DENY INSERT

    Seth,

    Hate to break the news to you, but if they haven't already figured that trick out, they're either new to being T-SQL writer or they're not a very good one.

    That's...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 11:38 am

    #1086692

  • RE: Stored procedure ignores DENY INSERT

    Actually, we don't allow anybody to write procs in production. We have a Dev environment, Test environment and QC environment to go through before things reach Production. Unfortunately, we're all...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 9:25 am

    #1086613

  • RE: Stored procedure ignores DENY INSERT

    GSquared (12/2/2009)

    A very common practice is to deny all rights in a database except the right to execute certain procs, then have those procs do all the DML actions. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 8:34 am

    #1086554

  • RE: Stored procedure ignores DENY INSERT

    Nope. That did NOT work. I even did a DENY INSERT on schema dbo and had the user's default schema as MySchema and had the proc saved in the schema...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 8:29 am

    #1086549

  • RE: Stored procedure ignores DENY INSERT

    Oh, now I haven't tested other schemas here. And in the database we'll be doing this in, the procs will be a different schema from the tables.

    Thanks. I'll check that...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 8:21 am

    #1086535

  • RE: Script won't run when placed into a Job step

    Okay, so you've tested the scripts using the Execute AS feature...

    What does the script affect? Just tables in a database or does it access other things outside the database?...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 8:13 am

    #1086524

  • RE: Script won't run when placed into a Job step

    I have when it's a permissions or ownership chain issue. Without seeing the script, I can't be for sure exactly what the issue is.

    You say Query Analyzer. Do you...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2009 at 8:01 am

    #1086510

  • RE: SSIS Logging

    sabyasm (11/23/2009)

    [font="Comic Sans MS"]Can type of logging be configured through configuration file? For example - a flag in config file would enable or disable the SSIS log provider for text...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 24, 2009 at 7:33 am

    #1083449

  • RE: SSIS Logging

    Go to SSIS on the menu, then Logging. After a moment, a popup window will appear.

    Look at the Details tab, plus the Containers list to the left. This is how...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 24, 2009 at 7:28 am

    #1083444

  • RE: Just SQL Auth

    danjam (11/21/2009)

    When you install SQL Server 2008, you have to specify the Widows accounts that you want to have initial administrator access. If you specify none, then you have no...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 23, 2009 at 5:28 am

    #1082887

  • RE: Just SQL Auth

    Irish Flyer (11/20/2009)

    DoD only allows SQL Server authentication for those cases where it is mandatory, such as service accounts (the accounts under which you run the SQL Server Services). ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 20, 2009 at 12:02 pm

    #1082408

  • RE: Just SQL Auth

    Darren Wallace (11/20/2009)

    I think you could effectively turn off Windows Authentication by explicitly denying BUILTIN\Everyone but I haven't tried it as I don't have a server handy that I want...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 20, 2009 at 11:54 am

    #1082399

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)

    Reality is that there are several other SQL engines that run just fine on the Windows platform and don't necessarily require AD domain authentication, although, most support it.

    I won't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 20, 2009 at 11:49 am

    #1082392

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)

    The responses so far are, typically, M$-centric...as if nothing exists outside of the AD domain where the SQL server resides that would ever require access to data in the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 20, 2009 at 5:19 am

    #1082116

Viewing 15 posts - 8,191 through 8,205 (of 9,725 total)