Forum Replies Created

Viewing 15 posts - 7,471 through 7,485 (of 9,725 total)

  • RE: exec trigger as sysadmin

    Look up "Execute AS" in Books Online. See if that will help 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.

    September 20, 2010 at 11:52 am

    #1224250

  • RE: FTP

    More details on the error message, please.

    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.

    September 20, 2010 at 11:50 am

    #1224249

  • RE: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    According to Books Online -> AWE, about AWE:

    Support for AWE is available only in the SQL Server 2005 Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems

    Relevant...

    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.

    September 20, 2010 at 11:49 am

    #1224248

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/20/2010)

    GilaMonster (9/20/2010)

    *drum roll*

    *trumpet crescendo*

    ... and I think I'll leave things here for a little while.

    Edit: And as soon as i decide not to post for a few hours,...

    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.

    September 20, 2010 at 11:46 am

    #1224246

  • RE: debugging sql server 2005 procedure

    Steve, does that method work for regular procs? Not CLR or MDX code?

    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.

    September 20, 2010 at 11:44 am

    #1224244

  • RE: Where are you?

    John Rowan (9/20/2010)

    When you come back to visit Omaha, what restaurant do you look forward to the most?

    There are several. I miss Grandmother's. That was a wonderful place... too bad...

    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.

    September 20, 2010 at 11:41 am

    #1224243

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    You're very welcome. I'm so sorry it took so long and glad that you posted you were working out of that book.

    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.

    September 20, 2010 at 11:37 am

    #1224240

  • RE: Is this a 2005 bug?

    I've had really bad experiences with ISNUMERIC() not functioning the way I expected it to. For some reason, every time I want to use it, I have to throw it...

    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.

    September 20, 2010 at 11:33 am

    #1224235

  • RE: How to find effective permissions?

    First question: Is this a Windows account or a SQL account? That makes a difference.

    If Windows, you need to find out from the AD people what Windows Groups this user...

    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.

    September 20, 2010 at 11:28 am

    #1224230

  • RE: Write blob field to Windows File system

    The best I can think of is to use SSIS to write the object to a new file. I haven't done it before, but I'm guessing you'll need an OLE...

    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.

    September 20, 2010 at 11:24 am

    #1224226

  • RE: Kick off SQL Job once file arrives

    For those of us who can't install extra little stuff because of corporate restrictions, put everything you need to do inside a ForEach container. Then set the SSIS package running...

    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.

    September 20, 2010 at 11:21 am

    #1224223

  • RE: Where are you?

    John Rowan (9/20/2010)

    Yes, we have Omaha steaks...and in the airport too. Don't get me wrong, Omaha steaks has good steaks, but I don't think they can compete with an...

    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.

    September 20, 2010 at 11:13 am

    #1224217

  • RE: Where are you?

    dlautwein (9/20/2010)

    Doesn't Omaha even have Omaha Steaks at the airport?

    Yes, they do. Right before you get to the security checkpoint. They also have a brick-n-mortar store down on L...

    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.

    September 20, 2010 at 11:12 am

    #1224215

  • RE: How Do I resolve SSMS 'is busy" issue

    Jim,

    Did Chris's solution work for you? Or are you still having the problem?

    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.

    September 20, 2010 at 10:15 am

    #1224170

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    cranmer.mark (9/18/2010)

    Thanks Brandie,

    Mercifully this is just a test database, and the setup is based on the 'Configuring Conflict Resolution for Merge Replication' chapter of the MCTS 70-431 textbook.

    AHA! Did...

    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.

    September 20, 2010 at 10:13 am

    #1224167

Viewing 15 posts - 7,471 through 7,485 (of 9,725 total)