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!

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...
  • 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,...

  • 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...

  • 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...

  • 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...

  • 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!

     

  • 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...

  • 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,...

  • 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...

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