Forum Replies Created

Viewing 15 posts - 7,081 through 7,095 (of 9,720 total)

  • RE: BCP in

    jez.lisle (10/26/2010)

    EDIT: You may also have to put the -S + @@ServerName before the -T. You need the server to log into before the credentials, I believe. But test 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.

    October 26, 2010 at 7:40 am

    #1242251

  • RE: "Sysadmin required" - A question

    Thanks, Michael. I know what the fixed server roles do. What I'm trying to figure out is what they might not cover that would be necessary for a DBA who...

    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.

    October 26, 2010 at 5:38 am

    #1242164

  • RE: SQL Server 2005 setup failing

    Glad I could help.

    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.

    October 26, 2010 at 5:35 am

    #1242162

  • RE: BCP in

    Do you realize your specified field terminator is not the same as what's in the file?

    You're specifying a comma. The field terminator appears to be a semicolon.

    EDIT: You may also...

    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.

    October 26, 2010 at 5:30 am

    #1242158

  • RE: Team Foundation Server

    Sorry I wasn't able to help you further.

    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.

    October 26, 2010 at 5:25 am

    #1242153

  • RE: Today's Random Word!

    Halloween

    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.

    October 26, 2010 at 5:23 am

    #1242151

  • RE: How to kill a process in sql server

    You really need to find out why the backup is being blocked. Check your error logs, check the default trace, run a server side trace, whatever you have to. But...

    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.

    October 26, 2010 at 5:14 am

    #1242146

  • RE: tempdb woes - space not freeing up during SP

    pitcher166 (10/25/2010)

    Dynamic sql is not bad in any case. You should try dynamic sql perhaps if the execution plan inside a proc is suboptimal. With dynamic sql the statements within...

    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.

    October 26, 2010 at 5:07 am

    #1242144

  • RE: tempdb woes - space not freeing up during SP

    Pam,

    Is there a reason you can't use SSIS to do this move?

    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.

    October 26, 2010 at 5:03 am

    #1242142

  • RE: SQL Server 2008 (non-R2 version) question

    And now it's time to start the upgrade discussion at my workplace. I think we might only be getting the regular version. I'd like to get R2 if I can,...

    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.

    October 26, 2010 at 5:02 am

    #1242141

  • RE: Team Foundation Server

    Yikes. So you have no one to go to for answers? That sucks.

    I'm working TFS in BIDS 2005, so there's probably a lot of setup in yours that I'm missing....

    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.

    October 25, 2010 at 11:37 am

    #1241777

  • RE: "Sysadmin required" - A question

    I'm tempted, but it's too easy to fall into the "My thread is most important so I must link it to "The Thread" " mindset. I don't want to encourage...

    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.

    October 25, 2010 at 11:32 am

    #1241772

  • RE: AntiVirus recommendations

    Whisper brings up a good point. Any anti-v solution you use will need to exclude your data and transaction files. If it doesn't, it'll bring your server to its proverbial...

    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.

    October 25, 2010 at 11:25 am

    #1241767

  • RE: Team Foundation Server

    Unfortunately, I've never seen that error. Try googling it with "Team Foundation Server". Lots of articles come up. See which one fits your situation.

    Also, do you have a TFS admin...

    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.

    October 25, 2010 at 11:01 am

    #1241756

  • RE: tempdb woes - space not freeing up during SP

    Pam,

    Just a note. Virtual Servers make no difference if they're using the same SAM setup. You need to find out if they are.

    500 records should not be causing 100...

    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.

    October 25, 2010 at 10:57 am

    #1241751

Viewing 15 posts - 7,081 through 7,095 (of 9,720 total)