Forum Replies Created

Viewing 15 posts - 181 through 195 (of 341 total)

  • RE: Cursors

    JohnG (6/18/2008)


    Please show the code that can return the number of rows in a cursor using sp_describe_cursor_columns.

    Agreed. The BOL referenced (as well as BOL I have installed on my computer)...

  • RE: What is the difference between SQL Server 2000 SP3 vs. SP4 ?

    How can I check to see if we already have this installed?

  • RE: The Green Stuff

    As long as your investment is returning greater than 5% to account for your two noted factors, you are seeing a marginal return. Anything less than 5% and you are...

  • RE: The Green Stuff

    Samuel Clough (6/17/2008)


    On this topic, I would have to highly recommend Dave Ramsey (www.daveramsey.com). While some people may see him as a little "old-fashioned" or no "sophisticated", if you...

  • RE: Text Column Updates

    I'm glad to see I'm not the only person that answered correctly but got it incorrect.

  • RE: The Vacation Dilemma

    When I take vacation, the laptop does go with me but ONLY for emergencies. I am always able to rest on vacation but since I'm the only DBA, I have...

  • RE: Dedicated Administrator Connection

    Right now, I'm having the same type of problem. I issued a simple select statement that should have completed sub-second but did not. So I clicked on stop (I'm using...

  • RE: 64-bit OS, 32-bit SQL Server 2000

    Michael Earl (6/12/2008)


    SQL 2000 will not run well in WOW on a 64 bit system.

    You need to install a 32 bit OS if you want to run 32 bit SQL...

  • RE: 64-bit OS, 32-bit SQL Server 2000

    That is precisely how we are running for the time being. I wasn't here when it was setup so I just inherited it. I do see some performance issues where...

  • RE: Dedicated Administrator Connection

    rbarryyoung (6/12/2008)


    1) There is no reason to presume that an EM "DAC" session wouldn't have the same problems, and many reasons to believe that it would hav the same...

  • RE: setting up access to sql db through ASP page

    Sounds like an interesting project. I don't know for sure if it will work but it seems that if VBScript code exists that could read the variable, it should be...

  • RE: Dedicated Administrator Connection

    goodguy (6/12/2008)


    I would like to know what the folks at Microsoft would say when they hear their beloved EM spelt out as Enterprise Mangler. LOL!

    Must be my Microsoft keyboard that...

  • RE: Dedicated Administrator Connection

    rbarryyoung (6/11/2008)


    I just always kept a session open to each of my SQL Servers.

    I had an EM session open before we started the batch. Once the batch was started, everything...

  • RE: Getting the updated data from tables

    Your original message indicated you wanted to truncate the data and I assumed you meant you wanted to truncate the table and just insert all of the records from 2000...

  • RE: Adding a minimum field to an already long sql statement

    jon pill (6/11/2008)


    So I want only to use todays date and set it so that it wont pull data from before 14:29:50 of the current day, there will be data...

Viewing 15 posts - 181 through 195 (of 341 total)