Forum Replies Created

Viewing 15 posts - 9,121 through 9,135 (of 9,725 total)

  • RE: Hide in List View - Can you set it up in the Project???

    Wow. I didn't even think of that option. Thanks, Matt. I'll give that a try.

    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.

    January 17, 2008 at 8:27 am

    #769241

  • RE: Sql Server 2005 DTS Package

    I have created SSIS packages which run on a SQL 2k5 server but connect to my SQL 2000 server and do work on it without any problem.

    So if...

    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.

    January 17, 2008 at 8:26 am

    #769240

  • RE: Does renaming a server cause problems with SQL 2000 or 2005?

    Ian,

    There are other possible show stoppers. Linked servers and queries that use OPENDATASOURCE / OPENROWSET. Make sure you account for all possible objects that have references to these...

    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.

    January 17, 2008 at 8:17 am

    #769239

  • RE: Another story published!!!

    HA!

    ROTFLOL!

    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.

    January 17, 2008 at 7:15 am

    #769213

  • RE: Help with create linked server

    Then the only thing left is the firewall issue Ian mentioned.

    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.

    January 17, 2008 at 7:14 am

    #769212

  • RE: Subreport not aligning inside report upon deployment

    Tell me about it!

    At least I'm not going to waste a day's worth of "making it purty" now that I know it wasn't my fault. @=)

    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.

    January 17, 2008 at 7:13 am

    #769210

  • RE: Help with create linked server

    Try deleting the Linked Server and recreating it. Sometimes that's the only thing that can help in situations like this.

    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.

    January 17, 2008 at 7:07 am

    #769203

  • RE: Subreport not aligning inside report upon deployment

    Fiona,

    Make sure your font sizes are also all the same. This is another issue that can cause line up problems between subreports and main reports.

    Not that it helped me...

    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.

    January 17, 2008 at 7:03 am

    #769199

  • RE: Help with create linked server

    Are you sure you haven't typo'd the Server name itself?

    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.

    January 17, 2008 at 6:38 am

    #769184

  • RE: Subreport not aligning inside report upon deployment

    Fiona,

    I'm having the same problem. Everything's lined up in preview, but not in the Report Server website. I think it's a rendering issue, but I can't figure out...

    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.

    January 17, 2008 at 6:28 am

    #769181

  • RE: Help with create linked server

    That tells me the account you were using had something wrong with it. Maybe a typo or maybe a permissions issue. Once you figure out what 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.

    January 17, 2008 at 6:22 am

    #769176

  • RE: Help with create linked server

    Make sure the user account that you've got set up with this linked server has the appropriate permissions on the database for the T-SQL query you're trying to run. ...

    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.

    January 17, 2008 at 6:14 am

    #769173

  • RE: Help with create linked server

    What's the exact text of the new error message?

    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.

    January 17, 2008 at 5:53 am

    #769168

  • RE: Collation Setting Changes

    All the above suggestions are assuming you've already installed SQL Server with the wrong collation.

    If you haven't installed it yet, you can change the collation during the install...

    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.

    January 17, 2008 at 5:44 am

    #769161

  • RE: Help with create linked server

    Oh, and what service pack is running on your 2005 Cluster? SP1, SP1 with hotfix or SP2?

    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.

    January 17, 2008 at 5:34 am

    #769153

Viewing 15 posts - 9,121 through 9,135 (of 9,725 total)