Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 1,221 total)

  • RE: Comparing record counts from a restore test

    I don't know why, but it didn't occur to me.  Thanks for the idea!

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Backup db vs Generate SQL Script?

    Thanks, Karl.  Does this work with 2000?  We haven't yet upgraded to 2K5, that's on my list.  Unfortunately I don't have VB installed at the moment.  I tried implementing it...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: ESRI/SQL 2000 Question

    Space isn't a big issue, our largest raster DB is about 175gig and I have 163gig free on my largest partition.  We're also probably going to be doing a server...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: ESRI/SQL 2000 Question

    Thanks, Steve.  I'm slowly increasing my knowledge of ArcSDE (and honestly I'd've been happy to remain ignorant ), I just found out about...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: ESRI/SQL 2000 Question

    One of the things that I find incredibly frustrating is the lack of SQL Server "best practices" material from ESRI.  The guy who runs the system has all of the...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: ESRI/SQL 2000 Question

    It took three hours of work, not three hours to run.  It's only 43,000 rows in the specfic table.  There were a couple of false starts, then trying to figure...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: DBREINDEX

    This is my nightly DBCC run, I run it through an osql job so that the full output can be captured:

    use master
    go
    exec sp_msforeachdb @command1="print getdate() print '? checkdb' DBCC CHECKDB(?)"
    go
    exec...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Backup db vs Generate SQL Script?

    For daily maintenance, I backup databases and transaction logs.  For monthly maintenance, I script out all my databases and jobs.  A DB script recreates everything: devices, tables, user permissions, roles,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: MSDB Database

    Thanks for the link, Clive!  I had somehow overlooked the fact that you could script jobs.  I script out all my databases on a monthly basis, now I'm adding jobs...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Intro....plus....What do your SQL Maintenance Plans look like?

    Have you gotten any good responses to this?  Are you still looking for info on maintenance plans?  Since you're still posting, I'm guessing that nothing has blown up on you...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: A Refresher on Joins

    I must know -- why did the VP decree that aliases is bad?  I use them all the time in all sorts of systems, including payroll.  They're nigh unto a...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Is XML the Answer?

    Hey!  I used to be able to hold up an 80 column punch card to the light and read it!  I was proud of that former ability!

     

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Is XML the Answer?

    Thank you, Don, for this article.  I started looking at XML casually a few years before you wrote this and was immediately struck by the bloat.  I experimented with it...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: One user cannot access one form

    OK, I quit.

    It is now fixed, and you're not going to believe the resolution.

    It was a corrupt printer driver.

    I have no idea how the guy who developed it diagnosed it,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: One user cannot access one form

    I haven't looked into hidden objects, I doubt there are any.  I'm fairly sure there is no security in this database, I'll dig into it further.

    The form is visible.  The...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 1,066 through 1,080 (of 1,221 total)