Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 9,720 total)

  • RE: Help with XML - please

    There are several ways of turning this into XML. How do you want the XML document to look?

    You could have everything listed as Elements in the root:

    root

    Element1...

    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.

  • RE: Start Debug tries to build project???

    Wow. Solution is not intuitive at all, but it does exist.

    Right click the actual Solution name & go to properties. Pop-up window comes up with Configuration at top...

    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.

  • RE: How to Run Missed Scheduled Jobs/Subscriptions in MSRS '05?

    The steps above are the closest you can come to a practical solution.

    You can also look in sysjobhistory to find out which jobs did NOT run during the time frame...

    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.

  • RE: DTA Stopped unexpectedly

    I don't know. I wish I did. I have the same issue.

    I think maybe Microsoft needs to be contacted about this, but since someone else always installs our...

    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.

  • RE: Cannot see or change logon names in SQL 2005

    Glad you figured it 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.

  • RE: Replication 2005 -> 2000 as a fallback scenario

    There are so many reasons there could be such a size difference. There are a lot of "things" in SQL 2005 that causes a database restored from 2000 to...

    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.

  • RE: Cannot see or change logon names in SQL 2005

    Wait a minute. Did I read that right? You can't make any changes with the SA account either?

    Have you checked the Server's Event Log (Security) to see what...

    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.

  • RE: Cannot see or change logon names in SQL 2005

    Check with your Active Directory Admin to see how the Windows Account is set up. Does it require the password to be changed on a regular basis?

    Most likely, 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.

  • RE: Automating database restore

    We did it in a scripted job. Unfortunately, we use Litespeed for our backups, so posting my code wouldn't help you unless you also use Litespeed. Basically, though,...

    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.

  • RE: DBCC SHRINKFILE is not working as expected ??

    Oh, and regarding the BACKUP LOG... Truncate_Only option...

    Under the simple recovery model, performing a checkpoint removes the inactive part of the log without making a backup copy. This truncates 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.

  • RE: DBCC SHRINKFILE is not working as expected ??

    This is what BOL has to say regarding TruncateOnly:

    TRUNCATEONLY

    Releases all free space at the end of the file to the operating system but does not perform any page movement...

    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.

  • RE: Database Missing

    Do you actually have permissions to see ALL the databases on the servers? It could be, if you're not using a SysAdmin account, that you just can't see 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.

  • RE: Start Debug tries to build project???

    PD,

    It's set to false. But it doesn't change the fact that I can't set the Deployment Utility at all for the SSRS project, which is the problem. 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.

  • RE: Start Debug tries to build project???

    That's a nice little trick, Frank. Thanks for the suggestion.

    Unfortunately, it doesn't quite work for my setup. Apparently when you put an SSRS project in a solution 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.

  • RE: Conditional Split failing to catch bad date

    Shaun,

    I think you might be missing the point slightly.

    I don't need parens around the first part of the statement because that statement will always be true and I want 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.

Viewing 15 posts - 8,791 through 8,805 (of 9,720 total)