Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 9,725 total)

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    emily-1119612 (5/5/2010)

    >>Most of the actual SQL code is generated & issued by a 3rd party application

    So does this 3rd party support 2008?

    That's actually a huge issue with using third party...

    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.

    May 6, 2010 at 4:17 am

    #1163046

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    wodom (5/5/2010)

    It sounds like you're saying DTS has been replaced by SSIS in the newer versions.

    That's exactly what he's saying. DTS was completely taken apart and rebuilt from the ground...

    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.

    May 6, 2010 at 4:15 am

    #1163043

  • RE: Timout expired when logging in from client SSMS

    Kwisatz78 (5/5/2010)

    Sorry I am not even getting to execute code, this error happens when trying to connect to the database engine remotely.

    Walk us through the steps you're using 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.

    May 5, 2010 at 11:34 am

    #1162654

  • RE: Error in SSIS Package

    We can't see the error. The box is too small.

    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.

    May 5, 2010 at 6:07 am

    #1162373

  • RE: Timout expired when logging in from client SSMS

    How are you running through SSMS? Are you right-clicking an object in the Object Explorer and choosing execute or are you running the code directly in a query window?

    We ran...

    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.

    May 5, 2010 at 4:13 am

    #1162318

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    wodom (5/4/2010)

    What would it matter how many bits our old version has anyway? I've also been asking what kinds of differences there might be between 32 and 64 bit...

    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.

    May 4, 2010 at 3:26 pm

    #1162133

  • RE: TempDB log growth

    Sorry, I misspoke. I don't run InputBuffer anymore. I have better code now that gives me the entire context of the command instead of just the first X number of...

    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.

    May 4, 2010 at 12:53 pm

    #1162043

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    wodom (5/4/2010)

    Brandie Tarvin (5/4/2010)

    He's asking if your SQL 2000 is 64 bit or 32 bit.

    I don't know. Haven't been able to find out. We're supposed to download it from MS....

    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.

    May 4, 2010 at 12:51 pm

    #1162041

  • RE: TempDB log growth

    It doesn't matter what database you're on for the InputBuffer command (and I believe the same for the OpenTran). A SPID is unique in the whole server instance. It should...

    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.

    May 4, 2010 at 12:48 pm

    #1162040

  • RE: Timout expired when logging in from client SSMS

    Another question. Are you querying directly through SSMS or through an application or web service?

    Connection Timeout properties can hide all sorts of places and not all of them are...

    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.

    May 4, 2010 at 11:15 am

    #1161980

  • RE: Where are you?

    tosscrosby (5/4/2010)

    That's why I put the caveat in there about language nuances. I knew what you meant and I'm sure Brandie did too but a newcomer might not...

    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.

    May 4, 2010 at 11:13 am

    #1161978

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    He's asking if your SQL 2000 is 64 bit or 32 bit.

    I don't have experience with that version of Windows, but I think I heard that running 32 bit SQL...

    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.

    May 4, 2010 at 11:07 am

    #1161966

  • RE: Where are you?

    tosscrosby (5/4/2010)

    Who? The men in white coats carrying a net?

    Sorry, guys. I'm the one who called the WhiteCoats, but I thought they were going after my local...

    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.

    May 4, 2010 at 8:02 am

    #1161817

  • RE: Where are you?

    Bhuvnesh (5/3/2010)

    I dont understand why we have very few girls in database field ? , i think ROLLBACK doesnt work for them 😀

    There's a joke here I seem 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.

    May 4, 2010 at 6:11 am

    #1161724

  • RE: Different owner on the logshipped database

    Roust_m (5/3/2010)

    Brandie Tarvin (5/3/2010)

    Norecovery isn't going to help you. It'll leave the db in the same state as it is now. "Restoring".

    This is the same. If you specify "norecovery"...

    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.

    May 4, 2010 at 6:09 am

    #1161720

Viewing 15 posts - 7,981 through 7,995 (of 9,725 total)