Forum Replies Created

Viewing 15 posts - 451 through 465 (of 595 total)

  • RE: Question of the Day for 19 Jun 2007

    I think this question could have been worded better. My answer was "incorrect" because I read the question in the context of a stored procedure, which can use OUTPUT to...

  • RE: The Journey to Katmai

    Here's a bit of trivia - Katmai was Intel's code name for the original Pentium III processor. You'd think that somebody at MS would have known that

  • RE: ODBC connectivity

    In Access, right-click on any linked table and then click Linked Table Manager. Check-mark the bad tables and click OK. This will refresh the links. You don't need to delete and...

  • RE: Reverse Engineering Alias Data Yypes in SQL Server 2000

    Are ADT's compatible with the current release of Visual Studio .NET?

    A couple years ago I had done some C# programming with .NET 2003 and a SS2000 db that used UDT's...

  • RE: The 800lb Gorilla

    I cannot agree with Steve's original comment about Microsoft being "transparent".

    I have a Vista test PC that runs Windows Defender, which supposedly seeks out tracking cookies & other such nasties....

  • RE: operating system, anti virus, processes

    This sounds more like an OS-level issue, not a SQL Server issue. There are two products you could try, might shed some light on things:

    Belarc Advisor http://www.belarc.com/free_download.html can show all...

  • RE: The 800lb Gorilla

    Sure, they're the dominant IT company now that they've achieved their long-awaited monopoly status. But much of what comes out them is pure marketing hype. Any MS Partner can verify...

  • RE: Sql Server 2000 on Vista

    Slightly off-topic...

    Still trying to turn off the Vista sync center, because it still wants to sync "SQL Server 2000" (the exe, not the databases, which I suppose might make sense,...

  • RE: Upgrades

    Just go to http://wvmitchell.blogspot.com/ and in the SEARCH BLOG box type

    backup restore

    and you'll see both versions explained a little better. I just woke up from my Saturday nap 😮 still...

  • RE: Upgrades

    Maybe this will help. I am using a dumpdevice named par_pos_1, instead of using the file name method, but here are my two versions:

    (both versions start out like this)

    June 2, 2007 at 4:51 pm

    #710481

  • RE: Is a Temporary Table Really Necessary?

    Good article, and a great discussion. But let's not forget that performance should not be the only criterion - your code needs to be maintainable and extensible. Using temp tables...

  • RE: Upgrades

    If you install the original Sql 2000, then apply SP3 you will see a series of dialogs like "running script x of 11" so perhaps Sql 2005 is doing a similar...

  • RE: Upgrades

    If anybody is still watching this topic, here's another $0.02 worth.

    I believe that there are far more secret little versions of Sql 2005 than simply RTM, SP1, SP2, and SP2a.

    When...

  • RE: Idiosyncrasy

    That's too funny. I once dated a girl who ate like that. It was simply how she was raised.

  • RE: Applying LDF transactions to restored Backup

    According to the BOL, when you run RESTORE DATABASE using the NORECOVERY option, it will not roll back any uncommitted transactions and permit you to run a RESTORE LOG to apply the...

Viewing 15 posts - 451 through 465 (of 595 total)