Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 2,903 total)

  • RE: Transcender Questions

    Daniel,

    Did he get your email address and a password (not to your email)? Transcenders need that so they can provide you the code to unlock/use the software. And the code...

  • RE: Transcender Questions

    Also, it appears that YOU no longer get the key to 'unlock' the transcender. I found this out with the one I just purchased from them. You load it on...

  • RE: Y2K Strikes Again

    Steve,

    Great article but, part of it is missing.

    Quote:

    If I check the table, I see

    Unquote

    You see what????

    -SQLBill

  • RE: Transcender Questions

    #4. Not really. When you buy transcenders, you have to give them an email address and a password. You then load the transcender onto your computer. IMPORTANT! It must be...

  • RE: Maint. Plan vs. Backup Jobs

    There's a three ways that I know of to backup data for 7 days to a file (.bak) and then clear that file out.

    1. Create two jobs/maintenance plans. The first...

  • RE: Making my case !

    Will support for SQL Server 7 go away?

    Yes. Most companies only support the current and one prior version of software. The current SQL Server version is SQL Server 2000...

  • RE: dump log to tape

    Are you trying to restore the data? Or are you just trying to save a copy of it on disk instead of tape? And by disk, do you mean a...

  • RE: Attatching and detatching Database

    The easiest is by using Enterprise Manager. Select the database, right-click, go to All Tasks, and select detach database.

    -SQLBill

  • RE: Job Error. Need help ASAP.

    Have you discussed it with your network/sys admin? What time are YOU running the query? Have you tested it at the same time as the job runs? If not, then...

  • RE: Install SP3 on failover cluster....

    Let's say you have a two node cluster (node1 and node2). You initially install SQL Server on node1. Later node1 breaks and you create a new node, node3. My understanding...

  • RE: date format settings info needed

    You really should take a look at the Books OnLine (BOL). You need to understand that the way datetime is STORED is different than the way it is DISPLAYED. The...

  • RE: How much data is too much?

    BTW- that was only a years worth of data.

    -SQLBill

  • RE: How much data is too much?

    It's not so much the size of the data storage as the amount of processors and size of RAM.

    We have one database with 192+ GB of data and it has...

  • RE: Failing to restore my differential backup

    Raghu,

    Restores are sequential. So, you can restore a differential and/or transaction log backups as long as they 'belong' to the full backup that you restored. But you must remember to...

  • RE: Who is to Blame for the SQL Slammer Virus?

    Who says that it has to be MS, or the DBAs, or the Network Admins, or all three at fault (see the latest poll)? Whenever there is a virus/worm/whatever, there...

Viewing 15 posts - 2,791 through 2,805 (of 2,903 total)